sp_start_job problem....

  • Thread starter Thread starter Patrick
  • Start date Start date
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
 
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
 
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
 
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
 
Back
Top