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
0
votes
1 answer

Job not running on start_date SQL Developer

Has anyone had any issues with the start_date in SQL developer when the job won't execute on the start_date provided in the schedule, but it runs fine against the repeat interval? My understanding was that the start_date would be the first…
LG54
  • 1
  • 3
0
votes
2 answers

How to change status of hundreds Oracle scheduler jobs

Hi，everyone，I am new to DB or Oracle. I got a problem here which hope you can help me: I have 400+ specific scheduler jobs running,they are running hourly ,now I want all of them paused until I need them running again. How can I do that easily? Now…
Finch
  • 1
  • 1
0
votes
0 answers

Oracle job does not work properly

I created jobs like this. DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'PROCEDURE_CATCH;' ,next_date => to_date('16/05/2018 16:07:00','dd/mm/yyyy hh24:mi:ss') ,interval …
civesuas_sine
  • 119
  • 2
  • 15
0
votes
1 answer

Unable to understand how APEX_MAIL's job runs

I'm currently trying to implement a similar version of oracle's APEX_MAIL package. I have everything working, but I can't make the job work unless I modify it. The job APEX_MAIL uses is called…
Matt
  • 135
  • 3
  • 17
0
votes
1 answer

DBMS scheduler not loading new state of a package in real time

I am using Oracle Advanced queues to enqueue messages and then dequeue them by using PLSQL callback notification in which I have registered a procedure. Whenever a message is queued, DBMS scheduler starts and it takes about 2 minutes to dequeue the…
Vishaw
  • 1
  • 2
0
votes
1 answer

How to trigger a dbms_scheduler job from Java repo in Spring?

I have an Oracle DB Scheduler job that I'm able to run directly using command: EXEC dbms_scheduler.run_job('MY_SCHEDULER_JOB'); Now I'm trying to invoke the same job from my Java SpringBoot service where I'm using JDBCTemplate in Repo to run Select…
shazwashere
  • 63
  • 9
0
votes
1 answer

Modify DBMS_SCHEDULER job to stop running between certain hours and minutes

I need to alter a job to run between 23:00PM up till 19:45PM. I have tried the below which achieves this, but the problem with the below is that the job will always stop for 15minutes per hour, between for example 10:45 till 11:00 etc. I'm not sure…
GomuGomuZoro
  • 313
  • 1
  • 4
  • 16
0
votes
3 answers

Alter an oracle job to run every 5 seconds from a specific time till a specific time everyday

EDIT: I need the below job to run from 11PM till 05:35AM, every 5 seconds in that window, everyday. So, what I've done so far is set the following to run every 5 seconds. BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'test_job', attribute…
GomuGomuZoro
  • 313
  • 1
  • 4
  • 16
0
votes
1 answer

SQL Exception ORA-27478: job "JOB_MIG_17602" is running during DBMS_SCHEDULER.run_job

Getting the below exception when trying to run multiple jobs in parallel. This occurs intermittently. The point of failure is DBMS_SCHEDULER.run_job SQL Exception ORA-27478: job "JOB_MIG_17602" is running "ORA-06512: at "SYS.DBMS_ISCHED", line…
Sachida Nanda Singh
  • 35
  • 1
  • 4
0
votes
1 answer

How to Update a Table for a same matching row

I have a Table TBLmaterial where current Stock is defined for particular Materailid . And i have a tbldrawingtable where required quantity is listed for a particular material . It should update present column as required quantity and status to…
sampath acharya
  • 133
  • 1
  • 3
  • 14
0
votes
1 answer

Days of USER_SCHEDULER_JOB_RUN_DETAILS

I would like to know if it is possible to know the number of days that Oracle keeps the data in the table USER_SCHEDULER_JOB_RUN_DETAILS and also if it is possible to change it.
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
0
votes
1 answer

Queuing with Oracle

I want to execute a procedure which performs updates on a set of given tables. In this case 11 tables. An associative array is used here only because the name of the column used for the join with the table located in the procedure differs amongst…
royskatt
  • 1,190
  • 2
  • 15
  • 35
0
votes
1 answer

Oracle DBMS_SCHEDULER_LOGGING_OFF

I've defined a DBMS_SCHEDULER job with the logging defined to DBMS_SCHEDULER_LOGGING_OFF, as you can see in the picture: nevertheless, when I query the DB SELECT * from USER_SCHEDULER_JOB_RUN_DETAILS ORDER BY LOG_DATE DESC I got all the Job…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
0
votes
0 answers

Scheduler problems and zombiejobs without session-ID

We are running a small staging setup on an Oracle Database (11g Enterprise Edition Release 11.2.0.3.0). We are running jobs using both timed and event-based schedules and our issue is regarding the scheduling. This setup has been running for about…
David Bachmann Jeppesen
  • 395
  • 1
  • 8
0
votes
1 answer

Oracle: Duration of a scheduler Job

I want to know the duration of a scheduler Job, but what I get from the DB is null ! select LAST_RUN_DURATION from USER_SCHEDULER_JOBS
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
1 2 3
…
14 15