Multiple Job Details

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Or you can use a tool such as sqljobvis

-- Gianluca Sartori

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

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

djj SSCoach Points: 18831 More actions · Answer 3

SSCoach

Points: 18831

April 17, 2014 at 9:37 am

Look at msdb..sysjobhistory and msdb..sysjobs