search for submitted jobs

hi,
i have submitted a job, but i have forgotten the job no, then how do i remove the job from the queue, which table holds this information.

thanks,
prasen

http://www.dbasupport.com/oracle/ora9i/jobqueue2.shtml

hi Mak,
thanks a lot. but when i try to change the job interval, it says the procedure has been executed successfully; but when i query the dba_jobs table the change is not reflected.


regards,
Prasen

hi,
when i gave a commit command and checked, the interval was changed. but i had the idea that procedures do not have to be committed after execution.

thanks,
Prasen:confused: