How can I configure an assistant to run only on weekends (Saturday and Sunday)?
Use the query: SELECT CASE WHEN DATENAME(Weekday, GETDATE()) IN ('Saturday', 'Sunday') THEN 1 ELSE 0 END
Use the query: SELECT CASE WHEN DATENAME(Weekday, GETDATE()) IN ('Saturday', 'Sunday') THEN 1 ELSE 0 END