Post reply

Can you use SQL script to schedule DTS's?

  • 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

  • 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

  • September 8, 2009 at 9:06 am

    #1050582

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

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

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