Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364

    Unanswered: Who's starting the DTS Package (SQL 2005)

    I have a Client who has a monthly DTS Package that runs fine but cannot work out what process is starting the package,

    They have lots of Jobs that run complex DTS Packages and they are horribly named and think one of them that runs nightly may be spawning the offendor or it may even be started from an external process.

    It runs once a month at 2am and they dare not stop it or start it manually because they're not sure what it actually does.

    Anyone got any ideas ?

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    How about this:
    Code:
    SELECT  sysjobs.name
          , sysjobs.enabled
          , sysjobs.description
          , sysjobsteps.step_id
          , sysjobsteps.step_id
          , sysjobsteps.step_name
          , sysjobsteps.command
          , sysjobschedules.next_run_date
          , sysjobschedules.next_run_time
    FROM    msdb.dbo.sysjobsteps
    INNER JOIN 
            msdb.dbo.sysjobs
    ON  sysjobs.job_id          = sysjobsteps.job_id
    LEFT OUTER JOIN 
            msdb.dbo.sysjobschedules
    ON  sysjobschedules.job_id  = sysjobs.job_id
    WHERE   subsystem           = N'CmdExec'
        AND command             LIKE '%DTSRun%'
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    WooHoo

    Looks good Pootle

    I'll give it a whirl and post the results, Thanks

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •