Post reply

how to run a DTS to be managed by a JOB

  • September 15, 2006 at 10:09 am

    #103232

    I whant to run a DTS by a JOB to be programed at certain hour and a certain day, but I don't know how to do it anybody can tell me how to do that. Thanks...

  • September 15, 2006 at 10:24 am

    #660773

    Go to Enterprise Manager->Data Transformation Services->locate the package you want to schedule and Right Click on the PackageName and Select "Schedule". You will see all the options that you have. Hope this helps

    Thanks

    Sreejith

  • September 18, 2006 at 2:34 am

    #660965

    Be careful when using the wizard. It uses an encrypted ID that can change if the package is amended (IE - becomes a new package).

    Best way is to use the msdb job and specify the name fo the package.

    EXEC msdb.dbo.sp_start_job

    @job_name = 'jobname' , @server_name = 'servername'

    ------------------------------
    The Users are always right - when I'm not wrong!

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

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