July 13, 2008 at 9:53 pm
Executed as user: sa. ...error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed.
The above is the error message. The job failed. This job is used to monitor the space usage of each database in a server. I cannot see syntax error.
Any input will be greatly appreciated in advance.
July 14, 2008 at 12:41 am
The error message is getting cut off. You'll need the entire message before you can find a the cause
Go into the job step. On the advanced tab there will ba an option to log output to a file. Enable that and give it a location on the server to write the file. The entire output of the job (including complete error message) should be written to that file next time the job runs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply