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
4
votes
2 answers

How to schedule Oracle DBMS Jobs in a window

I want to create an Oracle DBMS Job that runs every week day (not on weekends) from 09:00 to 20:00 every 10 min. I wonder if I can do that in the FREQ parameter of the job definition or I have to create a New Maintenance Window. It seems that with…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
4
votes
1 answer

Oracle dbms_scheduler error with BYTIME

I was trying to get a job run every business day (MON to SAT) at 6:30am which the Oracle scheduler refused with ORA-27419 "unable to determine valid execution date from repeat interval" I started losing my mind when i discovered the following…
Martin K.
  • 1,050
  • 8
  • 19
4
votes
0 answers

How to run failed step in chain in Oracle using previous job name?

I have a job which runs a chain. The chain consists of 5 steps. First step is run and if it succeeds, three other steps will be run (independently, in parallel). Only if all three steps succeed, the last step will start. Everything works fine. I…
Eve
  • 41
  • 1
  • 4
4
votes
1 answer

Run oracle query (SQL) every 30 seconds and once count equals 8 it should proceed further and finish the job

I was looking for a solution to my problem on the internet, however I could not find fit for purpose solution. Can some please help and guide me with some examples. In Oracle em console I have a job that runs for at least for 1 hour and during the…
user3463885
  • 99
  • 1
  • 4
  • 9
4
votes
2 answers

Is there a way to make an Oracle Job disable itself?

I'm trying to make this happen: declare Contador number; begin ATUALIZAR_VAL_MAT_PENDENTES(Contador); if Contador = 0 then dbms_scheduler.disable('JOB_ATUALIZAR_VAL_MAT_PEND'); end if; end; When the counter returns zero, it will disable…
Vic Wolk
  • 166
  • 1
  • 14
4
votes
2 answers

Set named parameter for Oracle dbms_scheduler job stored procedure

Is it possible to passed named arguments to for dbms_scheduler job with a type 'stored_procedure' ? I've tried this way: -- 1) example dummy procdure CREATE OR REPLACE PROCEDURE my_test_proc ( param1 IN NVARCHAR2, param2 IN NUMBER, param3 IN…
skujins
  • 375
  • 3
  • 5
  • 13
4
votes
2 answers

Altering JOB_QUEUE_PROCESSES

Does altering the JOB_QUEUE_PROCESSES to 0 on an Oracle DB block the Oracle jobs from being scheduled too? I found in http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/jobq.htm some information about it, principally, the…
jnt30
  • 1,367
  • 2
  • 15
  • 21
4
votes
1 answer

define an argument value for a step in an Oracle job chain

I'm building a job chain in Oracle (11R2) DBMS Scheduler. The chain has two steps. Each step runs the same program, but with different arguments. I can see how how to define the chain, the steps, the rules, etc - but I cannot figure how to set…
John
  • 111
  • 1
  • 2
  • 8
4
votes
4 answers

How to create a "singleton" scheduled job in oracle?

It's probably just the vocabulary I am missing to find out how to do this: A job scheduled to run regularly every 5 mins, however keeping track that there are never two instances of it running at the same time, i.e. the next instance would be…
PeterP
  • 4,502
  • 7
  • 22
  • 21
3
votes
2 answers

Run procedures in parallel - Oracle PL/SQL

I am trying to run stored procedures in parallel - Oracle PL/SQL using dbms_scheduler but I am getting an error like an unknown job, I have also tried dbms_job, here I am getting an error- identifier dbms_jobs must be declared. Could someone please…
ZZ3111
  • 67
  • 2
  • 7
3
votes
1 answer

DBMS_SCHEDULER in apex oracle

I have an API package written. It has the GET_INFO procedure. I want this procedure to be performed in the background every 20 minutes. I understand what I should do with dbms_scheduler. But in general I do not understand where to register them . I…
Apex_MAN
  • 107
  • 3
  • 10
3
votes
1 answer

Oracle DBMS_SCHEDULE to run at 8am, 12pm, 4pm and 8pm every day of the week

I am unsure how to tackle using Oracle DBMS_SCHEDULER. I have been asked to run a particular PL/SQL procedure job at: 8AM, 12PM, 4PM and lastly at 8PM every day of the week and then re-start again the following day at the same times again at: 8AM,…
tonyf
  • 34,479
  • 49
  • 157
  • 246
3
votes
1 answer

Why is the maximum length of a scheduler chain step name 24 bytes?

I'm trying to create a chain step that's 30 bytes long. It is failing. Set-up: SQL> begin 2 dbms_scheduler.create_program( 3 program_name => lpad('A', 30, 'A') 4 , program_type => 'PLSQL_BLOCK' 5 , program_action =>…
Ben
  • 51,770
  • 36
  • 127
  • 149
3
votes
3 answers

ORA-27465: invalid value 1 for attribute ARGUMENT_POSITION

I have procedure like this inside a package PROCEDURE prepBillInfoforAccrualIntr (p_date in date); -- created a program BEGIN DBMS_SCHEDULER.CREATE_PROGRAM(PROGRAM_NAME => 'MY_PROGRAM', PROGRAM_TYPE …
SK Yakub
  • 85
  • 2
  • 8
3
votes
1 answer

manually running a scheduled job. LAST_RUN_DATE is not updating

I have a job on the database which runs nightly at 1am using the DBMS scheduler. I also want to be able to run the job manually whenever I was. I do this by running execute dbms_scheduler.run_job('JOB_NAME'); This all works fine and the job does…
kev670
  • 810
  • 2
  • 18
  • 37
1
2
3
…
14 15