October 20, 2004 at 5:30 am
I am trying to start a job on another server but it fails as follows
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @job_name ('XML_Error_Check') does not exist.
Statement being executed:
sp_start_job @job_name = 'XML_Error_Check', @Server_Name = 'ServerName'
My privilege is sysadmin.
Any ideas please?
October 20, 2004 at 5:40 am
Have you verified that the job exists on the other server and that you don't have a typo??
Good Hunting!
AJ Ahrens
webmaster@kritter.net
October 20, 2004 at 7:24 am
Yes, the job does exist.
http://support.microsoft.com/default.aspx?scid=kb;en-us;201021
The above mentions insufficient privileges when running sp_delete_job but comes up with the same error as my start job.
October 20, 2004 at 9:12 am
What about current process/services rights on the other server?
Typical problems in this cases are, that the NTuser under which the process trying to start the job has no appropriate permission on the other server.
Botond
🙂
October 20, 2004 at 9:33 am
this might be dump question but have you setup the MSX for the job and enlist the TargetServer?
This proc is for the Multi Server Jobs that you want to start manaully through the store proc. You can't just run that proc to run remote job.
If you don't want to do MSX setup then, use the DTS package to run the job remotely but you also have to remind that this proc doesn't wait the job to be finishes. It will start it and if you have dependency in it, make sure you have other checking stuff to go next.
October 21, 2004 at 10:53 am
Hi,
you should set up the target server as linked server, and then execute
<linked server>.msdb.dbo.sp_start_job @Job_name=<jab name>
regards
karl
Best regards
karl
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply