Monday, January 18, 2010

Error: it(job) does not have any job server(s) defined

Today I was creating a job on SQL SERVER 2000 through SSMS 2008, and when I was trying to run the job it gave me error as

Server: Msg 14256, Level 16, State 1, Procedure sp_start_job, Line NN
Cannot start job 'XXXX' (ID NNNN) because it does not have any job server(s) defined.

Well the solution is pretty simple- In Job properties got to TARGET and check either 'Target local server' or 'Target multiple servers'.