Remove an event scheduled with dbms_job? 2

[Jami]

I have scheduled an event below that I would now keep from happening. Can anyone tell me how to now stop this event from occuring daily as I had submitted below?

declare
jobnum NUMBER;
BEGIN
dbms_job.submit(jobnum, 'myprocedure;',SYSDATE, 'trunc((sysdate) + 1) + 14/24');
commit;
end;
/

Thanks!
Jami

 

[karluk]

get the job number from dba_jobs and then execute

dbms_job.broken(jobnum,true)

That will retain the job definition but prevent it from executing until you unbreak it with

dbms_job.broken(jobnum,false)

 

[LokiDba]

If you want to remove the job completely from the job schedule. Using the following call on DBMS_JOB

DBMS_JOB.REMOVE( jobnum );

and it should go from the job queue. To find the
job number use the following queue.

SELECT job, schema_user, what
FROM USER_JOBS

Hope this is of use

LokiDBA

 

[Jami]

Thank you both. Just the direction I needed to gain a better understanding of the dbms_job utility.
Thanks again!
Jami