Automating Scheduled Jobs

You can scheduling recurring jobs to automate updating data, running mastering flows, and exporting mastered datasets.

In Admin > Scheduler, you can schedule the following recurring jobs:

  • Refresh Source: This job refreshes the data in Tamr Cloud for a selected source dataset. For example, you might schedule a recurring job to refresh the data stored in a specific Snowflake table each Monday morning.
  • Update Data: This job runs the mastering flow for a selected data product, and delivers updated data to Tamr Cloud. For example, you might schedule a recurring job to run the mastering flow each Monday afternoon.
    All records are processed when mastering flow runs. For data that has not changed since the previous flow run, the existing Tamr ID is retained.
  • Publish Data Product: This job exports data to a configured destination for a selected data product. For example, you might schedule a recurring job to export data each Monday evening.

When scheduling a job, you select the frequency with which to run the job. For best results, leave a buffer of several hours between each job. The duration of each job depends on the size of the dataset and complexity of the mastering flow. Monitor how long jobs take to complete, and use that information to ensure you have an adequate buffer between jobs.

You can set one of the following frequencies for each job:

  • Every n minute (increments of 5)
    Note: Flow completion takes at least 30 minutes, depending on the number of records and steps in the flow.
  • Hourly
  • Daily
  • Weekly
  • Monthly
    Note: If you select a day that is not in every month, like the 31st, the job will not run in months that do not have that number of days.

You can edit and delete scheduled jobs, as well as pause and resume scheduled jobs.

Only admin users have access to Admin > Scheduler.

Scheduling a New Job

To schedule a new job:

  1. Navigate to Admin > Scheduler.
  2. Select Add Job.
  3. Select the job type to schedule: Refresh Source, Update Data, or Publish Data Product.
  4. In the Job Information section, provide a name and optional description for this job.
  5. Also in the Job Information section, provide the following information for the type of job you are scheduling:
    1. For Refresh Source, select the source to refresh from the Source dropdown.
    2. For Update Data, select the data product for which to run this job from the Data Product dropdown.
    3. For Publish Data Product, select:
      1. The data product for which to run this job from the Data Product dropdown.
      2. The export destination from the Destination dropdown.
  6. In the Schedule section:
    1. From the Repeat every dropdown, select the frequency with which to run the job. Then select the time to run the job:
      1. Minute: Select minute interval to run the job.
      2. Hour: Select hour interval to run the job, and number of minutes past the hour to run it.
      3. Day: Select time to run the job every day.
      4. Week: Select time and which days of the week to run the job.
    2. In the Timezones dropdown, select the time zone in which you want your automated job to run according to the set frequency.
  7. Select Add to schedule the job.
    This job appears in the Scheduler table.

Editing a Scheduled Job

To edit a scheduled job:

  1. Navigate to Admin > Scheduler.
  2. In the Scheduler table row for the job, at right, select Edit edit icon.
  3. Update the job settings as needed and select Update.

Pausing or Resuming a Job

To pause or resume a scheduled job:

  1. Navigate to Admin > Scheduler.
  2. Select the checkbox for the job in the table row for the job.
  3. Select either Pause or Resume. The job's status updates to reflect your choice.

Deleting a Scheduled Job

To delete a scheduled job:

  1. Navigate to Admin > Scheduler.
  2. Select the checkbox for the job in the table row for the job.
  3. Select Delete and confirm the deletion.