SQL Server – Get Maintenance Plans Execution Times

Some network meintenance requires to restart a server from now and then. When a server is shut down and a maintenance plan should be executed, it is postponed to the next possible execution time. That is, obviously, directly after the next server start. However, if a mainteancen plan is running and the server shut down, then it the plan will not be executed another time after a restart.

That means, that as a DBA you have to ensure that there is not any maintenance plan running when you schedule a restart. Whatsoever, it can be quite tricky to find out the execution times of all the maintenance plans in your SQL server. So, I help you with this:

Tags

Categories

Meta

Peter Merkert Written by:

Be First to Comment

Leave a Reply