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

closed as unclear what you're asking by LowlyDBA, Tom V, Colin 't Hart, mustaccio, Philᵀᴹ Aug 10 '18 at 14:05

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • It's going to be very hard to troubleshoot your problem if all we have to work with is "it's not running". Does it run when you run it by right clicking the job and then starting it manually? Is there anything in the commandlog table ola's jobs use? Is there anything in the event log at the time the job is supposed to start?... – Tom V Aug 10 '18 at 7:26
  • @TomV it turns out that it was a PEBKAC issue. : ) The schedules had been disabled. #SimpleFix. – ivGeo Aug 10 '18 at 14:33
  • I have edited my question. Please let me know if you have any additional questions as this issue is resolved permanently and the issue was actually user error, i.e. my fault. – ivGeo Aug 10 '18 at 14:53
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

  • AARRRGH... The schedules were disabled!! PEBKAC :) – ivGeo Aug 9 '18 at 19:02

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