Using SSIS Transfer Job Task

• sharon-472085

  Ten Centuries

  Points: 1182

  More actions

  March 24, 2015 at 3:12 am

  #316519

  hi ,

  i use Transfer Job Task to copy jobs from one server to other. ( prinicipal to mirror)

  the probloem is :

  transfer job task give me only the ability to enable or disable jobs in mirror server !!!!

  whice its bad for me 🙂 i need to keep job at the same status like prinicipal server.....

  any help will be great 🙂

  thanks sharon

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  March 24, 2015 at 3:43 am

  #1785897

  Perhaps you can run some SQL after the transfer to set the job statuses?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel