how to schedule a sql job to run at different intervals

  • Is there a way to schedule a sql job to run at different intervals

    For eg:

    The job should run at

    7:00 Am

    8:00 AM

    and then at 10:00 Am

    Hoping to get some answers..

  • You can set up 3 different schedules for the same job to run at those intervals

  • how about to schedule a job that being run every hour,and to check the hours internal in the tsql.?

  • you can schedule a job to run each hour.

    go on schedules and create new schedule.

    schedule type should be recurring.

    in frequency bar under occurs tab select daily.

    in daily frequency select occurs every and then 1 hour.

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

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