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