Post reply

Job schedule to avoid one weekly time window

  • January 7, 2015 at 6:24 am

    #397838

    Hello,

    I have a SQL Agent job that needs to run every 5 minutes throughout the week but not run during the Sunday morning maintenance window. It would be perfect if the schedule started on Sunday at 06:30 and ended on Saturday at 23:00. I am having trouble making that work with the Job Schedule Properties GUI dialog. Any suggestions are appreciated!

  • January 7, 2015 at 7:54 am

    #1768456

    Ken Davis (1/7/2015)

    Hello,

    I have a SQL Agent job that needs to run every 5 minutes throughout the week but not run during the Sunday morning maintenance window. It would be perfect if the schedule started on Sunday at 06:30 and ended on Saturday at 23:00. I am having trouble making that work with the Job Schedule Properties GUI dialog. Any suggestions are appreciated!

    3 separate schedules.

    1. Weekly Schedule Mon - Friday runs every 5 minutes between 00:00:00 and 23:59:59

    2. Saturday Scheduled Every 5 Mins between 00:00:00 and 23:00:00

    3. Sunday Schedule - Every 5 mins between 06:30 and 23:59:59

    MCITP SQL 2005, MCSA SQL 2012

  • January 7, 2015 at 8:01 am

    #1768461

    Excellent. That looks just right. Thanks!

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

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