Change the Job Owner
Should you run into an issue running the job using the sql server agent, you might need to change the job owner to SA.
This can be done with the following steps:
-
Right click on the agent job you are trying to execute.
-
go to properties.
-
You will see the second textbox has the owner. Use the ... to change the owner to SA