Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Agent Jobs and a report of what is there Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 5:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 4:01 PM
Points: 3, Visits: 15
I was wondering if there is a way to schedule something that will give me a report of jobs that are in the SQL Server Agent and when they run. I would like to schedule this as well so that I have at least a weekly report of what is supposed to be running just in case of a downtime or server upgrade.

Any information is appreciated.
Post #1509616
Posted Tuesday, October 29, 2013 7:02 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:49 PM
Points: 945, Visits: 2,736
I like to use a script Michelle Ufford wrote and posted on her blog:
SQL Agent Job Script.

I make modifications to that to add/remove additional data as needed.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1509630
Posted Wednesday, October 30, 2013 4:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 4:01 PM
Points: 3, Visits: 15
Thank you so much for this post - I copied her code and it is exactly what I am looking for.
Post #1509972
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse