Post reply

Output db and log file size during DTS

  • May 17, 2005 at 3:05 pm

    #60840

    does anyone know how to query and send to an output file the db and log file sizes after each step of a DTS that runs scheduled nightly?

  • May 18, 2005 at 1:21 am

    #559483

    Create stored procedure to capture the sizes and send the email. There should be plenty of example scripts in the Script Library.

    Then put an ExecuteSQL task in between each step and have it execute your stored procedure.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply