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

Multiple Job Details Expand / Collapse
Author
Message
Posted Wednesday, April 16, 2014 8:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Hi Experts,

How can i get the details of multiple jobs like name,last run date & time,last run status ,next run etc.

Thanks in Advance.
Post #1562332
Posted Thursday, April 17, 2014 4:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:00 AM
Points: 5,014, Visits: 10,513
You can query the sql agent job tables in msdb
Or you can use a tool such as sqljobvis


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1562592
Posted Thursday, April 17, 2014 7:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:00 AM
Points: 5,014, Visits: 10,513
BTW, there's an undocumented system extended stored procedures that happens to do exactly what you're after:

EXEC xp_sqlagent_enum_jobs 1, SUSER_SNAME



--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1562651
Posted Thursday, April 17, 2014 9:37 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:00 AM
Points: 179, Visits: 682
Look at msdb..sysjobhistory and msdb..sysjobs
Post #1562728
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse