Scenario:
- I have a trigger based on email messages.
- When the trigger detects an email, <a custom script that selects messages> queries a SQL Server database to decide if it should process the message.
Problem:
- The admin team applies Windows patches to our SQL Server box at approximately 2 AM on Saturday mornings.
- Emails come in during this window when the database is unavailable.
- The trigger fails and the trigger will not activate again until an admin right clicks the respective job, clicks 'Edit', then clicks 'OK'.
Question:
- In v. 5.1, is there a way to configure the trigger to retry after the outage window?