How to schedule a job to run hourly except a particular interval

Hi Aqueel,

not knowing your exception interval I assume you want to run the hourly schedule during usual working hours the only thing you can do is to create 10 daily schedules each running at a certain time (8:00 am, 9:00am ... 4:00pm ).

Regards,

  Tino

Maybe you could manipulate this using the Condition statement of the process plan.
select top 1 UID_Person from Person where DATEPART(hour, GETUTCDATE()) NOT IN (10,11,16)

Hi Niels de Groot ,

Thanks for the response, let me give it a try and let you know.

Hi Niels de Groot ,

Thanks for the response, let me give it a try and let you know.