SQL Server Performance Forum – Threads Archive
Last run of a DTS
Is it possible to find out when was the last time that a DTS was run? CanadaDBANothing as such Iknow where it stores but I think the package error log file can be very useful in diagnosing problems that occur during package execution, and is particularly useful when working with scheduled packages. For each execution information is appended to the end of the file.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I have some DTS packages in production that I am not sure they are in use at all. I want to identify if they are extra or test DTS packages left by previous DBA and delete them. CanadaDBA
Modify dts packages to log their activity.
If they aren’t scheduled then I believe those are not executed since they were created, I agree with Mmarovic’s suggestion for over a period of time. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
They could be also executed from an application. If you know what applications accessing server are doing then you can remove not scheduled packages. The safest method is to add logs and after a week or a even month check which logs are not creted at all.
]]>