Comments
Sort by recent activity
Instead of using "sa" to run the job, here is another solution:
ALTER LOGIN [domain\old_administrator_name] WITH NAME = [domain\new_administrator_name] / comments
Instead of using "sa" to run the job, here is another solution:
ALTER LOGIN [domain\old_administrator_name] WITH NAME = [domain\new_administrator_name]
Not exactly, strange behavior here... when creating a new job, the owner name is filled in with the correct renamed administrator user name. However if I go back in to view the job's properties, the job owner name has reverted back to the standard "Administrator" user name.
Edit: Suggestion from another poster on MS TechNet SQL Server forum was to make the job's owner "sa" ... I did this and now the job is successful. / comments
Not exactly, strange behavior here... when creating a new job, the owner name is filled in with the correct renamed administrator user name. However if I go back in to view the job's properties, t...