error code 0x534. [SQLSTATE 42000] (Error 15404)).

Today, I found that the monitoring system kept reporting errors, indicating a Job execution error. Looking at the log, I found that a user who created this Job was deleted (because he left his Job), resulting in a Job error.     
 
Date 4/27/2010 12:00:00 PM
Log Job History (Backup_Diff.Subplan_1)

Server mxosv-tress01
Job Name backup_diff. Subplan_1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator group Net Sent
Operator Paged
Retries 0
Unable to determine if The owner (MX\Randy. Admin) of job Backup_Diff.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user ‘MX\Randy.admin’, error code 0x534. [SQLSTATE 42000] (Error 15404)).
 
When our system user name changes, we will find that the previous good maintenance plan in the original SQL suddenly fails, with the above error message. The solution is to start with SQL security & GT; > Change the original system user name in the login name to the current user name, then delete the existing maintenance plan and rebuild the maintenance plan.
 

From “ITPUB blog” link: http://blog.itpub.net/35489/viewspace-661497/, if you want to reprint, please indicate the source, otherwise will be investigated for legal responsibility.

Reproduced in: http://blog.itpub.net/35489/viewspace-661497/


Read More: