Results for DBMS_JOB


1 to 20 of 91 results. Prev  Next
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 1 of 2

20 DBMS_JOBDBMS_JOB subprograms schedule and manage jobs in the job queue. See Also: For more information on … the DBMS_JOB package and the job queue, see Oracle9i Database Administrator's Guide This chapter … discusses the following topics: Requirements Using the DBMS_JOB Package with Oracle Real Application Clusters Summary of DBMS_JOB

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

Summary of DBMS_JOB SubprogramsTable 20-1 DBMS_JOB Package Subprograms   Subprogram Description SUBMIT Procedure Submits a new job

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Job Queues

The DBMS_JOB PackageTo schedule and manage jobs in the job queue, use the procedures in the DBMS_JOB package. There are … procedures can use the job queue. The following are procedures of the DBMS_JOB package. They are … for the DBMS_JOB package, and for information about other options available when using the DBMS_JOB

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

ParametersTable 20-5 WHAT Procedure Parameters Parameter Description job Number of the job being run. what PL/SQL procedure to run. Some legal values of what (assuming the routines exist) are: 'myproc( ''10-JAN-82'', next_date, broken);' 'scott.emppackage.give_raise( ''JENKINS'', 30000.00);' 'dbms_job.remove(job);'

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

SUBMIT ProcedureThis procedure submits a new job. It chooses the job from the sequence sys. jobseq.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

Usage NotesIf the job completes successfully, then this new date is placed in next_date. interval is evaluated by plugging it into the statement select interval into next_date from dual; The interval parameter must evaluate to a time in the future. Legal intervals include: Interval Description 'sysdate + 7' Run once a week. 'next_day(sysdate,''TUESDAY'')' Run once every Tuesday. '' Run only once. If interval

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

ParametersTable 20-11 USER_EXPORT Procedure Parameter Parameter Description job Number of the job being run. mycall Text of a call to recreate the given job.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

ParametersTable 20-12 USER_EXPORT Procedure Parameters Parameter Description job Number of the job being run. mycall Text of a call to re-create a given job. myinst Text of a call to alter instance affinity. Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

Usage NotesThe parameters instance and force are added for job queue affinity. Job queue affinity gives users the ability to indicate whether a particular instance or any instance can run a submitted job.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

ExampleEXECUTE DBMS_JOB.REMOVE(14144);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

SyntaxDBMS_JOB.CHANGE ( job IN BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE, interval IN VARCHAR2, instance IN BINARY_INTEGER DEFAULT NULL, force IN BOOLEAN DEFAULT FALSE);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

ExampleEXECUTE DBMS_JOB.CHANGE(14144, , , 'sysdate+3');

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

NEXT_DATE ProcedureThis procedure changes when an existing job next runs.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

ExampleEXECUTE DBMS_JOB.RUN(14144); Caution: This reinitializes the current session's packages.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

USER_EXPORT ProcedureThis procedure produces the text of a call to re-create the given job.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

Usage NotesThe parameters instance and force are added for job queue affinity. Job queue affinity gives users the ability to indicate whether a particular instance or any instance can run a submitted job. If the parameters what, next_date, or interval are NULL, then leave that value as it is.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

INTERVAL ProcedureThis procedure changes how often a job runs.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

RUN ProcedureThis procedure runs job JOB now. It runs it even if it is broken. Running the job recomputes next_date. See view user_jobs.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 2 of 2

SyntaxDBMS_JOB.USER_EXPORT ( job IN BINARY_INTEGER, mycall IN OUT VARCHAR2);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_JOB, 1 of 2

Using the DBMS_JOB Package with Oracle Real Application ClustersFor this example, a constant in DBMS_JOB indicates no mapping among jobs and instances; that is


Was this page helpful?