Import job

• ashaaban

  SSC Veteran

  Points: 227

  More actions

  May 5, 2009 at 12:38 pm

  #130675

  Hi

  How do I call a DTS package from sql script. I am trying to create a job to do that. also how can I know if the result of the job is failure or success. I want to be able to update a table based on that result.

• arun.sas

  SSChampion

  Points: 11831

  More actions

  May 6, 2009 at 4:42 am

  #989410

  Hi,

  See the sysjobhistory table in the msdb,

  In run_status col shows the status of the job or steps

  ARUN SAS