How can I list the scheduled jobs running in my database?

Question

I am new to oracle. I need to get the scheduled jobs in my database.

I queried

DBA_SCHEDULER_JOBS, 
DBA_SCHEDULER_SCHEDULES, DBA_SCHEDULER_PROGRAMS,
 DBA_SCHEDULER_JOB_CLASSES, DBA_JOBS.

But Oracle issues the error

"ORA-00942: table or view does not exist".

When I queried ALL_JOBS and USER_JOBS no rows are retrieved. Please suggest me which table should I see.

Answer 1

The DBA views are restricted. So you won't be able to query them unless you're connected as a DBA or similarly privileged user.

The ALL views show you the information you're allowed to see. Normally that would be jobs you've submitted, unless you have additional privileges.

The privileges you need are defined in the Admin Guide. Find out more.

So, either you need a DBA account or you need to chat with your DBA team about getting access to the information you need.