July 31, 2014 at 5:22 am
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..
July 31, 2014 at 5:52 am
You can set up 3 different schedules for the same job to run at those intervals
August 1, 2014 at 4:13 am
how about to schedule a job that being run every hour,and to check the hours internal in the tsql.?
August 1, 2014 at 9:02 am
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