We have a Disaster Recovery test coming up at the end of this week.
One of the requirements from the DR team is to make sure no Automic jobs run once we bring up our Automation Engine in our DR environment.
The satisfy this requirement we would like to stop the client or all queues using the database update before we start up the application.
This is something we would never do in our Prod system so is a DR only request.
Can anyone help me with this SQL update statement?