Ashif Shaikh
Default port
Points: 1445
More actions
July 31, 2014 at 5:22 am
#297214
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..
MrG78
Points: 1482
July 31, 2014 at 5:52 am
#1734011
You can set up 3 different schedules for the same job to run at those intervals
capri.tj
Grasshopper
Points: 11
August 1, 2014 at 4:13 am
#1734389
how about to schedule a job that being run every hour,and to check the hours internal in the tsql.?
umarrizwan
Old Hand
Points: 374
August 1, 2014 at 9:02 am
#1734471
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