Process to Run Script after each Environment Refresh

Owned by Jeffrey Michael Fernandez
23/08/2022
1 min read

Whenever a customer request to refresh a User Acceptance Testing Environment, Customer Support will need to run a script to set the parameter AdditionalFDPInDisrupt to 0 of all the rules linked to it

Note: This script run only applies to to a particular customer

 

As a default, the client’s UAT setting of AdditionalFDPInDisrupt parameter in all their rules is set to 0. If a refresh is requested, the change rolls back to 00:30. The reason for this is that the PROD data is copied to the UAT.

The reason there is a request made for this is that the client will need to keep the AdditionalFDPInDisrupt parameter to 0 for their testing of a particular issue in their operations.

Script:

UPDATE RuleParameterValue SET [Value] = '0:00' WHERE [Name] = 'AdditionalFdpInDisrupt'