How to assign a specific runtime to a chain in Oracle?

Question

Oracle

Good afternoon,
I want the chain to run every day at a certain time, is it possible to do this in Oracle?

Answer 1

Creating Jobs for Chains

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
   job_name        => 'chain_job_1',
   job_type        => 'CHAIN',
   job_action      => 'my_chain1',
   repeat_interval => 'freq=daily;byhour=13;byminute=0;bysecond=0',
   enabled         => TRUE);
END;
/