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.