August 31, 2009 at 11:50 am
Hi All,
Is there a way to get an automated report/snapshot of Job Activity Monitor every morning?
Please let me know
Thanks
September 1, 2009 at 9:10 am
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
Follow @sqlscribeSeptember 2, 2009 at 9:26 am
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 😉
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply