top of page

JOB

JOBs de la BDs (LOGs)

select

 owner,

 job_name,

 operation,

 status

from all_scheduler_job_log

order by log_date desc;

JOBs en ejecución

select 
owner, 
job_name, 
elapsed_time, 
cpu_used 
from all_scheduler_running_jobs;

Deshabilitar un JOB

Detenr un JOB

exec dbms_scheduler.stop_job('OWNER.JOB_NAME');

exec dbms_scheduler.disable('OWNER.JOB_NAME');

Estado de los JOBs en la BDs

select 
  owner, 
  job_name, 
  job_creator,
  program_owner,
  program_name, 
  state,

  decode(enabled,'TRUE','HABILITADO', 'FALSE','DESHABILITADO')    Estado_Job,

  job_action 
 from dba_scheduler_jobs;

Ejecutar un Job

begin 
dbms_scheduler.run_job('OWNER.NOMBREDELJOB',TRUE); 
end; 
/

bottom of page