I am using SQL Server Agent to schedule and send email. Currently, the email will be sent out at 8AM every day. My boss wants to change it to sent the email on hourly basis from 8AM-4PM.
Do I have to create one job for every hour? or if there is a better way. thanks