Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6495
  • Last Modified:

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.
0
thermalsun
Asked:
thermalsun
1 Solution
 
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
 
Shaju KumbalathDeputy General Manager - ITCommented:
 select    job_name,    enabled from    user_scheduler_jobs;
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now