select * from all_jobs;
SELECT * FROM DBA_JOBS;
SELECT * FROM DBA_JOBS_RUNNING;
SELECT job, next_date, next_sec, failures, broken FROM user_jobs;
select a from sxfc.job_table order by a;
delete from sxfc.job_table;
exec dbms_job.broken(38);
select * from all_jobs;
SELECT * FROM DBA_JOBS;
SELECT * FROM DBA_JOBS_RUNNING;
SELECT job, next_date, next_sec, failures, broken FROM user_jobs;
select a from sxfc.job_table order by a;
delete from sxfc.job_table;
exec dbms_job.broken(38);