Click the Scheduler tab at the top of the screen to display the list of jobs scheduled to run. This screen provides an overview of scheduled jobs and lets the user configure schedules for jobs to run.
The following columns appear on the Scheduler screen:
To search for a job group:
- Enter a job group name in the Search field.
- Click Search.
Scheduling Job(s) to Run
To schedule new job(s)
In the upper right-hand corner of the screen, click Create Scheduler. The Schedule Jobs screen appears.
Schedule Job screen
You will be prompted for the following information:
- Group Name — A free-form name for this job schedule.
- Scheduled Date — Enter the date when you want to run the job group, in the form mm/dd/yyyy.
- Scheduled Time — Enter the time when you want to run the job group, in the form hh:mm.
- Frequency — (Optional) Select the frequency at which you want to run this job group: Daily, Weekly, Monthly, Yearly. Default is daily if none is chosen.
- Jobs — Jobs are grouped by their Environment. Expand Environments and use the check boxes to add jobs to this group.
- When you are finished, click Save.
All of the jobs you specified for this job group will be run, serially, beginning at the appointed time.
Jobs will run serially (one after the other). If you want to run jobs simultaneously, create two schedules with the start time separated by a minute (do not start them at the exact same time).
Upon completion of each job, an e-mail message that contains job start and end times, along with the completion status, is sent to the user whose e-mail address is specified in the E mail field (in the Edit Job window).
To edit a schedule
From the Scheduler tab, click the Edit icon to the right of the schedule you want.
To delete a schedule
From the Scheduler tab, click the Delete icon to the right of the schedule you want.
Enabling and Disabling Database Constraints
Depending on the type of target database you are using, the Delphix Engine can automatically enable and disable database constraints.
The ability to enable and disable constraints ensures that the Delphix Engine can update columns that have primary key or foreign key relationships. You can set Delphix to handle constraints automatically.
Support for disabling constraints is dependent on your RDBMS. If your RDBMS does not support disabling of foreign keys, for example, constraints must be added or dropped using prescript or postscript
Creating SQL Statements to Run Before and After Jobs (For Distributed Environment)
When you create a masking job or a certification job, you can specify SQL statements to run before (prescript) you run a job and/or after (postscript) the job has completed. For example, if you want to provision a schema from the source to a target, you would use a prescript (SQL statements) to disable constraints and truncate data on the target.
You create prescript and postscript by creating a text document with the SQL statement(s) to execute. If the text file contains more than one SQL statement, each statement must be separated by a semicolon [;] EXCEPT when variables are being used in the script. Any time variables are used, a semicolon should not be used between statements until those variables are no longer needed. For example:
DECLARE @Path VARCHAR(250) [no semicolon after this statement] Set @Path='C:\temp\file.bak' [no semicolon after this statement] RESTORE DATABASE Delphix FROM DISK = @Path WITH FILE = 1; [semicolon at the end]
For information about how and where to specify the pathname for prescript and postscript files, see Creating a New Masking Job, Creating a New Certify Job, or Creating a New Provisioning Job.