Skip to main content

Jobs

This section is with regards to all actions related to creating jobs to schedule the cachings.

Create job to schedule a full cache refresh on a mapping​

Creates a recurring job to do a full cache refresh on a mapping

Required information to create a job that fully refresh a cache for a mapping (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job to be created
  • {refresh_value} - The interval for which the job should be run.
  • {mapping_name} - The name of the cache for the mapping you want to fully refresh
Intervals for refresh_value

Can be one of the following values:

  1. none - Job runs only once
  2. daily - Job will run once a day
  3. monthly - Job will run once a month
  4. yearly - Job will run once a year
  5. cron_expression - A cron expression is a string comprising five or six fields separated by white space that represents a set of times, to schedule when the job should be executed. Visit here for more information
CREATE OR REPLACE JOB {job_name}
    REFRESH '{refresh_value}' 
        AS REFRESH CACHE MAPPING {mapping_name}

Create job to schedule an incremental cache refresh on a mapping​

Creates a recurring job to do a full cache refresh on a mapping

Required information to create a job that fully refresh a cache for a mapping (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job to be created
  • {refresh_value} - The interval for which the job should be run.
  • {mapping_name} - The name of the cache for the mapping you want to incrementally refresh
  • {partition_property} - The name of the property by which the cache is partitioned by
  • {days_value} - An integer representing the amount of days to subtract from the current date in order to apply the cache.
Intervals for refresh_value

Can be one of the following values:

  1. none - Job runs only once
  2. daily - Job will run once a day
  3. monthly - Job will run once a month
  4. yearly - Job will run once a year
  5. cron_expression - A cron expression is a string comprising five or six fields separated by white space that represents a set of times, to schedule when the job should be executed. Visit here for more information
CREATE OR REPLACE JOB {job_name}
    REFRESH {refresh_value}
    AS REFRESH CACHE MAPPING {mapping_name}
        WHERE {partition_property} > CURRENT_DATE - {days_value}

Create job to schedule a full cache refresh on an ontology view​

Creates a recurring job to do a full cache refresh on an ontology view

Required information to create a job that fully refresh a cache for an ontology view (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job to be created
  • {refresh_value} - The interval for which the job should be run.
  • {view_name} - The name of the cache for the ontology view you want to fully refresh
Intervals for refresh_value

Can be one of the following values:

  1. none - Job runs only once
  2. daily - Job will run once a day
  3. monthly - Job will run once a month
  4. yearly - Job will run once a year
  5. cron_expression - A cron expression is a string comprising five or six fields separated by white space that represents a set of times, to schedule when the job should be executed. Visit here for more information
CREATE OR REPLACE JOB {job_name}
    REFRESH '{refresh_value}' 
        AS REFRESH CACHE VIEW {view_name}

Create job to schedule an incremental cache refresh on an ontology view​

Creates a recurring job to do a full cache refresh on an ontology view

Required information to create a job that fully refresh a cache for an ontology view (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job to be created
  • {refresh_value} - The interval for which the job should be run.
  • {view_name} - The name of the cache for the ontology view you want to incrementally refresh
  • {partition_property} - The name of the property by which the cache is partitioned by
  • {days_value} - An integer representing the amount of days to subtract from the current date in order to apply the cache.
Intervals for refresh_value

Can be one of the following values:

  1. none - Job runs only once
  2. daily - Job will run once a day
  3. monthly - Job will run once a month
  4. yearly - Job will run once a year
  5. cron_expression - A cron expression is a string comprising five or six fields separated by white space that represents a set of times, to schedule when the job should be executed. Visit here for more information
CREATE OR REPLACE JOB {job_name}
    REFRESH {refresh_value}
    AS REFRESH CACHE VIEW {view_name}
        WHERE {partition_property} > CURRENT_DATE - {days_value}

Show SQL create job statement​

Required information for show create job (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job you want to show a create statement for. 
SHOW CREATE JOB `{job_name}`

Run a job​

Executes an existing job manually

Required information to run a job (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job to run
RUN JOB {job_name}

Remove a job​

Deletes an existing job

Required information to remove a job (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_name} - The name of the job to remove
DROP JOB {job_name}

Stop a running job​

Stops the execution of an existing running job

Required information to stop a running job (the curly brackets {} should not be an input, they are used only as a variable substitution):

  • {job_id} - The id of the job to stop
KILL JOB {job_id}