0

Can we run job through SSIS packages in Server1 which scheduled in server2(that job is currently disabled in server 2)

Kindly give me suggestions.

Hell Boy
  • 971
  • 2
  • 12
  • 28
  • I'm selecting SSIS because,i need to run disabled job in Server2 along with other SSIS tasks in a same SSIS package in Server1 – Hell Boy Jul 05 '16 at 08:17

1 Answers1

0

You could execute sp_start_job in Server2.

https://msdn.microsoft.com/en-us/library/ms186757.aspx

or you could try with:

enter image description here

in Package - Reference Type select External reference (VS 2010)

ɐlǝx
  • 1,384
  • 2
  • 17
  • 22