I know this has been asked before, but my situation is a little different. I don’t want to (or am not currently allowed to) store DB Creator credentials in Octopus. This is because our DBA’s want to have full control over their rollbacks, and don’t quite trust DevOps just yet.
What we want to do is have a few steps execute on failure
- Email a team of DBA’s stating that a deployment has failed, and that they need to enter DB Creator credentials in order for the rollback to proceed. The email will contain a link to the spot where they enter their creds.
- Execute a script whereby at the top, we do a
Read-Host
and await the DBA to enter the creds. - Once credentials are inserted, we continue with the script, executing a rollback under the DBA’s credentials.
This is sort of an “enhanced” Manual Intervention Step.
Is this possible?