Have you ever wondered just what exactly is going on in SQL Agent, what jobs are running at the same time, and why that job now seems to be running slow, this is the tool for you.
Unfortunately the Microsoft provided tools just don't cut it.
Now you can see how your jobs interacted in history. With this information you can schedule jobs so that they don't run all over each over. Now you can see your jobs in a meaningful way!
Description:
This tool provides you with an intuitive way to view SQL job history, if you like the look of the MS Outlook calendar you will love this tool. All available history is shown in a very clean interface.
Features:
- Compatible with MS-SQL 2000, All editions including MSDE.
- Compatible with MS-SQL 2005, All editions Excluding Express (No SQL Agent).
- Compatible with MS-SQL 2008, All editions Excluding Express (No SQL Agent).
- Outlook Style Views.
- Windows(Integrated) and SQL Logins Supported.
- Multiple Levels of granularity from 1 minute to 30 minutes (1m, 5m, 6m, 10m, 15m, 20m, and 30m).
- Failed jobs shown in Red/Successful jobs shown in Green.
- Show/Hide any or all jobs so that you can focus in on the jobs you are interested in.
- Does not require "Administrator" priviledge to run client application*.
- Displays ALL available history from one server.
- Does not require ANYTHING to be installed on the server (unless you actually install the app ON the server).
- Will likely pay for itself in 1-2 uses.
Screenshots:
System Requirements:
- Windows 2000/2003/2008/XP/Vista
- .Net 2.0 Framework Runtimes
- MDAC 2.8 SP1
- About 1MB of disk space
- Read access to msdb database tables
- SQL Server must support SQL Agent
Costs:
- $25 per license
- $180 for a site license
Planned Enhancements:
- Ability to show two servers side by side to better visualize history of servers that work together.
- Secure saved connection information.
- Ability to hide jobs that are disabled.
Download:
Download Software
Notes:
* Running the application does not require administrative rights, however, setup and entry of the license key do. This is a limitation imposed due to the Microsoft Installer and the underlying licensing mechanism. Once the application is installed and licensed no special rights are required.