How to get List of user level Scheduled Jobs in Oracle

I want to know the SQL to get list of all scheduled jobs in oracle.

I created the job using dbms_scheduler.create_job(.....) with name RESET_KITID.
LVL 1
thermalsunAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
 select    job_name,    enabled from    user_scheduler_jobs;
0
 
OMC2000Commented:
SELECT * FROM dba_jobs
0
 
thermalsunAuthor Commented:
I create the job using a normal user named FLXUSER

Not able to view results using

SELECT * FROM user_JOBS


also tried SELECT * FROM dba_jobs using SYS account but the job is not there.

When I try to recreate the job i get error as
ORA-27477: "FLXUSER.RESET_COB_SEQ_KITID" already exists
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2

I created the Job using below code:
BEGIN
dbms_scheduler.create_job( job_name=> 'RESET_COB_SEQ_KITID', JOB_TYPE=>'PLSQL_BLOCK', JOB_ACTION=> 'BEGIN COB_SP_RESET_KITID; END;', start_date=> SYSTIMESTAMP, repeat_interval=>'frequency=daily;interval=1;byhour=0; byminute=0; bysecond=0;', enabled=>TRUE );
END;

Open in new window

0
 
thermalsunAuthor Commented:
thx a lot for the solution.
0
 
HainKurtSr. System AnalystCommented:
You can start with this query

Select job, broken, substr(what,1,45), schema_user, next_date, this_date
from DBA_JOBS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.