Schema Audit Job Editor

Schema Audit Editor dialog box consists of five tabs:

Job Definition – edit the job name and a list of database schemas to be compared. Press Edit button located under the grid to invoke the schema objects selector dialog box. You can change a list of schemas currently defined for the job as well as add a new source/target pairs or delete existing pairs.

Schedule –modify a schedule for the job. If you want to temporarily disable a schedule, uncheck Enable Schedule checkbox located at the top of this tab. You can execute the job manually at any time using Execute popup menu at job’s node in the Object Explorer tree. The job can be found under Sentinel’s server node in Change Management -> Schema Audit Jobs folder.

Comparison Options – choose which categories of database objects should be compared as part of this schema audit job. For example, you can choose to include or ignore user privileges, such as GRANT and REVOKE permissions to database objects.

Successful Execution Actions –define which actions to take when the schema audit job is executed successfully and schema differences are found.
There are several actions available:

• Send email message with attached detailed difference report and pre-generated synchronization script to specified administrators
• Create a snapshot of entire target database schema in Sentinel’s Change Management Repository so that it can be analyzed at later time
• Execute user-defined job, previously created as Sentinel job (OS script or SQL stored procedure)

Failure Actions – define actions to take when the schema audit job fails for any reason. For example, it can fail when one of target database servers goes off-line or a network connection from Sentinel server workstation to target Informix servers becomes unavailable. You can choose to send notification email to a list of administrators or execute a user-defined job.