I have a SQL SP that has been running fine for months but we recently move the SQL databases to a new box and now the SP aborts when running in a scheduled job. The weird thing is if I execute the SP manually it works fine. In the error log I get a log in failed when running it as a scheduled job. Any thoughts on why I would get this message?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
schedule job aborts
- Thread starter junkmail
- Start date
- Thread starter
- #3
You probably just changed the job owner to SA, but in the job steps there is an option for Run As. Make sure that is blank or has a login that exists on the new server.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question