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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply