how to run a DTS to be managed by a JOB

  • 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...

  • 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



  • 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