May 28, 2008 at 1:08 pm
Comments posted to this topic are about the item Job Running time/Interval precentage
tomer lev; OWNER & CEO
http://www.datasite.co.il
Blog: http://www.tomerl.wordpress.com
July 9, 2008 at 2:57 am
This stored procedure works on SQL 2005, but fails on SQL 2000. ...Alex Lam
July 9, 2008 at 11:27 pm
what is the error u receive please?
do u have jobs enabled under your server?
tomer lev; OWNER & CEO
http://www.datasite.co.il
Blog: http://www.tomerl.wordpress.com
July 10, 2008 at 12:49 pm
Nice script but it is limited in what it reports.
1) Does not work in SQL Server 2000 because sp_help_jobschedule returns less columns in 2000
2) Does not support multiple Job schedules such as onetimes
3) Only list jobs that are scheduled to run multiple times a day
It is a very nice script to review the runtime of Jobs scheduled to run multiple times day on SQL Server 2005
David Bird
May 10, 2016 at 7:04 am
Thanks for the script.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply