August 5, 2013 at 12:37 pm
All jobs fail immediately when run manually with the error "Supply either @job_id or @job_name to identify the job. (Microsoft SQL Server, Error:14294). Nothing gets written to the job history. Same error if the step is running an SSIS or T-SQL.
All jobs run successfully when scheduled.
August 5, 2013 at 2:25 pm
Does the person executing the jobs manually have the correct permissions?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 6, 2013 at 5:37 am
Yes, full sysadmin rights and able to do everything else.
August 6, 2013 at 6:37 am
I'm not familiar with this error myself, but perhaps this may be of help. http://www.sqlservercentral.com/Forums/Topic13772-7-1.aspx
August 7, 2013 at 8:33 am
Problem solved. The sp_job_start procedure had been changed, now restored.
August 7, 2013 at 12:58 pm
Darryl Smith (8/7/2013)
Problem solved. The sp_job_start procedure had been changed, now restored.
Good to know, thanks for posting back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy