Create Scheduler Job
BEGIN
sys.dbms_scheduler.create_job( 
job_name => '"PERFSTAT"."JOB_PERFSTAT"',
program_name => '"PERFSTAT"."PROGRAM_PERFSTAT"',
schedule_name => '"PERFSTAT"."SCHEDULE_PERFSTAT"',
job_class => '"DEFAULT_JOB_CLASS"',
comments => 'job_perfstat',
auto_drop => FALSE,
enabled => FALSE);
sys.dbms_scheduler.set_attribute( name => '"PERFSTAT"."ALIAS"', attribute => 'job_weight', value => 1); 
sys.dbms_scheduler.enable( '"PERFSTAT"."JOB_PERFSTAT"' ); 
END;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License