How do I find all jobs running on my Oracle9i server

[lhugh]

and how do I shut down the job that I do not want to run?

Thank you all

 

[kishleo]

select * from dba_jobs_running

if you do not want to run any job just remove job or schedule it with different interval

Kishore MCDBA

 

[lhugh]

thank you.