sp_start_job problem....

P

Patrick

Hi All

I am facing following problem while running a job from another job...

I am writing following command to execute the another job.

Exec sp_start_job @job_name = 'CSD_Phase2_Weekly_Job'


In response of above I am receiving following Error Messege.

Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers,
Line 61
The specified @job_name ('CSD_Phase2_Weekly_Job') does not exist.

Can anyone let me know what I am doing wrong.

Waiting for reply
Thanks

Silent Ocean
 
P

Peter 'Not Peter The Spate' Nolan

Thr problem here looks to be it cannot find the name 'CSD_Phase2_Weekly_Job'
on that Server.

That doesn't mean it doesn't exist, just that it can't find it. When I have
that problem I go into jobs, copy the actual name then paste it in.

Peter

"The best argument against democracy is a five-minute conversation with the
average voter."
Winston Churchill
 
J

JaRa

can you rename the Stored Procedure since this naming is used for system
Stored Procedure and thus he will first look in the master database for this
Stored Procedure.

Better name would be : spJob_Start

-Raoul
 
S

Sue Hoegemeier

It may be related to job owners.
The owner of the first job needs to also own second job or
be a sysadmin to execute the second job.

-Sue
 
Top