SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Apparently in addition to Enabling the Maintenance Plan itself, you also need to Enable the SQL Server Agent Jobs.
SQL Server maintenance plans not running
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Scott Fischer
6
Reputation points
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.
SQL Server | Other
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jingyang Li 5,901 Reputation points Volunteer Moderator2022-11-17T20:13:49.653+00:00 Check the service account which is used to run the jobs does have permission.
Sign in to comment
2 answers
Sort by: Most helpful
-
Scott Fischer 6 Reputation points
2022-11-18T14:10:41.27+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 54%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jacob Pitsch 0 Reputation points2025-12-10T16:03:52.55+00:00 Thanks for this. I just about threw my mouse against the wall when I realized it wasn't enabled. Why would that be the default behavior?
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YufeiShao-msft 7,156 Reputation points2022-11-18T06:43:42.317+00:00 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
-------------
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.