How can I set the assistant to run twice daily—at 09:30 and 17:30?

assistant run can daily set twice

Use the query: SELECT CASE WHEN CONCAT(DATEPART(HOUR, GETDATE()), DATEPART(MINUTE, GETDATE())) IN ('930', '1730') THEN 1 ELSE 0 END. For best results, run the assistant every minute.