I'm a new DBA trying to discover how a production Reports server is setup. I did find a Maintenance Plan. It does show to be scheduled to run in a Job at 1am each day.
Here's my dilemma: When I view the history on the Maintenance Plan the Maintenance log says it has run every day starting at various times between 7am and 8am and runs for around 4-5 hours. That is probably the worst time to be running for a production Reports server. But, when I view the Job in SQL Server Agent Activity Monitor the History shows it starts around 1am and runs for 6+ hours each day. At first I thought the Maintenance log was just showing the time it was logged when the Job completed but then the durations are not the same.
Is this maintenance Plan being run twice? I am new to SQL Server 2005 (I have 2000 experience) so is there a way for the Maintenance Plan to be scheduled outside of the Job and it is running twice? Can you tell me how to verify what is going on?