Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to list all sql server jobs Expand / Collapse
Author
Message
Posted Wednesday, July 22, 2009 3:01 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 3, 2013 10:24 AM
Points: 42, Visits: 168
Hi,

Is there any view available in sql server 2005 to list (document) all the jobs and execution time?
I found sysjobs_view but that doesn't provide frequency.

Is there any script on SSC to do this for 2005? I did not find one.

If I have to write the script, what tables/views should I query?

Our each of 9 server has 100s of jobs scheduled. It is waste of time to click on each to document.

Any help is appreciated.

Thanks,
Niki

Post #757881
Posted Wednesday, July 22, 2009 3:03 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 9, 2013 8:07 AM
Points: 1,221, Visits: 2,614
Here is what I use...


http://www.mssqltips.com/tip.asp?tip=1622


Ken Simmons
http://twitter.com/KenSimmons
Post #757883
Posted Wednesday, July 22, 2009 5:17 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 3:54 PM
Points: 4,065, Visits: 5,296
Have you looked at msdb.dbo.sp_help_job? If you run it without specifying a job, it will list all jobs.

Greg
Post #757915
Posted Thursday, July 23, 2009 3:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 2:44 AM
Points: 33, Visits: 149
U can get it from

sysjobs table
Post #758057
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse