开发者

DTS packages, SQL Server 2000

开发者 https://www.devze.com 2022-12-28 14:24 出处:网络
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 delet

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?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号