Home Forums SQL Server 2008 SQL Server 2008 Administration Multiple Job Details RE: Multiple Job Details
spaghettidba
SSC Guru
Points: 105732
More actions
April 17, 2014 at 7:33 am
#1706753
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