Database Reference
In-Depth Information
SQL> COMMIT;
Commit complete.
SQL> SELECT job, what, broken FROM dba_jobs WHERE priv_user='PERFSTAT';
JOB WHAT BROKEN
--- --------------- ------
1 statspack.snap; Y
FULL_EXPORT Procedure
This procedure returns strings that hold PL/SQL calls to recreate a job. It may be used to export
job definitions.
Syntax
DBMS_IJOB.FULL_EXPORT(
job IN BINARY_INTEGER,
mycall IN OUT VARCHAR2,
myinst IN OUT VARCHAR2);
Parameters
Parameter
Description
job
Job number; corresponds to
DBA_JOBS.JOB
mycall
After a successful call of the procedure, the return value holds a string that
represents a call to
DBMS_IJOB.SUBMIT
myinst
After a successful call of the procedure, the return value holds a string that
represents a call to
DBMS_JOB.INSTANCE
Examples
The script
dbms_ijob_full_export.sql
exports the definition of a single job in a format that is
suitable for recreating the job. The main part of the script is reproduced here:
variable job number
variable submit_call varchar2(4000)
variable instance_call varchar2(4000)
exec :job:=&job_number;
begin
dbms_ijob.full_export(:job, :submit_call, :instance_call);
end;
/
print submit_call
print instance_call
