Can you use SQL script to schedule DTS's?

• rcoul

  Grasshopper

  Points: 22

  More actions

  September 4, 2009 at 8:48 am

  #74096

  I want to start by saying I am a SQL newb and this is my first post here, so please be gentle. 🙂 At the company I work for we have many location and all run the same DTS's on the same schedule (most of the time). We have came up with a way of getting all the scripts on the SQL servers but not scheduling them. Does anyone have a sample or know of a way to script the scheduling of jobs. We are trying to automate the repetitive task. I have been looking around but I am having a hard time finding anything.

  Thanks,

  Ray

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  September 7, 2009 at 7:07 am

  #1050099

  If you already have a job then I think the command in SQL 7/2000 is EXEC msdb.dbo.sp_addjobschedule (or something close to that)..

  Not sure if that is what you are looking for..

  CEWII

• rcoul

  Grasshopper

  Points: 22

  More actions

  September 8, 2009 at 9:06 am

  #1050582

  Thanks, I will see what I can do with that.