Avatar of yanci1179

asked on 

starting a job from another server

I am using SQL 2005.  I start a job in one server and on the fourth step I need to call a job that is on another server.
 this job deletes data on the second server:
--deletes data
--populates data by calling store procedures

Both servers are sql 2005, how can I can this job from another server?  I tried

EXEC [serverName].msdb.dbo.sp_start_job @job_name = 'JobName'

the job is sucessfull, but nothing is deleted or populated on the 2nd server.
Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon