Post reply

Table Names that store DTS Package Info

  • December 23, 2009 at 6:13 am

    #96785

    Hello Everyone

    I have not been an admin on a SQL 2000 box in some time now, I cannot remember, or find in the list of tables in the MSDB database, the name of the tables where the DTS information and the SQL jobs are being stored.

    I need to query all the info from the table to create a report of the failed SQL jobs. I have just taken over a server that has many jobs that are failing.

    My memory is failing me, nor can I find the tables using Query Analyzer

    Thanks

    Andrew SQLDBA

  • December 23, 2009 at 7:08 am

    #1095899

    DTS info are all in tables starting sysdts%

    select name from msdb..sysobjects where name like 'sysdts%' and type = 'U'

    job info they all start sysjobs%

    select name from msdb..sysobjects where name like 'sysjob%' and type = 'U'

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

  • December 23, 2009 at 8:48 am

    #1095967

    Thanks for the reply

    I found the tables about 2 seconds after posting the message on here. What luck.

    Thank you for the info, I will keep that handy

    Andrew SQLDBA

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

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