Scheduling data generation
Last updated
Last updated
Required workspace permission: Run data generation
Not available for Structural free trials, or for expired pay-as-you-go accounts.
You can also configure data generation to run on a regular schedule. For example, if new data is added regularly to your source database, then you might want to automatically run data generation jobs to transform the new data.
To schedule the job, you configure one or more configurations. Each configuration includes a cron expression to specify the schedule.
You manage the job schedule from Jobs view.
To create a schedule for a job, click Create Schedule.
To edit an existing job schedule, click Edit Schedule.
Set up the schedule configurations, then click Save.
To add a configuration to the schedule:
Click Add Configuration.
By default, the configuration is active, and Active is in the on position. To have Structural ignore the configuration, toggle Active to the off position.
In the Cron Expression field, provide the schedule expression. The default value is
0 0 * * *
, which means to run the job every day at midnight.
From the time zone dropdown list, select the time zone to use for the schedule.
A cron expression is made up of five values separated by a space.
<minute> <hour> <day of month> <month> <day of week>
Where:
Here are some example expressions:
To remove a configuration from the schedule, click its Delete option.
If you remove all of the configurations and then save, the job is no longer scheduled.
When a job runs on a schedule, you cannot configure the options that are available from the Confirm Generation panel when you run data generation manually.
If this is in the on position, then the scheduled job does both data generation and upsert.
If this is in the off position, then the scheduled job only does the data generation to the intermediate database.
A scheduled job does not generate performance traces.
For a workspace that has subsetting configured, whether the scheduled job generates a subset is based on the .
For a workspace that has enabled, whether a scheduled job completes both the initial data generation and the upsert process is determined by the workspace setting Automatically Start Upsert After Successful Data Generation.
For a scheduled job, whether the job uses diagnostic logging is based on the .
| The minute at which to run the job. Is a value between |
| The hour at which to run the job. Is a value between Use |
| The day of the month on which to run the job. Is a value between Use Use Use |
| The month in which to run the job. Can use either numbers ( Use
Use
Use |
| The day of the week on which to run the job. Can use either numbers ( Use
Use
Use |
| Every hour at 15 minutes past the hour. |
| Every day at 10:15 AM, 2:15 PM, and 6:15 PM. |
| Midnight on the 15th of every month. |
| Midnight on June 10 through June 15th. |
| Every Tuesday at 12:30 PM. |