Schedule a job

After you successfully run a job, you can schedule it to run automatically. If your monthly or quarterly jobs typically load after the month or quarter has ended, you can schedule the job for the day when the data lands, but set the offset to the proper run date required for charting or reporting.

Steps

  1. On the right side of the metabar of a dataset, click Schedule.
    2. The Edit Schedule modal appears.
  2. Enter or select from the options.
    3. Option Description
    Active Enables or disables the scheduled runs of a job. Click Enabled to enable jobs to run according to the schedule, or Disabled to disable them.
    Agent The agent used to submit your job for processing. This field is not editable.
    Schedule Time Enter a time in 24-hour clock format, or use the clock icon to click and drag a time.
    Run Date Format The format of the run date in yyyy-MM-dd format. This field is not editable.
    Frequency A dropdown menu that contains options of how frequently your scheduled job should run.
    Daily
    		 Select this option from the Frequency dropdown menu to run your job every day at the scheduled time and the specified days.
    Days of Week
    		 A dropdown menu that contains the days of the week that your job should run. Select or deselect all that apply.
    Monthly
    		 Select this option from the Frequency dropdown menu to run your job every month at a specified time and date.
    Days of Month
    		 The day of the month when your scheduled job runs.
    As of (run date)
    		 The date to use as the run date. For example, if you select First of Prior Month and First of Month is set in the Days of Month option, then your run includes data from the previous month on the first day of the month.
    Day of (scan date)

    The day of the month whose data your scheduled job includes in the scan.

    Note This option is only available when you select Day of in the As of (run date) option.
    Quarterly
    		 Select this option from the Frequency dropdown menu to run your job every quarter at a specified time and date.
    Days of Month
    		 The day of the month when your scheduled job runs.
    As of (run date)

    The date to use as the run date. For example, if you select First of Prior Month and First of Month is set in the Days of Month option, then your run includes data from the previous month on the first day of the month.
    Day of (scan date)

    The day of the month whose data your scheduled job includes in the scan.

    Note This option is only available when you select Day of in the As of (run date) option.
    Month of Quarter
    		 The specific month of a given quarter whose data your scheduled job includes in the scan.
    Start Month of Q1
    		 The month to use as the starting place for the quarter.
  3. Click Save.

    4. scheduler modal screenshot

Tip You can use the -rd variable $ in your Template query on the Findings page to set dynamic dates or date ranges for your scheduled job, as shown in the following screenshot.

scheduler template with -rd screenshot

Updating the timezone

While scheduled jobs run according to the default UTC timezone, you may find you want to configure them to run according to the runId of a specific timezone.

Steps

  1. Below the score meter on the Findings page of a dataset or on the right side of the metabar, click the timezone.
    2. See screenshot...timezone selector in default UTC

    Note The default timezone is UTC, but if an alternative timezone was previously set, the one that displays may be different.

    The Update Timezone modal appears.
  2. Select an option from the dropdown menu.
  3. Click Save.

    4. Note  Scheduled jobs now use the runId of your updated timezone.

    See screenshot...scheduled job timezone of New York

Known limitations

After updating the timezone from the default UTC timezone to a different one on a dataset with multiple days of data, the dates on the Findings page charts and Metadata Bar still reflect the default UTC timezone. A fix will be included in Collibra DQ version 2023.11.