SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by tomer lev / Job Running time/Interval precentage / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:28:08 GMT20RE: Job Running time/Interval precentagehttp://www.sqlservercentral.com/Forums/Topic507958-1302-1.aspxNice 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 20002) Does not support multiple Job schedules such as onetimes3) Only list jobs that are scheduled to run multiple times a dayIt is a very nice script to review the runtime of Jobs scheduled to run multiple times day on SQL Server 2005Thu, 10 Jul 2008 12:49:21 GMTDavid BirdRE: Job Running time/Interval precentagehttp://www.sqlservercentral.com/Forums/Topic507958-1302-1.aspxwhat is the error u receive please? do u have jobs enabled under your server?Wed, 09 Jul 2008 23:27:03 GMTtomer-726174RE: Job Running time/Interval precentagehttp://www.sqlservercentral.com/Forums/Topic507958-1302-1.aspxThis stored procedure works on SQL 2005, but fails on SQL 2000. ...Alex LamWed, 09 Jul 2008 02:57:08 GMTalex lam-402929Job Running time/Interval precentagehttp://www.sqlservercentral.com/Forums/Topic507958-1302-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Administration/63245/">Job Running time/Interval precentage</A>[/B]Wed, 28 May 2008 13:08:25 GMTtomer-726174