DTS packages, SQL Server 2000
I'm currently in the process of cleaning up a sql server 2000 instance. I found 10 L开发者_JS百科ocal Packages that were created 4-5 years ago. In an effort to clean up old processes, I want to delete these packages. My question is, how can I determine if they are still in use. Does the start and end time on the log file suffice? Thanks!
When you open SQL Analyser--> DTS--> Local packages
, in right side, there is a column named STATUS. It shows whether package is active, inactive, running etc. You can identify directly from there !
You have checked whether any of the package are still part of a schedule?
精彩评论