Stack Overflow
Stack Overflow

Questions tagged [dbms-job]

A package in Oracle. The DBMS_JOB package schedules and manages jobs in the job queue.

The DBMS_JOB package has been superseded by the DBMS_SCHEDULER package (tag: ) package. Please also include the tag, and an appropriate Oracle version tag such as

60 questions
0
votes
1 answer

DB2 LUW Parallel Jobs Execution

I have been working in DB2 LUW database, i want to submit procedures as a parallel job. Meaning I have a procesure which will do some DDL, DML statements to one table. This table is having huge data, the same procedure need to run for few more…
Vivek Harry
  • 419
  • 3
  • 11
  • 25
0
votes
0 answers

Oracle job sending email when dbms_job is broken

I m trying to crate notification to send email whenever job is broken. This is the job: declare jobno number; begin dbms_job.submit( jobno, 'test_job_procedure;', SYSDATE, 'SYSDATE +…
civesuas_sine
  • 119
  • 2
  • 15
0
votes
1 answer

Oracle12: calling a procedure inside a Package

I have a DBMS_JOB job declares as follows BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'GET_ENAGAS_INVOICES_JOB', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN LOPES.GET_ENAGAS_INVOICES; END;', repeat_interval =>'FREQ=MINUTELY; INTERVAL=5;…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
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
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
0 answers

ORACLE : How to take a count rows in a table inside a procedure while the table is being populated by another procedure (oracle job)

I want to take count of a table inside a parent procedure while the table is being populated by another/child procedure. This second/chile procedure is started as a job from inside the first/parent. The above is a simplistic description of certain…
Jay
  • 47
  • 11
0
votes
1 answer

Executing stored procedures in oracle inside a package using dbms_job

I am trying to execute multiple stored procedures through package using DBMS_JOB. Even if the job is getting submitted and is showing in USER_JOBS its not getting started for some reason. I have tried with and without putting the 'START DATE'…
qwerty
  • 11
  • 3
0
votes
1 answer

DBMS Job with function

I have this DBMS Job that run at the end of day to clean the data and I have this function available CLEAN_SNAPSHOT_DATA_F(7). I try running this script below. begin sys.dbms_job.submit(job => :job, what => 'select…
user2584537
  • 49
  • 6
0
votes
1 answer

How to use procedure to kill jobs calling it from java code?

I want to kill some jobs from a java app by calling the procedure below and passing the parameters which are job id, session id and session serial number. It won't work and I am very lost here. PROCEDURE kill_batch_test ( V_JOB IN VARCHAR2,…
TheSM
  • 59
  • 1
  • 13
0
votes
1 answer

DBMS_SCHEDULER.set_job_argument_value - ORA-27473: argument does not exist

Hi I'm creating a JOB CONTROLLER to run a procedure. JOB CONTROLLER Procedure' CREATE OR REPLACE PROCEDURE "GCCPMAINT"."JOB_CONTROLLER" as programTotal number; BEGIN dbms_scheduler.create_program ( program_name…
Sathish Sivanandam
  • 13
  • 1
  • 5
0
votes
2 answers

Java code only works when submitted the second time

I have the piece of code displayed below. My challenge is that the code only works the second (third and so on) times it's submitted. I change nothing between the two submits but the first time doesn't do what it's supposed to. Both time I get a…
CJe
  • 1,928
  • 3
  • 24
  • 53
0
votes
1 answer

Schedule Oracle Jobs

I have created an oracle jobs that triggered my stored procedure to run everyday at 5 AM.But i want to restrict the job to run only from Monday to Friday at 5 AM.Here is the job that i have written: DECLARE X NUMBER; BEGIN …
user1783170
  • 113
  • 2
  • 3
  • 9
0
votes
1 answer

DDL Statements in DBMS_JOB

I am trying to schedule a job using DBMS_JOB (I can't use DBMS_SCHEDULER for security reasons), which uses a DDL statement. DECLARE job_num NUMBER; BEGIN DBMS_JOB.SUBMIT(job => job_num, what => 'BEGIN EXECUTE IMMEDIATE ''CREATE TABLE temp1 (ID…
Incognito
  • 2,964
  • 2
  • 27
  • 40
-1
votes
1 answer

Discuss the main issues governing concurrency control in a large distributed database environment

I'm revising for uni using mock questions and I'm wondering where I could find materials or information to answer this question or if someone could walk me through it? Thanks
teezee
  • 1
-2
votes
1 answer

DB2 Z/OS V10 Mainframe : How to create jobs

Which language can I use in z/OS to create a job in DB2 Z/OS V10? In Z/OS Mainframe, please provide example script to create or SUBMIT a JOB which executes stored procedures.
Vivek Harry
  • 419
  • 3
  • 11
  • 25
1 2 3
4