oracle long sql scheduler - ghdrako/doc_snipets GitHub Wiki

Tworzymy zapytanie w schedulerze i nie musiemy czekacz na wykonanie - klient sie wylaczy zerwie polacenie

BEGIN
  DBMS_SCHEDULER.create_job (
    job_name        => 'CREATE_TABLE_JOB',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN EXECUTE IMMEDIATE ''CREATE TABLE my_table AS SELECT * FROM big_table''; END;',
    enabled         => TRUE
  );
END;
/

Monitorowanie zialania joba - znika po zakonczeniu

SELECT job_name, enabled, state, last_start_date, next_run_date
FROM dba_scheduler_jobs
WHERE job_name = 'CREATE_TABLE_JOB';

Sprawdzenie jak wykonal sie job - status ,komunikat bledu

SELECT 
    job_name,
    status,
    error#,
    additional_info,
    log_date,
    run_duration
FROM dba_scheduler_job_run_details
WHERE job_name = 'CREATE_TABLE_JOB'
ORDER BY log_date DESC;