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
1
vote
1 answer

Oracle Job not starting according to Start Date paramter

I have an Oracle For loop which creates n jobs. For each job created the start date is an interval of 10 seconds from previous job. But for some reason each job launches within 1 second of each other. Are future jobs not possible in Oracle ? …
Alex David
  • 585
  • 1
  • 11
  • 32
1
vote
1 answer

Oracle DBMS_SCHEDULER looping found error ORA-274278

I've some script for running bat file windows using DBMS_SCHEDULER. But there is some error when there is looping with several data. CREATE OR REPLACE procedure SEAT.ss_print_fundoshi_run_weld_tst (ptype varchar2) is cursor c_data is select * from…
reefman
  • 143
  • 4
  • 13
1
vote
0 answers

Execute shell scripts with DBMS_SCHEDULER and log output

I have a couple DBMS_SCHEDULER jobs, that executes shell scripts like this: dbms_scheduler.create_job ( job_name => 'my_job', job_type => 'EXECUTABLE', job_action => '/path/to/my_shell.sh', enabled =>…
Uldis Bajārs
  • 37
  • 4
1
vote
1 answer

oracle dbms scheduler job is failing

I have scheduled the below job in oracle dbms scheduler , rite now the job is executing with the below error , the scheduled job is begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'KEEP_STATS_DBNEW4', job_type …
user1906154
  • 57
  • 2
  • 12
1
vote
1 answer

dbms_scheduler fails to create job when created within a stored procedure

I am trying to create a dbms_scheduler job within a stored procedure after executing some logic. My procedure code is as below. The issue is that the scheduler code is not running and the procedure is not throwing any exception at that time of…
DG3
  • 5,070
  • 17
  • 49
  • 61
1
vote
0 answers

How to Call a scheduler in Oracle from java

I need to call a Scheduler "DBMS_SCHEDULER.ENABLE('some_job')" from java. I tried to call it like CallableStatement cs = = con.prepareCall("{exec DBMS_SCHEDULER.disable('some_job')}"); cs.executeUpdate(); Also replaced exec with call, but doesn't…
Nisha
  • 89
  • 1
  • 2
  • 10
1
vote
1 answer

Not able to stop dbms_scheduler job

SQL> Exec Dbms_Scheduler.stop_job('US_ALERT',true); begin Dbms_Scheduler.stop_job('US_ALERT',true); end; ORA-27466: internal scheduler error: 1870 ORA-06512: at "SYS.DBMS_ISCHED", line 227 ORA-06512: at "SYS.DBMS_SCHEDULER", line 674 ORA-06512: at…
Prashant Mishra
  • 619
  • 9
  • 25
1
vote
4 answers

Explain "ORA-01870: the intervals or datetimes are not mutually comparable"

When this code is executed in SQL Developer against Oracle 11g I get an error, begin dbms_scheduler.create_job( job_name => 'comuni_34', job_type => 'plsql_block', job_action => 'begin com_auth_api.expire_old_passwords; end;', start_date =>…
Janek Bogucki
  • 5,033
  • 3
  • 30
  • 40
1
vote
3 answers

Run/execute multiple procedures in Parallel - Oracle PL/SQL

I have an Activity table which is getting all the table events of the system. Events like new orders, insertion/deletion on all the system tables will be inserted into this table. So, the no of events/sec is really huge for Activity table. Now, I…
Ankur Bhutani
  • 3,079
  • 4
  • 29
  • 26
1
vote
1 answer

How to implement timer for heartbeat

I need to implement a heartbeat function written in PL/SQL, to ping a web service every 5 minutes. I know that PL/SQL is really not the correct language to be writing this in, but it has to be done this way. DECLARE stored_time …
Marc Howard
  • 395
  • 2
  • 6
  • 25
1
vote
1 answer

Convert script to PL/SQL procedure for dbms_scheduler

I'm fairly new to SQL. I'm trying to convert a script I have into a stored procedure so that I can run the: dbms_scheduler.create_job (job_type => 'STORED_PROCEDURE') scheduler. Here is my SQL: insert into EBA_PROJ_STATUS_HEALTH (DATESTAMP, WEEK,…
Jubair Ahmed
  • 19
  • 3
1
vote
2 answers

DBMS_SCHEDULER How to supply multiple schedules to repeat_interval of a job?

I have multiple schedules and I want to supply all of them to the repeat_interval of a job. However, I can't find a way to do this - Oracle documentation says it's possible, but I can't find any examples. Any help is appreciated. This is what I…
charlie
  • 45
  • 6
1
vote
0 answers

Create a Job Inside a Trigger ORACLE

I have a job does work fine, but now I need to send him a parameter when a table is updated. I try this code below but does not work: CREATE OR REPLACE TRIGGER "STK_PRUEBA" BEFORE INSERT OR UPDATE OR DELETE ON STK_TABLA REFERENCING OLD AS…
Jorge
  • 11
  • 1
1
vote
1 answer

how to pass sysrefcursor as a parameter to oracle scheduler job

I'm getting a SYSREFCUROSOR as output parameter from a stored procedure, How to call that SP in a oracle scheduler job and pass that parameter?
abhinay
  • 11
  • 4
1
vote
3 answers

How to set start_date and end_date on a dbms job (oracle)

I'm creating a scheduler for my oracle DB This is what i got so far : BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'CREAZIONE_OCCORRENZE', job_type => 'STORED_PROCEDURE', job_action => 'pop_occr_lezione' start_date …
darkpirate
  • 712
  • 3
  • 10
  • 27
1 2 3
…
14 15