Search Knowledge Base by Keyword

New Schedule

< Back

From the ETL Job Schedules tab, you can create job schedules. To create:

  1. Click the New Schedule button to bring up the New Schedule dialog
  2. Enter the properties of the new job schedule

    1. Name – Name of the job schedule (required)
    2. Priority – Choose the order the job schedule will run at the designated frequency (required)
    3. Choose the frequency the job schedule will run (required)
      1. Time Component – Select the time component (Minute, Day of Week, Month, Day of Month, Hour)
      2. Value – Select the value of the time component (e.g., 30, Monday, October, 6, 23)
        1. Select Any to match any value
      3. Ranged – Select to define a range for the selected time component (e.g., Monday through Friday)
      4. End – Select the end value of the range for the selected time component
    4. Action – Delete existing or new rows
    5. Add Component – Add new rows for additional time components
    6. Advanced Edit – Choose whether to edit the cron string manually (optional)

      1. Cron Values
        1. min – Minute values of the cron string (0-59)
        2. hr – Hour values of the cron string (0-23)
        3. dom – Day of the month values of the cron string (0-31)
        4. mon – Month values of the cron string (0-11) (0 = January, 1 = February, etc.)
        5. dow – Day of the week values of the cron string (0-6) (0 = Sunday, 1 = Monday, etc.)
      2. Special Characters
        1. * (asterisk) – Select all possible values in a field (e.g., place * in the hr field to run the task every hour)
        2. , (comma) – Used to separate multiple values (e.g., 0,3,5 in the dow field will make the task run on Sunday, Wednesday and Friday)
        3. – (hyphen) – Used to set a range of values (e.g., 10-15 in the dom field will run the task from the 10th to the 15th day of the month)
        4. / (separator) – Used to divide values (e.g., */10 in the hour field will make the task run every 10 hours)
  3. Click the Create button when finished to create the job schedule. Click the Close button to cancel the operation.