Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

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.

share|improve this answer
    
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
add comment

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.

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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