Cannot start job 'XXXX' (ID NNNN) because it does not have any job server(s) defined.
Solution:
Well the solution is pretty simple- In Job properties got to TARGET and check either 'Target local server' or 'Target multiple servers'.
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
Subscribe to:
Posts (Atom)
Google Dataset Search
Google's Vision statement is “ to provide access to the world's information in one click. ” Google’s mission Statement is “ ...
-
Q1. WHAT is SQL Server Reporting Services(SSRS)? SQL Server Reporting Services is a server-based reporting platform that you can use to cre... -
Many times I have been asked by SSIS programmers that they face difficulties when they need to select some specified columns and rows or the... -
This is a reference answer to a post on MSDN forum but is very useful Question: While copying and renaming a file to a dynamic location...