I have a built-in, regular maintenance plan scheduled to run weekly.

The databases are SharePoint databases and a snap manager (netapp snap manager) backs up these databases.

The rebuild maintenance plan is executed whenever the backup runs by the SQL server agent.

Why and how is this job being called?


Is there a SQL event being throw when the snap manager starts the backup? If so there could be an alert setup on that event which is setup to start the job. Check the SQL Agent alerts to see if it is configured to capture anything.

  • Yes, that is my guess but i am not exactly sure where to look for SQL event. The SQL alert is to send an email when the job runs/fails. – db7 May 1 '11 at 13:48
  • That's a job alert. Under SQL Agent, look under alerts. Is there anything in there? – mrdenny May 1 '11 at 19:15
  • Thank you very much Mr. Denny. You helped me to get to the root cause of this. – db7 May 3 '11 at 3:41

When a maintenance plan is created, a SQL agent job is also created to run the maintenance plan. This way, you can run the job manually or schedule it. If you look inside the steps of the SQL agent job, you will see how the maintenance plan is being called.

  • Yes, I know what you mean. But, the jobs are scheduled to run weekly. Why would the rebuild indexes kick in when the backup start to run? that is what I can't figure out. – db7 Apr 28 '11 at 13:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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