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

What jobs _would_ have run if the box was up? Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 3:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:31 AM
Points: 86, Visits: 220
Hi All,
Thanks in advance for your attention.
I have a SQL 2000 instance on a box that has started falling over recently, through no fault of SQL Server's.
We have alerting systems in place to tell us when SQL Jobs have failed but when the server itself goes off the grid, we obviously get no notifications from the SQL Agent at all.
Some jobs run on a daily basis, some weekly and some irregularly.
Is there any way of interrogating the SQL agent or the schedules to find out what jobs were supposed to have run during the blackout time, so that we can run the ones that need to "catch up"?
Many thanks
Post #1503432
Posted Thursday, October 10, 2013 4:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 2,480, Visits: 3,021
Take a look at this article (and included script): http://sqlmag.com/t-sql/plugging-gaps-sql-server-job-tracking.
Probably it will give you allready what you want. I only had to modify it slightly to fit my environment and my specific needs.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1503449
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse