December 9, 2008 at 2:41 pm
I'm just looking for someone to help point me in the right direction; I can get the details in BOL once I know the key object to look for; where to start.
I'm trying to determine the besth method (VIEW, DMV, SP, Function, etc) for getting detail level info on all jobs setup in SQL Server Agent on an instance (preferably all) of SQL Server. I had hoped the MS Sample SSRS reports would have a report for this kind of thing but they don't. There are some reports on Jobs but they show only a small amount of info about jobs.
I was thinking there must be a DMV or similiar I could use to get source data about the scheluded jobs on the server.
Suggestions?
Thanks
Kindest Regards,
Just say No to Facebook!December 9, 2008 at 3:09 pm
You can start with these tables:
msdb.dbo.sysjobs
msdb.dbo.sysjobschedules
msdb.dbo.sysjobservers
msdb.dbo.sysjobsteps
msdb.dbo.sysjobstepslogs
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 10, 2008 at 3:07 pm
Thanks Jeff, that's what I needed.
Kindest Regards,
Just say No to Facebook!Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply