stopping DTS package run

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply