-1

I set up a maintenance plan that contains three sub-plans. One sub-plan for hourly log backups, one sub-plan for daily maintenance, one for weekly maintenance. These are custom plans set up using Ola Hallengren's SQL Maintenance Solution.

The last sub-plan to successfully run was the hourly at 8 pm on the July 21st. After that nothing. No plan executions or failed executions. I have reset the schedules and still, the plan does not run. When I manually execute each sub-plan they complete successfully. The maintenance plan history does not say anything, as if the plan is just not running.

I am stumped as to what could be causing the failure of the scheduled job.

I ran a simple test job, executing Select 1 every minute for 4 minutes, and the schedule worked.



Discovered that the schedules had been disabled. I have re-enabled them and the maintenance plan is running as expected. #PEBKAC ;)

Daily Maintenance Plan Screenshot

0
3

Instead of using the Maintenance Plans feature, simply create a SQL Server Agent Job with steps for each of the tasks you've defined in the plan.

SQL Server Agent Jobs provide a far easier mechanism to control flow of jobs, and provides great success/failure alerting.

Check that the schedule for the Maintenance Plan is enabled, and set to run when you expect it to...

enter image description here

0

Not the answer you're looking for? Browse other questions tagged or ask your own question.