SQL Server maintenance plans not running

Question

None of my maintenance plans are running. They are Enabled as Recurring and scheduled to run daily or weekly, but when I select each plan and View History, they are not even attempting to run. The only History they have are the runs that I manually initiated with Execute menu option. All of those run successfully.

Answer 1

Hi @Scott Fischer ，

Please check out your error log to find more useful information, also can contain about SQLAgent.out file

It may because the SQL agent account was not sufficient permissions, the account must be a member of the sysadmin fixed server role, please check out your maintenance plan to find if something is not configured correctly

https://learn.microsoft.com/en-us/sql/relational-databases/maintenance-plans/create-a-maintenance-plan?view=sql-server-ver16

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Apparently in addition to Enabling the Maintenance Plan itself, you also need to Enable the SQL Server Agent Jobs.