Post reply

DTS Package Run Status

  • March 13, 2003 at 9:24 am

    #106369

    Can someone tell me the best way to query for success/failure status of DTS packages. I need to obtain the information like the sp_help_job.

    Kelly Ennis


    Kelly Ennis

  • March 13, 2003 at 3:42 pm

    #451054

    For SQL 2000, if package logging is enabled, you can get the success/failure of the package in msdb..sysdtspackagelog and the success/failure of each step in the package in msdb..sysdtssteplog

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

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

  • March 18, 2003 at 8:04 am

    #451340

    I appreciate your response. Would you happen to know an easy way to accomplish the same thing in SQL Server 7.0?

    Kelly Ennis


    Kelly Ennis

  • March 18, 2003 at 3:32 pm

    #451388

    In SQL7, the logging is only to a text file. From memory I think this is specified on the General tab of the Package Properties window.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

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

  • March 19, 2003 at 2:33 am

    #451419

    I run my DTS via SQL agent and use two scripts I found on this site (modified for my own use) to show failed and running jobs. I also log my important jobs to text files as stated by phillcart for further diagnosing. This way I can monitor all the jobs on all my servers simply by using two procs.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 5 posts - 1 through 4 (of 4 total)

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