stopping DTS package run

• MSSQL_NOOB

  SSCommitted

  Points: 1605

  More actions

  August 7, 2013 at 10:12 am

  #74375

  SQL2000

  How does one stop a "run-away" DTS package? The developer had ran the package from Designer (right click on package, and execute package). The package has been running for 18 hours++ and the developer had closed his designer without stopping the package execution.

  I have a job that checks for msdb..sysdtspackagelog for endtime and emails me for "unfinished" dts package. So that particular dts has no end time.

  I have ran select * from sysprocesses and kills everything with that developer's name. I can also update the sysdtspackagelog to stop the emails.

  Question:

  1) How does one stop a run-away dts package (aside from stopping it from the designer)?

  2) From my steps above, is it safe to assume that the dts package is no longer running?

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 12, 2014 at 11:56 am

  #1696501

  Identify the SPID and kill it.

  May be you can check these 2 tables msdb.dbo.sysdtspackagelog and msdb.dbo.sysdtssteplog for the status.

  --

  SQLBuddy