I set up a Maintenance Plan in SQL Server 2005, which includes multiple steps. The plan was supposed to create a log file after its execution. However, I only got the following text in the log (txt) file.
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2047
Report was generated on "SQLServer".
Maintenance Plan: Maintenance Plan 1120PM
Duration: 00:00:01
Status: Succeeded.
Details:
The problem is that there is no text under the word "Details:".
The plan takes at least three seconds to run. My guess is that the log information is only about creating the log file, not about those steps (subplans).
I created the plan with the wizard and might have done some modification after it was created.
I know that the plan did run because I looked it up from the Plan histroy.
How should I fix the problem?
Thanks in advance.
Seaport
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2047
Report was generated on "SQLServer".
Maintenance Plan: Maintenance Plan 1120PM
Duration: 00:00:01
Status: Succeeded.
Details:
The problem is that there is no text under the word "Details:".
The plan takes at least three seconds to run. My guess is that the log information is only about creating the log file, not about those steps (subplans).
I created the plan with the wizard and might have done some modification after it was created.
I know that the plan did run because I looked it up from the Plan histroy.
How should I fix the problem?
Thanks in advance.
Seaport