October 5, 2010 at 9:17 pm
Hi, i have a maintenance plan of checking database integrity which has been running fine.But suddenly the job is failing continuously.When i ran the job using t-sql its running fine.I dont understand the reason why its failing as a part of maintenance plan.the job is run under theuser 'sa'. Pls reply ur suggetions...
Error:-1)user db integrity=> Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.Could not obtain information about Windows NT group/user 'sa', error code 0xffff0002."
"**Alter failed for Server 'XYZ'**."...
2) system db integrity=> "**Alter failed for Server 'XYZ'**."...
Thnx in Advance
October 5, 2010 at 10:29 pm
From the error message it appears to be an issue with Database Mail. Please check if this discussion helps.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 5, 2010 at 11:58 pm
Just to be safe, can you run CheckDB manually.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
SQL 2005 or SQL 2000?
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
October 6, 2010 at 12:00 am
its not an issue wth db mail ..the error shown doesnt seems to be the right one. The db mail hasnot configured in that instance.
October 6, 2010 at 12:05 am
Its running fine when executed manually
October 6, 2010 at 2:12 am
I suspect there though dbmail has not been configured somewhere your job is trying to generate mail report. Check your maintenance plan or job for any such options. Also check any error in the database mail error log.
In worst case create another job with the t-sql which is executing successfully and check if runs successfully.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply