To find the job details
set pages 1000 lines 1000
col schema_user for a20
col this_date for a20
col next_date for a20
col what for a80
col schema_user for a20
col this_date for a20
col next_date for a20
col what for a80
col instance for 999999999
select job,what,schema_user,this_date,next_date,instance from dba_jobs;
select job,what,schema_user,this_date,next_date,instance from dba_jobs;
To find the sid of job which is currently running
col this_date for a20
col next_date for a20
select sid,job,this_date,last_date from dba_jobs_running;
col next_date for a20
select sid,job,this_date,last_date from dba_jobs_running;
To remove the job from job queue
begin
dbms_job.remove(<job>);
commit;
end;
/
dbms_job.remove(<job>);
commit;
end;
/
To mark job as broken
Login as the job owner and execute below
EXEC DBMS_JOB.BROKEN(<job>,TRUE);
Recent Posts
