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)
Job Name backup_diff. Subplan_1
Step Name (Job outcome)
Sql Severity 0
Sql Message ID 0
Operator group Net Sent
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/
- Error: cannot fetch last explain plan from plan_table
- Error: Exception was raised when calling per-thread-terminate function in extension lrwreplaymain.dl
- Error ora-00600 [ksfd] in logical standby database of DataGuard_ DECAIOPC]
- Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space
- Form Compile Issues: (FRM-18108: Failed to load the following objects)
- Gitlab service migration and gitlab administrator password retrieval
- XAException occurred. Error code is: XAER_RMERR
- Group by operator of hive execution plan
- JIRA startup failed, JIRA has been locked.
- MS SQL Could not obtain information about Windows NT group/user ‘domain\login’, error code 0x5. [SQ…
- RabbitMQ login failed
- Matlab — looking for peak function
- Insufficient space in the root directory causes the state of the managed server to become FAILED_NOT_RESTARTABLE
- Hash verification failed for CDH5.8.2 installation
- Hive view execution plan
- Linux configuration SFTP server
- Ora-00947: not enough values
- ActiveMQ installation, deployment and running
- RESTORE detected an error on page (0:0) in database