Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Jobs on SQLSERVER

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-02 : 08:30:16
Charlie writes "I am trying to run a procedure in batch to avoid dependancies between procedures. To do this I have created a job added a step and tried to start the job. I get the message below and I cannot find any info on JOB SERVERS.

Server: Msg 14256, Level 16, State 1, Procedure sp_start_job, Line 38
Cannot start job 'MIREFRESH' (ID 23229FF3-4C41-487C-8324-7D59B9695B91) because it does not have any job server(s) defined.

Many thanks for your help"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-02 : 12:23:49
Did you do this through Enterprise Manager? If so, on the first screen, does it say (local) for the server? Do you have MSX configured?

Tara
Go to Top of Page
   

- Advertisement -