Oracle Database - How to find Job name and job program details

Asked By prathap chowdary on 22-Mar-12 05:49 AM
Hi,

One user asking job status of one user.They are only scheduled taht jobs by user.

They are asking me,what is the job status, what is the procedure of job?

I am searching on dba_jobs table......but it is giving the job and last date and next date details of that user.

But i want what is the program name also........


Please help me anyone........

Thanks advance...........

Regards,
Prathap.
[)ia6l0 iii replied to prathap chowdary on 26-Mar-12 10:32 AM
I hope these are not custom jobs. Schedule job information can be found from the DBA_Scheduler_jobs and All_Scheduler_Running_jobs tables. 

The following two queries gives you pretty good information to start with.
SELECT * FROM DBA_SCHEDULER_JOBS
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

After this, it is up to you, to derive the data the people around you ask for.