Create Job inserts scripts into the scheduler.

Syntax


CREATE JOB 'jobName' CRONTRIGGER scheduleDefinition AS { RMVQuery } [... , { RMVQuery } ]

Arguments

  • jobName: The name of the scheduled job in the Cirro system. This name is used when dropping the job. Always enclose the job name in single quotes.

  • scheduleDefinition: The cron schedule definition, in the form “seconds minutes hours dayOfMonth month dayOfWeek year”. For example, “0 0 12 * * ?”

  • RMVQuery: A refresh materialized view query. Always enclose the RMVQuery in curly brackets. Multiple queries can be included in the same job by including multiple RMVQuery statements, each enclosed in curly brackets.

Examples


EXECUTE PROJECT ID 665 ;

CREATE JOB 'job1' CRONTRIGGER '0 0 12 * * ?' AS { REFRESH MATERIALIZED VIEW "ORACLE2"."oracle"."INVENTORY"."member16" };

CREATE JOB 'job2' CRONTRIGGER '0 0 12 * * ?' AS { REFRESH MATERIALIZED VIEW "ORACLE2"."oracle"."INVENTORY"."member19" }, { REFRESH MATERIALIZED VIEW "ORACLE2"."oracle"."INVENTORY"."member20" };

See Also