How do I make the assistant run daily at exactly 13:00?
Use the query: SELECT CASE WHEN DATEPART(HOUR, GETDATE()) = 13 THEN 1 ELSE 0 END. Note: You must run the assistant every 60 minutes for this to work reliably.
AI Assistant
Use the query: SELECT CASE WHEN DATEPART(HOUR, GETDATE()) = 13 THEN 1 ELSE 0 END. Note: You must run the assistant every 60 minutes for this to work reliably.