SQL Server Performance

Last run of a DTS

Discussion in 'SQL Server DTS-Related Questions' started by CanadaDBA, Jan 10, 2005.

  1. CanadaDBA New Member

    Is it possible to find out when was the last time that a DTS was run?

    CanadaDBA
  2. satya Moderator

    Nothing 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.
  3. CanadaDBA New Member

    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
  4. mmarovic Active Member

    Modify dts packages to log their activity.
  5. satya Moderator

    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.
  6. mmarovic Active Member

    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.

Share This Page