Wednesday, May 09, 2007
Good script that returns all the SQL Server jobs scheduled to run in the next 24 hours
I posted a good script today to my "SQL Server 2005 script/code sample repository" (at least I think it's good!). Check it out: http://forums.learnsqlserver.com/Default.aspx?g=posts&m=165
Basically, it's a stored procedure that you can use to see all upcoming jobs in the next "n" hours. Want to see all SQL Server jobs running in the next day?
EDIT: I also uploaded a SQL server 2005 Custom Report that you can use in SSMS :)
Basically, it's a stored procedure that you can use to see all upcoming jobs in the next "n" hours. Want to see all SQL Server jobs running in the next day?
EXEC GetJobsScheduledInTheNextNHours 24Want to see all jobs running in the next four hours?
EXEC GetJobsScheduledInTheNextNHours 4Check it out - and let me know if you find any improvements!
EDIT: I also uploaded a SQL server 2005 Custom Report that you can use in SSMS :)
