Post reply

Scheduling an Agent Job to run on specific dates across multiple months?

  • November 10, 2009 at 12:01 pm

    #139854

    Hey Guys,

    I need to schedule a job that executes an SSIS package, and the job needs to run on the 5th, 12th, 19th, and 26th of each month. What is the best way to accomplish this? I'm not sure how to schedule for multiple specific dates.

    TIA

    Code

  • November 10, 2009 at 12:22 pm

    #1077440

    Create multiple monthly schedules for the job: one that runs on day 5, one that runs on day 12, one that runs on day 19, and one that runs on day 26.

  • November 10, 2009 at 12:30 pm

    #1077444

    Duh! Thats what I get for over thinking things. Thanks. 😀

  • November 10, 2009 at 12:45 pm

    #1077459

    Code-1029433 (11/10/2009)

    Duh! Thats what I get for over thinking things. Thanks. 😀

    Glad to help. As least you didn't post back to complain that my solution was too much work. 🙂

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

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