Post reply

Creating a schedule with different times

  • May 28, 2012 at 5:43 am

    #258783

    Hello,

    I want to make in SQL Server Management Studio a new schedule. It's for a back-up.

    To make a normal schedule with the same time on each day is easy in SQL Server Agent -> Jobs -> Manage Schedules -> New Schedule, but I want the following times:

    Monday at 20.00

    Wednesday at 21.00

    Friday at 22.00

    Sunday at 23.00

    So always another time, is there anyone who can help me?

  • May 28, 2012 at 5:54 am

    #1493751

    You could use multiple schedules one for each time you need to run it at, or have a constantly running job which looks at the day of the week value and then issues a waitfor time event before continuing.

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

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