Stack Overflow
Stack Overflow

Questions tagged [dbms-scheduler]

An Oracle scheduling package.

dbms_scheduler is an Oracle scheduling package, which provides methods of scheduling single jobs or groups of jobs at regular intervals or based on a calendar.

Questions tagged should also be tagged .

Further reading:

213 questions
30
votes
1 answer

DBMS_SCHEDULER.DROP_JOB only if exists

I have a sql script that I must run after I import a dump. among other things the script does, it does the following: BEGIN --remove program SYS.DBMS_SCHEDULER.DROP_PROGRAM(program_name=>'STATISTICS_COLUMNS_PROG',FORCE=>TRUE); --remove…
user2183505
  • 315
  • 1
  • 3
  • 5
20
votes
4 answers

DBMS_JOB vs DBMS_SCHEDULER

What is the difference between DBMS_JOB and DBMS_SCHEDULER ?
kupa
  • 1,861
  • 5
  • 25
  • 41
12
votes
2 answers

dbms_scheduler.run_job('jobName) fails to run

I'm trying to run a scheduled job manually, the job looksa like this DBMS_SCHEDULER.CREATE_JOB ( job_name => 'UPDATE_PLAYER_STATES', job_type => 'STORED_PROCEDURE', job_action => 'PLAYER_STATE_UPDATER', …
Manoj
  • 5,542
  • 9
  • 54
  • 80
9
votes
1 answer

Can not Run Completed Oracle Job again

Can not run a completed DBMS_SCHEDULER job by remove the END_DATE Hello, everyone! I am using oracle 12cR1,now I have a problem in DBMS_SCHEDULER jobs. First, I created an repeated oracle DBMS_SCHEDULER jobs with END_DATE was set, after the set…
frog2861
  • 91
  • 2
8
votes
2 answers

Passing arguments to oracle stored procedure through scheduler job

I have a stored procedure which is being called from a dbms job. i.e. DBMS_SCHEDULER.RUN_JOB ('Procedure_JB', FALSE); A java code stored procedure, which after doing some stuff, kicks off Procedure_JB asynchronously. And then this Procedure_JB…
Em Ae
  • 8,167
  • 27
  • 95
  • 162
8
votes
3 answers

How to resolve ORA-27475: "JOB" must be a program or chain

I have a couple of oracle procedures: create or replace procedure receive_sms (p_to_date in date) is .. end; and create or replace procedure send_sms (p_date in date) is .. end; and I want to create a chain based on these procedures and add…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
8
votes
5 answers

How to schedule an Oracle dbms_scheduler Job timezone and DST safely

I am trying to setup a DBMS_SCHEDULER Job to run exactly at 1 AM on 1st of January every year on Oracle 11g. How to setup its attributes to be absolutely sure it wont get executed in wrong hour, because of timezone differences nor Daylight Savings…
Javo
  • 435
  • 1
  • 5
  • 16
7
votes
3 answers

How to disable a job in oracle with dbms_scheduler

I created a job which runs in my database successfully with DBMS_SCHEDULER ,but now I need to disable this job, how can i do this? thanks!
IT Expert
  • 71
  • 1
  • 1
  • 3
6
votes
1 answer

How do I list jobs in Oracle dbms_scheduler?

How do I list jobs created with Oracle dbms_scheduler.create(...)?
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
5
votes
1 answer

Create oracle scheduler job which runs daily

I want to create oracle scheduler job which runs daily at 20:00 and runs for 30 minute. This job will delete the rows from KPI_LOGS table as this table contains large amount of data and it continues to grow. I have created the below script in oracle…
Andrew
  • 3,632
  • 24
  • 64
  • 113
5
votes
3 answers

How to wait for dbms_scheduler jobs to finish

Using Oracle 11.2 Hi, Here is what I want to do: I'm scheduling jobs using dbms_scheduler. The number of jobs to schedule is not fixed and a max of 4 jobs should run at the same time. The procedure scheduling the jobs should wait until all jobs are…
jon sumisu
  • 133
  • 1
  • 2
  • 7
4
votes
2 answers

Implementing Multithreading in Oracle Procedures

I am working on Oracle 10gR2. And here is my problem - I have a procedure, lets call it *proc_parent* (inside a package) which is supposed to call another procedure, lets call it *user_creation*. I have to call *user_creation* inside a loop, which…
Incognito
  • 2,964
  • 2
  • 27
  • 40
4
votes
1 answer

Oracle DBMS_SCHEDULER use case to run 1 job at a time but queue subsequent jobs to run FIFO

Create a resource, and limit jobs to 1 begin dbms_scheduler.create_resource(resource_name=>'SO_TEST_RESOURCE',units=>'1'); END; While I can create a job, assign a resource, and even a priority, the subsequent jobs (assigned to the same resource and…
MP_SteveO
  • 41
  • 1
4
votes
2 answers

How can I track the status of my running job using Oracle's DBMS Scheduler?

Is this possible with oracle's scheduler. I just want to track where it currently is executing, when the job is running and get feedback. dbms_scheduler.create_job( job_name => 'hello_oracle_scheduler', job_type => 'PLSQL_BLOCK', …
help
  • 297
  • 2
  • 5
  • 14
4
votes
2 answers

Oracle DBMS Job not running

I defined a job to run from Tuesday to Sundays every 5 min. from 9:00 am to 22:00 pm BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'GET_INVOICES_JOB', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN LOPES.GET_INVOICES; END;', repeat_interval…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
1
2 3
…
14 15