Skip to main content

Schedule a Job

Note

This feature may not be available in all product editions. For more information on available features, see Compare Editions.

You can define scheduled executions of your jobs to deliver outputs to known locations. You can schedule execution of jobs on source data, which can be replenished with fresh data asynchronously.

Note

Before you begin, you should verify that your data management pipeline into and out of the platform has been appropriately defined. This pipeline includes how data is written to the output location. For more information, see Overview of Scheduling.

When you schedule a job, you create two objects:

Note

You must create both of these objects to schedule a job execution.

Object

Description

Schedule

A schedule applies to the entire asset. It contains one or more intervals at which jobs are executed to deliver outputs include a scheduled destination.

Scheduled destination

A scheduled destination is an output location, format, and other settings that is populated with the results of execution.

Note

If your schedule uses an imported output object where Dataflow execution overrides have been specified, then the overrides are applied to the scheduled job. Property values that do not appear in the imported output object are taken from your execution settings. See User Execution Settings Page.

Add a Schedule

Steps:

  1. Click Schedules in the Trifacta Application.

  2. From the context menu, select Schedule.

  3. In the Add Schedule dialog, select your scheduling options:

    1. Timezone: Select the timezone to use to determine when to execute the specified schedule.

    2. Frequency: Select the time and frequency of execution: Hourly, Daily, Weekly, Monthly, or cron.

      Note

      Scheduling supports a modified version of cron scheduling syntax. For more information, see cron Schedule Syntax Reference.

    3. To add another scheduled time, click Add.

  4. To save your schedule, click Save.

A Calendar icon appears in Flow View to indicate that the flow has a schedule associated with it.

Schedule a Destination

Steps:

  1. To specify a destination for your schedule, click the asset you wish to execute at the scheduled time. If you have not done so already, create an output for it.

  2. In the right panel, locate the Scheduled destinations header. Click Add.

  3. Specify an output location, format, and updating method.

  4. Click Save.

Edit Schedule

  • To edit the scheduled times, click the Calendar icon. Then, click Edit. Make changes as needed and save.

  • To edit a scheduled destination, select the output in Flow View. In the right panel, click Edit next to the appropriate scheduled destination.

Disable Schedule

  • To disable a schedule you control, locate the schedule in the Schedules page. From the schedule's context menu, click Disable.

  • Administrators can disable any schedule in the Schedules page.

Note

If you receive an email indicating We have disabled one of your schedules when you did not choose to disable it, you need to login to Dataprep by Trifacta, which automatically refreshes your access token. Then, you can re-enable your schedule through Flow View.

Delete

Delete a schedule

Locate the schedule in the Schedules page. From the schedule's context menu, click Delete.

Delete a destination

Tip

If you have deleted the schedule for the flow, you do not need to delete the scheduled destination. It cannot run without a schedule.

  1. In Flow View, select the output.

  2. In the right panel, select Delete Outputfrom the context menu.

In this section: