We are running SQL 2005 Standard Edition, with SP2 applied. I created a Maintenance Plan for our EOD process. You can see the outline in the attached JPG. For some reason it is not processing things in order. It seems to be running things simultaneously. Below is the log file.
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3054
Report was generated on "APR-SFLD-SQL2".
Maintenance Plan: APR EOD Process - MWF
Duration: 00:04:55
Status: Succeeded.
Details:
Do Latitude (Custodian) EOD (APR-SFLD-SQL2)
Execute Job on Local server connection
Job name: Latitude EOD (Custodian)
Task start: 2008-06-04T22:00:02.
Task end: 2008-06-04T22:00:02.
Success
Check Database Integrity Task (APR-SFLD-SQL2)
Check Database integrity on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All databases
Include indexes
Task start: 2008-06-04T22:00:02.
Task end: 2008-06-04T22:04:57.
Success
Backup Databases - Final (APR-SFLD-SQL2)
Execute Job on Local server connection
Job name: Backup Databases
Task start: 2008-06-04T22:04:57.
Task end: 2008-06-04T22:04:57.
Success
Backup Databases - Initial (APR-SFLD-SQL2)
Execute Job on Local server connection
Job name: Backup Databases
Task start: 2008-06-04T22:00:02.
Task end: 2008-06-04T22:00:02.
Success
Do InHouse EOD (APR-SFLD-SQL2)
Execute Job on Local server connection
Job name: InHouse EOD Process
Task start: 2008-06-04T22:00:02.
Task end: 2008-06-04T22:00:02.
Success
Delete Log Files (APR-SFLD-SQL2)
Maintenance Cleanup on Local server connection
Cleanup Database Backup files
File age: All files
Task start: 2008-06-04T22:04:57.
Task end: 2008-06-04T22:04:57.
Success
Any idea why this is happening or how to fix it?
Start Free Trial