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
    CanadaDBA, Jan 10, 2005
    #2

  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.
    satya, Jan 10, 2005
    #2

  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
    CanadaDBA, Jan 10, 2005
    #2

  4. mmarovic Active Member

    Modify dts packages to log their activity.
    mmarovic, Jan 10, 2005
    #2

  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.
    satya, Jan 11, 2005
    #2

  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.
    mmarovic, Jan 11, 2005
    #2

Share This Page