Day 12: Job Owner error

This is very simple but so many might get this error very often, especially when you created a maintenance plan and run it we may get below error:

 

Message

The job failed.  Unable to determine if the owner (XXX) of job DATABASE Maintenance.xx has server access (reason: Could not obtain information about Windows NT group/user ‘xxx, error code 0x534. [SQLSTATE 42000] (Error 15404)).

 

so we should always change the owner of the job to “Sa” once we create a maintenances plan and scheduled it. because we may not have access to run the job or if we are admin on the box and sql server and we are good initially, but when we left the organization and our account is disabled from windows AD group, we may get this error.

 

 

Advertisements
This entry was posted in Backup and Restore, Troubleshooting and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s