Back to Home

Create and Send Safe Script

Overview

Safe scripts are created and sent to the business when Updating or Inserting data in Production.

Process

1. Open new SQL window and use template below

USE Core_CEM
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET XACT_ABORT ON
GO
BEGIN TRANSACTION;
-- INSERT SCRIPTS HERE --
-- END OF SCRIPTS --
COMMIT TRANSACTION;

2. Save SQL file as CEM_SAFE_SCRIPT

Important !

Send the CEM_SAFE_SCRIPT.sql file to business on the proper date. The date when the safe script needs to be sent and ran depends on the request from business.

3. Send CEM_SAFE_SCRIPT.sql file to Business (Bud) via email.