Manejo de Jobs

• Tablas Relacionadas

select * from user_errors;
select * from user_source;
select * from dba_jobs;
select * from users_jobs;

• Crear Jobs

variable jobno number;
begin
dbms_job.submit( :jobno,
'owner.storeprocedure;',
sysdate + (1/24/60)*5,
'sysdate + (1/24/60)*30'
);
end;
/
commit;

• Borrar Jobs

variable jobno number;
begin
dbms_job.remove (24);
end;
/
commit;
-------modifica jobs----
begin
dbms_job.change(<Job number>,
'owner.storeprocedure;',
sysdate + (1/24/60)*5,
'sysdate + (1/24/60)*5'
);
end;
/
commit;

• Habilta/Deshabilita jobs

begin
dbms_job.broken(<JOBNUMBER>,FALSE);
end;
/
commit;