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?