In my deployment process, I want to run a script that checks the database changes. If the database changes contain the words “create table, drop table, etc” (basically anything that modifies the schema outside of stored procedure or function change, then I want a DBA to look at it. The deployment isn’t a failure, I just need a second set of eyes on it.
In this particular case, I would use the variable run condition. In your script that checks the database changes set an output variable to either
true (needs a DBA to look at it) or
false (DBA doesn’t need to look at it). Then you can leverage variable run conditions using that output variable.