I want to run a script before a SQL DB backups run using the bpnotify_start script that does some SQL maintenance such as re-indexing. Is this possible?
Also, it appears the only way for the backup to start when the script finishes is to set the Backup Start Notify Timeout.
In the past SQL backups have been initiated from the client by our DBAs using a custom script that calls the backup after doing some maintenance. We want to start pulling backups from the server instead so if a backup fails they can be initiated from the server by one of our operators.