1

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?

Improve this question
0

2 Answers 2

Reset to default
3

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.

Improve this answer
3
  • 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
    Commented May 1, 2011 at 13:48
  • That's a job alert. Under SQL Agent, look under alerts. Is there anything in there?
    – mrdenny
    Commented May 1, 2011 at 19:15
  • Thank you very much Mr. Denny. You helped me to get to the root cause of this.
    – db7
    Commented May 3, 2011 at 3:41
2

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.

Improve this answer
1
  • 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
    Commented Apr 28, 2011 at 13:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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