How to run a Remote sql job

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  October 25, 2010 at 6:41 am

  #230788

  Hi All,

  How can i execute a job from one server to other server?

  Say for example: lets Server A having backup job. so i need to execute a backup job on server b

  shall i build a linked server between two servers and

  In Server B

  exec Server A.msdb.dbo.sp_start_job 'backupjob'

  The above method correct or not?

  If any changes are there.. kinldy let me know..

  Thanks & Regards

  Balaji.G

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  October 25, 2010 at 7:09 am

  #1241552

  balaji.ganga (10/25/2010)

  ---

  Hi All,

  How can i execute a job from one server to other server?

  Say for example: lets Server A having backup job. so i need to execute a backup job on server b

  shall i build a linked server between two servers and

  In Server B

  exec Server A.msdb.dbo.sp_start_job 'backupjob'

  The above method correct or not?

  If any changes are there.. kinldy let me know..

  Thanks & Regards

  Balaji.G

  Hi

  What you are trying to do?

  What you want to execute from A server to B server ?

  Backup job is a job so you no need to run that one it will automatically run @ the specified time

  If you want to execute a query it is fine

  exec Server A.msdb.dbo.sp_start_job 'backupjob'

  if you want to run the job it will automatically run you no need to do anything

  Thanks

  Parthi

  Thanks
  Parthi