Executing two DTS Package depening on first DTS outcome.

  • Hi group,

     

    I have two DTS package, first DTS package scheduled to run everyday and second should only run on fortnightly. Here what I want is when fortnighly successfully run, daily DTS package should not run. In other words, fortnightly DTS package should run only on fortnight and rest of the days daily DTS package should run and both pacakge should not run on the same day.

     

    Any information in this direction is of great help to me. Thanks in advance.

     

     

  • You can schedule both dts packages to run in one job...

    if (datepart(dd,getdate()) = 15 )OR (datepart(dd,getdate()) = 1 )

    BEGIN

    EXEC XP_CMDSHELL 'DTSRUN.... FORTNIGHT DTS PACKAGE..' --OR you can configure the another job for fortnight dts and start the job in this step using sp_start_job....

    END

    ELSE

    BEGIN

    EXEC XP_CMDSHELL 'DTSRUN.... DAILY ORTNIGHT DTS PACKAGE..'

    END

    MohammedU
    Microsoft SQL Server MVP

  • Thanks for you help Mohammed. Much appreciated.

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

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