Job Activity Monitor Report?

Home

Author

Message

Posted Monday, August 31, 2009 11:50 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, August 31, 2009 3:56 PM
Points: 12, Visits: 34

Hi All,
Is there a way to get an automated report/snapshot of Job Activity Monitor every morning?

Please let me know

Thanks

Post #780101

Posted Tuesday, September 01, 2009 9:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 PM
Points: 1,148, Visits: 3,148

You could put the output of msdb.dbo.sysjobactivity into an SSRS report and create a subscription to deliver the report via e-mail.

Tommy

Post #780804

Posted Wednesday, September 02, 2009 9:26 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

Tommy Bollhofer (9/1/2009)

You could put the output of msdb.dbo.sysjobactivity into an SSRS report and create a subscription to deliver the report via e-mail.

Well that might work, if you want the job_id and not the job name. but it is a good start...

select name,* from msdb.dbo.sysjobactivity a join msdb..sysjobs b
on a.job_id = b.job_id

you can always make this more refined, not rough and ready like this scrappy bit of coding Wink

Post #781579

Permissions