I have a stored procudure that I want to run every day except for Saturdays and Sundays. It sends out reminder emails based on the results of a query. In the job scheduler for SQL Server2008, however there seems to be no options to configure this beyond just daily.
So then, am I correct in then assuming that the stored procedure will always have to run daily, and that I have to account for my non-weekend requirement by testing for Saturday or Sunday weekday in the script, and then not executing the sendmail portion of the script if it is a weekend day?
So then, am I correct in then assuming that the stored procedure will always have to run daily, and that I have to account for my non-weekend requirement by testing for Saturday or Sunday weekday in the script, and then not executing the sendmail portion of the script if it is a weekend day?