Create DBMS_SCHEDULER

Create DBMS_SCHEDULER

PSV_EXPORT_JOB

BEGIN

-- Job defined entirely by the CREATE JOB procedure.

DBMS_SCHEDULER.create_job (

job_name => 'TIMEOUT_GRANTS',

job_type => 'PLSQL_BLOCK',

job_action => 'BEGIN auto_processes.timeout_grants_test; END;',

start_date => SYSTIMESTAMP,

repeat_interval => 'FREQ=DAILY;BYHOUR=23;BYMINUTE=0;BYSECOND=0',

end_date => NULL,

enabled => TRUE,

comments => 'Job defined entirely by the CREATE JOB procedure.');

END;

/

BEGIN

-- Job defined entirely by the CREATE JOB procedure.

DBMS_SCHEDULER.create_job (

job_name => 'PSV_EXPORT_JOB',

job_type => 'PLSQL_BLOCK',

job_action => 'BEGIN psv_export; END;',

start_date => SYSTIMESTAMP,

repeat_interval => 'FREQ=DAILY;BYHOUR=8;BYMINUTE=0;BYSECOND=0',

end_date => NULL,

enabled => TRUE,

comments => 'Job defined entirely by the CREATE JOB procedure.');

END;

/

begin

end;

BEGIN

-- Job defined entirely by the CREATE JOB procedure.

DBMS_SCHEDULER.create_job (

job_name => 'REMINDERS',

job_type => 'PLSQL_BLOCK',

job_action => 'BEGIN ezboiler.auto_processes.first_reminders;ezboiler.auto_processes.final_reminders; END;',

start_date => SYSTIMESTAMP,

repeat_interval => 'FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0',

end_date => NULL,

enabled => TRUE,

comments => 'Job defined entirely by the CREATE JOB procedure.');

END;

/

BEGIN

-- Job defined entirely by the CREATE JOB procedure.

DBMS_SCHEDULER.create_job (

job_name => 'XML_GENERATION_JOB',

job_type => 'PLSQL_BLOCK',

job_action => 'BEGIN xml_generation.a_rated_list; xml_generation.g_rated_list; END;',

start_date => SYSTIMESTAMP,

repeat_interval => 'FREQ=MONTHLY;BYMONTHDAY=1;BYHOUR=1;BYMINUTE=0;BYSECOND=0',

end_date => NULL,

enabled => TRUE,

comments => 'Job defined entirely by the CREATE JOB procedure.');

END;

/