Database Reference
In-Depth Information
Following is an example of running the script to export a job that takes Statspack snapshots:
$ sqlplus -s / as sysdba
@dbms_ijob_full_export.sql
JOB WHAT
---------- ---------------------------------------------
21 statspack.snap;
Enter value for job_number: 21
sys.dbms_ijob.submit(job=>21,luser=>'PERFSTAT',puser=>'PERFSTAT',cuser=>'PERFSTAT',
next_date=>to_date('2007-12-07:21:00:00','YYYY-MM-DD:HH24:MI:SS'),
interval=>'trunc(SYSDATE+1/24,''HH'')',
broken=>FALSE,what=>'statspack.snap;',nlsenv=>'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITO
RY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUMERIC_CHARACTER
S=''.,'' NLS_DATE_FORMAT=''dd.mm.yyyy hh24:mi:ss'' NLS_DATE_LANGUAGE=''AMERICAN'' NL
S_SORT=''BINARY''',env=>'0102000200000000');
dbms_job.instance(job=>21, instance=>1, force=>TRUE);
Job 21 may be recreated by executing the PL/SQL calls generated by
DBMS_IJOB.FULL_EXPORT
.
REMOVE Procedure
Use this procedure to remove jobs in any schema.
Syntax
DBMS_IJOB.REMOVE(
job IN BINARY_INTEGER);
Parameters
Parameter
Description
job
Job number
Examples
Following is an example of deleting a job in a foreign schema:
SQL> SHOW USER
USER is "NDEBES"
SQL> SELECT priv_user FROM dba_jobs WHERE job=29;
PRIV_USER
