I have a maintenance plan built on a SQL Server 2005 instance that rebuilds indexes, rebuilds statistics, checks for database integrity, performs a maintenance cleanup, and performs a history cleanup. This job runs once per week.
In the "Reporting and Logging" section I have the following options:
- Generate a text file report is checked
- Create a new file is selected
- A valid destination folder is identified
- Send report to an email recipient is checked
- A valid agent operator is selected
- Log extended information is checked
The job seems to complete successfully and a report is created and emailed, but the only information in the report is as follows:
Quest SLSSQLMaint Utility.
Logging on to SQL Server 'DEVSQL01' with Windows Authentication
Logged on to SQL Server 'DEVSQL01'
 Delete old text report files...
 Execution Time: 0 hrs, 0 mins, 0 secs.
 Send DBMail or SendMail report file....
 Execution Time: 0 hrs, 0 mins, 1 secs.
End of maintenance plan 'DB Maintenance Plan (No Backups) [DB Maintenance]' on 9/29/2010 8:40:49 PM (Success)
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 0 (Success)
Where is the information about the rest of the maintenance plan?&nbs
View Complete Post