Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Adnan Korkmaz,
Some background: I am not a DBA and it's my first contribution here. Sorry for any typos / errors if any in advance. I develop an application which runs on several SQL servers where I have many jobs with different schedules on each server. To be able to monitor all these servers at once, I wrote an Asp page which executes this script and summarizes the results.
Installation: You can create the script in whatever database you like, while I preferred master.
Parameters: (All parameters are optional)
Default usage lists all enabled jobs with a schedule:
You can filter to see only one job at a time:
List all jobs:
List all jobs, whose last execution time is above 1 minute:
List all jobs, whose average execution time is above 1 hour:
Last executed query total duration
Every time Store procedure take different duration to exeucte
SQL 2005 - Long duration Stored Procedure
SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.