InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:34:13 GMT20http://www.sqlservercentral.com/Forums/Topic780101-149-1.aspx[quote][b]Tommy Bollhofer (9/1/2009)[/b][hr]You could put the output of msdb.dbo.sysjobactivity into an SSRS report and create a subscription to deliver the report via e-mail.[/quote]Well that might work, if you want the job_id and not the job name. but it is a good start...[code]select name,* from msdb.dbo.sysjobactivity a join msdb..sysjobs bon a.job_id = b.job_id[/code]you can always make this more refined, not rough and ready like this scrappy bit of coding ;-)Wed, 02 Sep 2009 09:26:54 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic780101-149-1.aspxYou could put the output of msdb.dbo.sysjobactivity into an SSRS report and create a subscription to deliver the report via e-mail.Tue, 01 Sep 2009 09:10:51 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic780101-149-1.aspxHi All,Is there a way to get an automated report/snapshot of Job Activity Monitor every morning? Please let me knowThanksMon, 31 Aug 2009 11:50:16 GMTmaxedout420