title: SQL Jobs Schedule to Not Run on Holidays
body: <p>I have a SQL Agent Job that has multiple steps which are scheduled to run Monday - Friday at a certain time.  I need to be able to implement a stop feature on this job to not run on Holidays that are listed in a table. </p>
  
  <p>I don't really know how to proceed with this.  Do I need to create a first step that checks if it is a holiday and then fails the job if it is?</p>
  
  <p>I have a stored procedure that will check the date that I pass to see if it is a holiday, I just don't know how to force it to report failure if the result is yes it is a holiday.  Any help would be greatly appreciated. </p>