I wonder if there is a possibility to halt a task on server when it failed.
Let’s say, we hava task working continiuously and it should just check whether a select-statement gives an empty result. In case of a result there is a mail notification to some users who should react. I wanted to notice these persons not every 5 minutes, so I thought about a setting on the server to stop continuing until someone reacts on the server.
Do you have any idea how to realize that scenario?