On Jul 15, 10:49 am, karthic M <karthicsel...@gmail.com> wrote:
> @ddf Please give d detail in oracle 10g with example
> thx for advance
>
>
>
>
>
> On Wed, Jul 15, 2009 at 8:30 PM, ddf <orat...@msn.com> wrote:
>
> > On Jul 15, 8:32 am, karthic M <karthicsel...@gmail.com> wrote:
> > > @ David oracle 9i OR 10g any one....
>
> > > On Wed, Jul 15, 2009 at 6:46 PM, ddf <orat...@msn.com> wrote:
>
> > > > On Jul 14, 4:02 pm, karthic M <karthicsel...@gmail.com> wrote:
> > > > > Hi friends, i want to know how to create a job & how to run
> > a
> > > > job
> > > > > for every 5 minutes
>
> > > > > for example i have customer table
> > > > > cusid cusname product sales_amt date
>
> > > > > i have a procedure called cus_proc i want to run this cus_proc for
> > every
> > > > 5
> > > > > min.
> > > > > please explain with example
>
> > > > > Thanks for advance...
> > > > > --
> > > > > karthic.M
>
> > > > Which release of Oracle?
>
> > > > David Fitzjarrell
>
> > > --
> > > karthic.M- Hide quoted text -
>
> > > - Show quoted text -
>
> > Decide which release, as the task differs between 9i and 10g releases.
>
> > David Fitzjarrell
>
> --
> karthic.M- Hide quoted text -
>
> - Show quoted text -
SQL> conn jobdemo/jobdemo
Connected.
SQL>
SQL> set linesize 121
SQL>
SQL> -- create directory
SQL> CREATE OR REPLACE DIRECTORY ctemp AS 'c:\\temp';
Directory created.
SQL>
SQL> -- create load files
SQL> -- 01012008.dat
SQL> -- 20046,32.83732,-96.80432
SQL> -- 20056,32.58215,-97.35639
SQL> -- 20057,32.85561,-97.24912
SQL> -- 20058,32.81017,-96.96251
SQL> -- 20060,32.85566,-97.25105
SQL>
SQL> -- 01022008.dat
SQL> -- 20061,32.85367,-97.24873
SQL> -- 20063,32.85435,-97.24535
SQL> -- 20064,32.85414,-97.24550
SQL> -- 20065,32.75283,-97.25089
SQL> -- 20066,32.84538,-96.97260
SQL>
SQL> -- 01032008.dat
SQL> -- 19882,32.83566,-96.96873
SQL> -- 19898,32.83508,-96.93626
SQL> -- 19900,32.86650,-97.24690
SQL> -- 19915,32.81678,-96.95659
SQL> -- 19816,32.83405,-96.97099
SQL>
SQL> -- 01042008.dat
SQL> -- 19817,32.83386,-96.97072
SQL> -- 19818,32.95360,-96.99048
SQL> -- 19820,32.81636,-96.97261
SQL> -- 19833,32.82940,-96.97367
SQL> -- 19836,32.83260,-96.94896
SQL>
SQL> -- 01052008.dat
SQL> -- 19837,32.87159,-97.24725
SQL> -- 19839,32.83503,-96.93805
SQL> -- 19841,32.86650,-97.24690
SQL> -- 19843,32.86424,-97.24691
SQL> -- 19844,32.83270,-96.97369
SQL>
SQL> -- create table
SQL> CREATE TABLE locations (
2 location_id NUMBER(10),
3 latitude FLOAT(20),
4 longitude FLOAT(20));
Table created.
SQL>
SQL> -- create stored procedure
SQL> CREATE OR REPLACE PACKAGE sched_demo IS
2 runno PLS_INTEGER := 0;
3 PROCEDURE load_data(fname number, yearno PLS_INTEGER);
4 END sched_demo;
5 /
Package created.
SQL>
SQL> CREATE OR REPLACE PACKAGE BODY sched_demo IS
2
3 PROCEDURE load_data(fname number, yearno PLS_INTEGER) IS
4 vSFile utl_file.file_type;
5 vNewLine VARCHAR2(200);
6 p1 PLS_INTEGER;
7 p2 PLS_INTEGER;
8 locid locations.location_id%TYPE;
9 latit locations.latitude%TYPE;
10 longi locations.longitude%TYPE;
11 BEGIN
12 vSFile := utl_file.fopen('CTEMP', to_char(lpad(fname+runno,
4,'0')) || TO_CHAR(yearno) || '.dat', 'R');
13 LOOP
14 BEGIN
15 utl_file.get_line(vSFile, vNewLine);
16 IF vNewLine IS NULL THEN
17 EXIT;
18 END IF;
19
20 p1 := INSTR(vNewLine,',',1,1);
21 p2 := INSTR(vNewLine,',',1,2);
22 locid := SUBSTR(vNewLine, 1, p1-1);
23 latit := SUBSTR(vNewLine, p1+1, p2-p1-1);
24 longi := SUBSTR(vNewLine, 15+1);
25
26 INSERT INTO locations
27 (location_id, latitude, longitude)
28 VALUES
29 (locid, latit, longi);
30 EXCEPTION
31 WHEN NO_DATA_FOUND THEN
32 EXIT;
33 END;
34 END LOOP;
35 COMMIT;
36 utl_file.fclose(vSFile);
37
38 runno := runno + 1;
39 utl_file.frename('CTEMP',to_char(lpad(fname+runno-1, 4,'0')) ||
TO_CHAR(yearno) || '.dat',
40 'CTEMP', TO_CHAR(runno) || '.arc', TRUE);
41 EXCEPTION
42 WHEN OTHERS THEN
43 NULL;
44 END load_data;
45
46 END sched_demo;
47 /
Package body created.
SQL>
SQL>
SQL> -- test procedure
SQL> exec sched_demo.load_data(101, 2008);
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT * FROM locations;
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20046 32.83732 -96.80432
20056 32.58215 -97.35639
20057 32.85561 -97.24912
20058 32.81017 -96.96251
20060 32.85566 -97.25105
SQL>
SQL> TRUNCATE TABLE locations;
Table truncated.
SQL>
SQL> -- rename 1.arc back to 01012008.dat
SQL> $mv c:\temp\1.arc c:\temp\01012008.dat
SQL>
SQL> -- create a program with all job arguments
SQL> -- requires create job privilege
SQL> BEGIN
2 dbms_scheduler.create_program(
3 program_name => 'Run_LOAD_DATA',
4 program_type => 'STORED_PROCEDURE',
5 program_action => 'SCHED_DEMO.LOAD_DATA',
6 number_of_arguments => 2,
7 enabled => FALSE,
8 comments => 'UW Test Scheduled Load');
9 END;
10 /
PL/SQL procedure successfully completed.
SQL>
SQL> desc all_scheduler_programs
Name
Null? Type
-----------------------------------------------------------------
-------- ---------------------------------------------
OWNER NOT
NULL VARCHAR2(30)
PROGRAM_NAME NOT
NULL VARCHAR2(30)
PROGRAM_TYPE
VARCHAR2(16)
PROGRAM_ACTION
VARCHAR2(4000)
NUMBER_OF_ARGUMENTS
NUMBER
ENABLED
VARCHAR2(5)
DETACHED
VARCHAR2(5)
SCHEDULE_LIMIT
INTERVAL DAY(3) TO SECOND(0)
PRIORITY
NUMBER
WEIGHT
NUMBER
MAX_RUNS
NUMBER
MAX_FAILURES
NUMBER
MAX_RUN_DURATION
INTERVAL DAY(3) TO SECOND(0)
NLS_ENV
VARCHAR2(4000)
COMMENTS
VARCHAR2(240)
SQL>
SQL> col owner format a10
SQL> col program_name format a25
SQL> col program_action format a45
SQL> col comments format a55
SQL>
SQL> SELECT owner, program_name, program_type, program_action
2 FROM all_scheduler_programs;
OWNER PROGRAM_NAME PROGRAM_TYPE PROGRAM_ACTION
---------- ------------------------- ----------------
---------------------------------------------
SYS JDM_XFORM_SEQ_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.xform_seq_task
SYS JDM_PROFILE_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.profile_task
SYS JDM_EXPLAIN_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.explain_task
SYS JDM_PREDICT_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.PREDICT_TASK
SYS JDM_XFORM_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.xform_task
SYS JDM_IMPORT_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.import_task
SYS JDM_EXPORT_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.export_task
SYS JDM_SQL_APPLY_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.sql_apply_task
SYS JDM_TEST_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.test_task
SYS JDM_BUILD_PROGRAM STORED_PROCEDURE
SYS.dbms_jdm_internal.build_task
SYS HS_PARALLEL_SAMPLING STORED_PROCEDURE
sys.dbms_hs_parallel_metadata.table_sampling
OWNER PROGRAM_NAME PROGRAM_TYPE PROGRAM_ACTION
---------- ------------------------- ----------------
---------------------------------------------
JOBDEMO RUN_LOAD_DATA STORED_PROCEDURE
SCHED_DEMO.LOAD_DATA
12 rows selected.
SQL>
SQL> SELECT owner, program_name, enabled, comments
2 FROM all_scheduler_programs;
OWNER PROGRAM_NAME ENABL COMMENTS
---------- ------------------------- -----
-------------------------------------------------------
SYS JDM_XFORM_SEQ_PROGRAM TRUE Used for transformation
sequence task using JDM API
SYS JDM_PROFILE_PROGRAM TRUE Used for profile using JDM
API
SYS JDM_EXPLAIN_PROGRAM TRUE Used for explain using JDM
API
SYS JDM_PREDICT_PROGRAM TRUE Used for predict using JDM
API
SYS JDM_XFORM_PROGRAM TRUE Used for transformation
using JDM API
SYS JDM_IMPORT_PROGRAM TRUE Used for importing a mining
model using JDM API
SYS JDM_EXPORT_PROGRAM TRUE Used for exporting a mining
model using JDM API
SYS JDM_SQL_APPLY_PROGRAM TRUE Used for applying a mining
model using JDM API
SYS JDM_TEST_PROGRAM TRUE Used for testing a mining
model using JDM API
SYS JDM_BUILD_PROGRAM TRUE Used for building a mining
model using JDM API
SYS HS_PARALLEL_SAMPLING TRUE
OWNER PROGRAM_NAME ENABL COMMENTS
---------- ------------------------- -----
-------------------------------------------------------
JOBDEMO RUN_LOAD_DATA FALSE UW Test Scheduled Load
12 rows selected.
SQL>
SQL> -- set program argument
SQL> SELECT overload, position, argument_name, data_type
2 FROM all_arguments
3 WHERE object_name = 'SCHED_DEMO.LOAD_DATA';
no rows selected
SQL>
SQL> BEGIN
2 dbms_scheduler.define_program_argument(
3 program_name => 'Run_LOAD_DATA',
4 argument_position => 1,
5 argument_type => 'NUMBER',
6 default_value => 101);
7
8 dbms_scheduler.define_program_argument(
9 program_name => 'Run_LOAD_DATA',
10 argument_position => 2,
11 argument_type => 'NUMBER',
12 default_value => 2008);
13 END;
14 /
PL/SQL procedure successfully completed.
SQL>
SQL> desc all_scheduler_job_args
Name
Null? Type
-----------------------------------------------------------------
-------- ---------------------------------------------
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(30)
ARGUMENT_NAME
VARCHAR2(30)
ARGUMENT_POSITION
NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
VALUE
VARCHAR2(4000)
ANYDATA_VALUE
SYS.ANYDATA
OUT_ARGUMENT
VARCHAR2(5)
SQL>
SQL> col job_name format a15
SQL> col argument_type format a20
SQL> col default_value format a20
SQL>
SQL> SELECT program_name, argument_name, argument_position,
argument_type,
2 default_value
3 FROM all_scheduler_program_args;
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_BUILD_PROGRAM
CURRENT_TASK_NAME 17
<NO VALUE>
JDM_BUILD_PROGRAM
CHILD_TASKS 16 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_BUILD_PROGRAM
PARENT_TASKS 15 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_BUILD_PROGRAM
OVERWRITE_OUTPUT 14 CHAR
N
JDM_BUILD_PROGRAM
XFORM_SEQ_NAME 13 VARCHAR2
JDM_BUILD_PROGRAM
REMOVE_SETTINGS_TABLE 12 CHAR
Y
JDM_BUILD_PROGRAM
SETTINGS_SCHEMA_NAME 11 VARCHAR2
JDM_BUILD_PROGRAM
DATA_SCHEMA_NAME 10 VARCHAR2
JDM_BUILD_PROGRAM
SETTINGS_TABLE_NAME 9 VARCHAR2
JDM_BUILD_PROGRAM
TARGET_COLUMN_NAME 8 VARCHAR2
JDM_BUILD_PROGRAM
MODEL_DESCRIPTION 7 VARCHAR2
<NO VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_BUILD_PROGRAM
BUILD_SETTINGS_NAME 6 VARCHAR2
<NO VALUE>
JDM_BUILD_PROGRAM
PDS_NAME 5 VARCHAR2
<NO VALUE>
JDM_BUILD_PROGRAM
CASE_ID_COLUMN_NAME 4 VARCHAR2
<NO VALUE>
JDM_BUILD_PROGRAM
DATA_TABLE_NAME 3 VARCHAR2
<NO VALUE>
JDM_BUILD_PROGRAM
MINING_FUNCTION 2 VARCHAR2
<NO VALUE>
JDM_BUILD_PROGRAM
MODEL_NAME 1 VARCHAR2
<NO VALUE>
JDM_EXPLAIN_PROGRAM
CURRENT_TASK_NAME 8
<NO VALUE>
JDM_EXPLAIN_PROGRAM
CHILD_TASKS 7 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_EXPLAIN_PROGRAM
PARENT_TASKS 6 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_EXPLAIN_PROGRAM
OVERWRITE_OUTPUT 5 CHAR
N
JDM_EXPLAIN_PROGRAM
DATA_SCHEMA_NAME 4 VARCHAR2
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_EXPLAIN_PROGRAM
RESULT_TABLE_NAME 3 VARCHAR2
<NO VALUE>
JDM_EXPLAIN_PROGRAM
EXPLAIN_COLUMN_NAME 2 VARCHAR2
<NO VALUE>
JDM_EXPLAIN_PROGRAM
DATA_TABLE_NAME 1 VARCHAR2
<NO VALUE>
JDM_EXPORT_PROGRAM
CURRENT_TASK_NAME 11
<NO VALUE>
JDM_EXPORT_PROGRAM
CHILD_TASKS 10 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_EXPORT_PROGRAM
PARENT_TASKS 9 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_EXPORT_PROGRAM
OVERWRITE_OUTPUT 8 CHAR
N
JDM_EXPORT_PROGRAM
JOBNAME 7 VARCHAR2
JDM_EXPORT_PROGRAM
REMOTE_LINK 6 VARCHAR2
JDM_EXPORT_PROGRAM
OPERATION 5 VARCHAR2
JDM_EXPORT_PROGRAM
FILESIZE 4 VARCHAR2
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_EXPORT_PROGRAM
MODEL_FILTER 3 VARCHAR2
JDM_EXPORT_PROGRAM
DIRECTORY 2 VARCHAR2
<NO VALUE>
JDM_EXPORT_PROGRAM
FILENAME 1 VARCHAR2
<NO VALUE>
JDM_IMPORT_PROGRAM
CURRENT_TASK_NAME 11
<NO VALUE>
JDM_IMPORT_PROGRAM
CHILD_TASKS 10 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_IMPORT_PROGRAM
PARENT_TASKS 9 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_IMPORT_PROGRAM
OVERWRITE_OUTPUT 8 CHAR
N
JDM_IMPORT_PROGRAM
SCHEMA_REMAP 7 VARCHAR2
JDM_IMPORT_PROGRAM
JOBNAME 6 VARCHAR2
JDM_IMPORT_PROGRAM
REMOTE_LINK 5 VARCHAR2
JDM_IMPORT_PROGRAM
OPERATION 4 VARCHAR2
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_IMPORT_PROGRAM
MODEL_FILTER 3 VARCHAR2
JDM_IMPORT_PROGRAM
DIRECTORY 2 VARCHAR2
<NO VALUE>
JDM_IMPORT_PROGRAM
FILENAME 1 VARCHAR2
<NO VALUE>
JDM_PREDICT_PROGRAM
CURRENT_TASK_NAME 9
<NO VALUE>
JDM_PREDICT_PROGRAM
CHILD_TASKS 8 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_PREDICT_PROGRAM
PARENT_TASKS 7 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_PREDICT_PROGRAM
OVERWRITE_OUTPUT 6 CHAR
N
JDM_PREDICT_PROGRAM
DATA_SCHEMA_NAME 5 VARCHAR2
JDM_PREDICT_PROGRAM
RESULT_TABLE_NAME 4 VARCHAR2
<NO VALUE>
JDM_PREDICT_PROGRAM
TARGET_COLUMN_NAME 3 VARCHAR2
<NO VALUE>
JDM_PREDICT_PROGRAM
CASE_ID_COLUMN_NAME 2 VARCHAR2
<NO VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_PREDICT_PROGRAM
DATA_TABLE_NAME 1 VARCHAR2
<NO VALUE>
JDM_PROFILE_PROGRAM
CURRENT_TASK_NAME 8
<NO VALUE>
JDM_PROFILE_PROGRAM
CHILD_TASKS 7 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_PROFILE_PROGRAM
PARENT_TASKS 6 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_PROFILE_PROGRAM
OVERWRITE_OUTPUT 5 CHAR
N
JDM_PROFILE_PROGRAM
DATA_SCHEMA_NAME 4 VARCHAR2
JDM_PROFILE_PROGRAM
RESULT_TABLE_NAME 3 VARCHAR2
<NO VALUE>
JDM_PROFILE_PROGRAM
TARGET_COLUMN_NAME 2 VARCHAR2
<NO VALUE>
JDM_PROFILE_PROGRAM
DATA_TABLE_NAME 1 VARCHAR2
<NO VALUE>
JDM_SQL_APPLY_PROGRAM
CURRENT_TASK_NAME 26
<NO VALUE>
JDM_SQL_APPLY_PROGRAM
CHILD_TASKS 25 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_SQL_APPLY_PROGRAM
PARENT_TASKS 24 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
OVERWRITE_OUTPUT 23 CHAR
N
JDM_SQL_APPLY_PROGRAM
VIEW_OUTPUT 22 CHAR
N
JDM_SQL_APPLY_PROGRAM
REGR_TARGET_NORM_SHIFT_VALUE 21 NUMBER
JDM_SQL_APPLY_PROGRAM
REGR_TARGET_NORM_SCALE_VALUE 20 NUMBER
JDM_SQL_APPLY_PROGRAM
COST_MATRIX_SCHEMA_NAME 19 VARCHAR2
JDM_SQL_APPLY_PROGRAM
APPLY_RESULT_SCHEMA_NAME 18 VARCHAR2
JDM_SQL_APPLY_PROGRAM
COST_MATRIX_TABLE_NAME 17 VARCHAR2
JDM_SQL_APPLY_PROGRAM
USECOSTMATRIXFROMMODEL 16 NUMBER
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
TOP_N 15 NUMBER
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
STR_TARGET_OR_CLUSTER_VALS 14 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_SQL_APPLY_PROGRAM
NUM_TARGET_OR_CLUSTER_VALS 13 SYS.JDM_NUM_VALS
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
CONTENT_DEST_ATTRS 12 SYS.JDM_ATTR_NAMES
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
CONTENT_TYPES 11 SYS.JDM_NUM_VALS
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
DESTINATION_ATTRS 10 SYS.JDM_ATTR_NAMES
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
SOURCE_ATTRS 9 SYS.JDM_ATTR_NAMES
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
APPLY_OUTPUT_TYPE 8 NUMBER
<NON-VARCHAR2 VALUE>
JDM_SQL_APPLY_PROGRAM
DATA_SCHEMA_NAME 7 VARCHAR2
JDM_SQL_APPLY_PROGRAM
PDS_NAME 6 VARCHAR2
<NO VALUE>
JDM_SQL_APPLY_PROGRAM
APPLY_SETTINGS_NAME 5 VARCHAR2
<NO VALUE>
JDM_SQL_APPLY_PROGRAM
RESULT_TABLE_NAME 4 VARCHAR2
<NO VALUE>
JDM_SQL_APPLY_PROGRAM
CASE_ID_COLUMN_NAME 3 VARCHAR2
<NO VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_SQL_APPLY_PROGRAM
DATA_TABLE_NAME 2 VARCHAR2
<NO VALUE>
JDM_SQL_APPLY_PROGRAM
MODEL_NAME 1 VARCHAR2
<NO VALUE>
JDM_TEST_PROGRAM
USE_COST 27 CHAR
N
JDM_TEST_PROGRAM
CURRENT_TASK_NAME 26
<NO VALUE>
JDM_TEST_PROGRAM
CHILD_TASKS 25 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_TEST_PROGRAM
PARENT_TASKS 24 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_TEST_PROGRAM
OVERWRITE_OUTPUT 23 CHAR
N
JDM_TEST_PROGRAM
APPLY_RESULT_NAME 22 VARCHAR2
JDM_TEST_PROGRAM
TEST_METRICS_DESCRIPTION 21 VARCHAR2
JDM_TEST_PROGRAM
ROC_NAME 20 VARCHAR2
JDM_TEST_PROGRAM
LFT_NAME 19 VARCHAR2
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_TEST_PROGRAM
CFM_NAME 18 VARCHAR2
JDM_TEST_PROGRAM
MINING_FUNCTION 17 VARCHAR2
JDM_TEST_PROGRAM
ACTUAL_TARGET_COLUMN_NAME 16 VARCHAR2
JDM_TEST_PROGRAM
COST_MATRIX_SCHEMA_NAME 15 VARCHAR2
JDM_TEST_PROGRAM
COST_MATRIX_TABLE_NAME 14 VARCHAR2
JDM_TEST_PROGRAM
SCORE_CRITERION_COLUMN_NAME 13 VARCHAR2
PROBABILITY
JDM_TEST_PROGRAM
SCORE_COLUMN_NAME 12 VARCHAR2
PREDICTION
JDM_TEST_PROGRAM
DATA_SCHEMA_NAME 11 VARCHAR2
JDM_TEST_PROGRAM
PDS_NAME 10 VARCHAR2
<NO VALUE>
JDM_TEST_PROGRAM
TEST_METRICS_NAME 9 VARCHAR2
<NO VALUE>
JDM_TEST_PROGRAM
NUM_QUANTILES 8 NUMBER
10
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_TEST_PROGRAM
POSITIVE_TARGET_VALUE 7 VARCHAR2
JDM_TEST_PROGRAM
COMPUTE_ROC 6 CHAR
Y
JDM_TEST_PROGRAM
COMPUTE_LIFT 5 CHAR
Y
JDM_TEST_PROGRAM
COMPUTE_CONFUSION_MATRIX 4 CHAR
Y
JDM_TEST_PROGRAM
CASE_ID_COLUMN_NAME 3 VARCHAR2
<NO VALUE>
JDM_TEST_PROGRAM
DATA_TABLE_NAME 2 VARCHAR2
<NO VALUE>
JDM_TEST_PROGRAM
MODEL_NAME 1 VARCHAR2
<NO VALUE>
JDM_XFORM_PROGRAM
TEXT_COLS 12 SYS.JDM_ATTR_NAMES
<NON-VARCHAR2 VALUE>
JDM_XFORM_PROGRAM
BINNING_LITERAL_FALG 11 CHAR
Y
JDM_XFORM_PROGRAM
XFORM_SETTINGS_SCHEMA_2 10 VARCHAR2
JDM_XFORM_PROGRAM
XFORM_SETTINGS_SCHEMA_1 9 VARCHAR2
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_XFORM_PROGRAM
INPUT_SCHEMA_NAME 8 VARCHAR2
JDM_XFORM_PROGRAM
OUTPUT_SCHEMA_NAME 7 VARCHAR2
JDM_XFORM_PROGRAM
XFORM_SETTINGS_TABLE_2 6 VARCHAR2
JDM_XFORM_PROGRAM
XFORM_SETTINGS_TABLE_1 5 VARCHAR2
JDM_XFORM_PROGRAM
IS_VIEW_OUTPUT 4 CHAR
Y
JDM_XFORM_PROGRAM
INPUT_TABLE_NAME 3 VARCHAR2
<NO VALUE>
JDM_XFORM_PROGRAM
OUTPUT_TABLE_NAME 2 VARCHAR2
<NO VALUE>
JDM_XFORM_PROGRAM
XFORM_TYPE 1 VARCHAR2
<NO VALUE>
JDM_XFORM_PROGRAM
CURRENT_TASK_NAME 18
<NO VALUE>
JDM_XFORM_PROGRAM
CHILD_TASKS 17 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_XFORM_PROGRAM
PARENT_TASKS 16 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
JDM_XFORM_PROGRAM
OVERWRITE_OUTPUT 15 CHAR
N
JDM_XFORM_PROGRAM
FEATURE_TABLES 14 SYS.JDM_ATTR_NAMES
<NON-VARCHAR2 VALUE>
JDM_XFORM_PROGRAM
CASE_ID 13 VARCHAR2
JDM_XFORM_SEQ_PROGRAM
CURRENT_TASK_NAME 7
<NO VALUE>
JDM_XFORM_SEQ_PROGRAM
CHILD_TASKS 6 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_XFORM_SEQ_PROGRAM
PARENT_TASKS 5 SYS.JDM_STR_VALS
<NON-VARCHAR2 VALUE>
JDM_XFORM_SEQ_PROGRAM
OVERWRITE_OUTPUT 4 CHAR
N
JDM_XFORM_SEQ_PROGRAM
XFORM_SEQ_SCHEMA_NAME 3 VARCHAR2
JDM_XFORM_SEQ_PROGRAM
USE_XFORM_DEF_TABLES 2 VARCHAR2
Y
JDM_XFORM_SEQ_PROGRAM
XFORM_SEQ_TABLE_NAME 1 VARCHAR2
<NO VALUE>
HS_PARALLEL_SAMPLING
12 SYS.HSBLKNAMLST <NO VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
HS_PARALLEL_SAMPLING
11 SYS.HSBLKNAMLST <NO VALUE>
HS_PARALLEL_SAMPLING
10 SYS.HSBLKNAMLST <NO VALUE>
HS_PARALLEL_SAMPLING
9 SYS.HSBLKNAMLST <NO VALUE>
HS_PARALLEL_SAMPLING
8 VARCHAR2 <NO VALUE>
HS_PARALLEL_SAMPLING
7 VARCHAR2 <NO VALUE>
HS_PARALLEL_SAMPLING
6 NUMBER <NO VALUE>
HS_PARALLEL_SAMPLING
5 NUMBER <NO VALUE>
HS_PARALLEL_SAMPLING
4 VARCHAR2 <NO VALUE>
HS_PARALLEL_SAMPLING
3 VARCHAR2 <NO VALUE>
HS_PARALLEL_SAMPLING
2 VARCHAR2 <NO VALUE>
HS_PARALLEL_SAMPLING
1 VARCHAR2 <NO VALUE>
PROGRAM_NAME ARGUMENT_NAME
ARGUMENT_POSITION ARGUMENT_TYPE DEFAULT_VALUE
------------------------- ------------------------------
----------------- -------------------- --------------------
RUN_LOAD_DATA
1 NUMBER 101
RUN_LOAD_DATA
2 NUMBER 2008
156 rows selected.
SQL>
SQL> -- create job
SQL> BEGIN
2 dbms_scheduler.create_job(
3 job_name => 'UW_File_Load',
4 program_name => 'Run_LOAD_DATA',
5 start_date => dbms_scheduler.stime,
6 repeat_interval => 'FREQ=MINUTELY;INTERVAL=1',
7 end_date => dbms_scheduler.stime+1,
8 enabled => FALSE,
9 auto_drop => FALSE,
10 comments => 'UW Demo Job');
11 END;
12 /
PL/SQL procedure successfully completed.
SQL>
SQL> desc all_scheduler_jobs
Name
Null? Type
-----------------------------------------------------------------
-------- ---------------------------------------------
OWNER
VARCHAR2(30)
JOB_NAME
VARCHAR2(30)
JOB_SUBNAME
VARCHAR2(30)
JOB_STYLE
VARCHAR2(11)
JOB_CREATOR
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
PROGRAM_OWNER
VARCHAR2(4000)
PROGRAM_NAME
VARCHAR2(4000)
JOB_TYPE
VARCHAR2(16)
JOB_ACTION
VARCHAR2(4000)
NUMBER_OF_ARGUMENTS
NUMBER
SCHEDULE_OWNER
VARCHAR2(4000)
SCHEDULE_NAME
VARCHAR2(4000)
SCHEDULE_TYPE
VARCHAR2(12)
START_DATE
TIMESTAMP(6) WITH TIME ZONE
REPEAT_INTERVAL
VARCHAR2(4000)
EVENT_QUEUE_OWNER
VARCHAR2(30)
EVENT_QUEUE_NAME
VARCHAR2(30)
EVENT_QUEUE_AGENT
VARCHAR2(256)
EVENT_CONDITION
VARCHAR2(4000)
EVENT_RULE
VARCHAR2(65)
END_DATE
TIMESTAMP(6) WITH TIME ZONE
JOB_CLASS
VARCHAR2(30)
ENABLED
VARCHAR2(5)
AUTO_DROP
VARCHAR2(5)
RESTARTABLE
VARCHAR2(5)
STATE
VARCHAR2(15)
JOB_PRIORITY
NUMBER
RUN_COUNT
NUMBER
MAX_RUNS
NUMBER
FAILURE_COUNT
NUMBER
MAX_FAILURES
NUMBER
RETRY_COUNT
NUMBER
LAST_START_DATE
TIMESTAMP(6) WITH TIME ZONE
LAST_RUN_DURATION
INTERVAL DAY(9) TO SECOND(6)
NEXT_RUN_DATE
TIMESTAMP(6) WITH TIME ZONE
SCHEDULE_LIMIT
INTERVAL DAY(3) TO SECOND(0)
MAX_RUN_DURATION
INTERVAL DAY(3) TO SECOND(0)
LOGGING_LEVEL
VARCHAR2(11)
STOP_ON_WINDOW_CLOSE
VARCHAR2(5)
INSTANCE_STICKINESS
VARCHAR2(5)
RAISE_EVENTS
VARCHAR2(4000)
SYSTEM
VARCHAR2(5)
JOB_WEIGHT
NUMBER
NLS_ENV
VARCHAR2(4000)
SOURCE
VARCHAR2(128)
DESTINATION
VARCHAR2(128)
CREDENTIAL_OWNER
VARCHAR2(30)
CREDENTIAL_NAME
VARCHAR2(30)
INSTANCE_ID
NUMBER
DEFERRED_DROP
VARCHAR2(5)
COMMENTS
VARCHAR2(240)
FLAGS
NUMBER
SQL>
SQL> col start_date format a40
SQL>
SQL> SELECT job_name, program_name, start_date
2 FROM all_scheduler_jobs;
JOB_NAME PROGRAM_NAME START_DATE
--------------- -------------------------
----------------------------------------
UW_FILE_LOAD RUN_LOAD_DATA 15-JUL-09 12.42.27.297000 PM
US/CENTRAL
SQL>
SQL> -- set scheduler attributes
SQL> col value format a50
SQL>
SQL> SELECT attribute_name, value
2 FROM all_scheduler_global_attribute;
ATTRIBUTE_NAME VALUE
------------------------------
--------------------------------------------------
MAX_JOB_SLAVE_PROCESSES 2
LOG_HISTORY 30
DEFAULT_TIMEZONE US/Central
LAST_OBSERVED_EVENT
EVENT_EXPIRY_TIME
CURRENT_OPEN_WINDOW
6 rows selected.
SQL>
SQL> -- requires manage scheduler privilege
SQL> BEGIN
2 dbms_scheduler.set_scheduler_attribute
('MAX_JOB_SLAVE_PROCESSES', 2);
3 END;
4 /
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT attribute_name, value
2 FROM all_scheduler_global_attribute;
ATTRIBUTE_NAME VALUE
------------------------------
--------------------------------------------------
MAX_JOB_SLAVE_PROCESSES 2
LOG_HISTORY 30
DEFAULT_TIMEZONE US/Central
LAST_OBSERVED_EVENT
EVENT_EXPIRY_TIME
CURRENT_OPEN_WINDOW
6 rows selected.
SQL>
SQL> -- enable the program
SQL> exec dbms_scheduler.enable('Run_LOAD_DATA');
PL/SQL procedure successfully completed.
SQL> -- enable the job
SQL> exec dbms_scheduler.enable('UW_File_Load');
PL/SQL procedure successfully completed.
SQL>
SQL> exec sys.dbms_lock.sleep(3);
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT * FROM locations;
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20046 32.83732 -96.80432
20056 32.58215 -97.35639
20057 32.85561 -97.24912
20058 32.81017 -96.96251
20060 32.85566 -97.25105
SQL>
SQL> -- test the job
SQL> exec dbms_scheduler.run_job('UW_File_Load', TRUE);
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT * FROM locations;
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20061 32.85367 -97.24873
20063 32.85435 -97.24535
20064 32.85414 -97.2455
20065 32.75283 -97.25089
20066 32.84538 -96.9726
20046 32.83732 -96.80432
20056 32.58215 -97.35639
20057 32.85561 -97.24912
20058 32.81017 -96.96251
20060 32.85566 -97.25105
10 rows selected.
SQL>
SQL> col additional_info format a25
SQL>
SQL> SELECT job_name, operation, status, additional_info
2 FROM all_scheduler_job_log;
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN FAILED
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN SUCCEEDED
UW_FILE_LOAD RUN
SUCCEEDED REASON="manually run"
UW_FILE_LOAD RUN FAILED
UW_FILE_LOAD RUN
FAILED REASON="manually run"
JOB_NAME OPERATION
STATUS ADDITIONAL_INFO
--------------- ------------------------------
------------------------------ -------------------------
UW_FILE_LOAD RUN
STOPPED REASON="Stop job with for
ce called by user: 'JOBDE
MO'"
67 rows selected.
SQL>
SQL> SELECT job_name, state, run_count, next_run_date
2 FROM all_scheduler_jobs;
JOB_NAME STATE RUN_COUNT NEXT_RUN_DATE
--------------- --------------- ----------
---------------------------------------------------------------------------
UW_FILE_LOAD SCHEDULED 1 15-JUL-09 12.43.27.500000
PM US/CENTRAL
SQL>
SQL> -- watch the job run renaming files as required to avoid a
conflict
SQL>
SQL> exec dbms_scheduler.run_job('UW_File_Load', TRUE);
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT * FROM locations;
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20061 32.85367 -97.24873
20063 32.85435 -97.24535
20064 32.85414 -97.2455
20065 32.75283 -97.25089
20066 32.84538 -96.9726
19882 32.83566 -96.96873
19898 32.83508 -96.93626
19900 32.8665 -97.2469
19915 32.81678 -96.95659
19816 32.83405 -96.97099
20046 32.83732 -96.80432
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20056 32.58215 -97.35639
20057 32.85561 -97.24912
20058 32.81017 -96.96251
20060 32.85566 -97.25105
15 rows selected.
SQL>
SQL> exec dbms_scheduler.run_job('UW_File_Load', TRUE);
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT * FROM locations;
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20061 32.85367 -97.24873
20063 32.85435 -97.24535
20064 32.85414 -97.2455
20065 32.75283 -97.25089
20066 32.84538 -96.9726
19882 32.83566 -96.96873
19898 32.83508 -96.93626
19900 32.8665 -97.2469
19915 32.81678 -96.95659
19816 32.83405 -96.97099
19817 32.83386 -96.97072
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
19818 32.9536 -96.99048
19820 32.81636 -96.97261
19833 32.8294 -96.97367
19836 32.8326 -96.94896
20046 32.83732 -96.80432
20056 32.58215 -97.35639
20057 32.85561 -97.24912
20058 32.81017 -96.96251
20060 32.85566 -97.25105
20 rows selected.
SQL>
SQL> exec dbms_scheduler.run_job('UW_File_Load', TRUE);
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT * FROM locations;
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20061 32.85367 -97.24873
20063 32.85435 -97.24535
20064 32.85414 -97.2455
20065 32.75283 -97.25089
20066 32.84538 -96.9726
19882 32.83566 -96.96873
19898 32.83508 -96.93626
19900 32.8665 -97.2469
19915 32.81678 -96.95659
19816 32.83405 -96.97099
19817 32.83386 -96.97072
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
19818 32.9536 -96.99048
19820 32.81636 -96.97261
19833 32.8294 -96.97367
19836 32.8326 -96.94896
19837 32.87159 -97.24725
19839 32.83503 -96.93805
19841 32.8665 -97.2469
19843 32.86424 -97.24691
19844 32.8327 -96.97369
20046 32.83732 -96.80432
20056 32.58215 -97.35639
LOCATION_ID LATITUDE LONGITUDE
----------- ---------- ----------
20057 32.85561 -97.24912
20058 32.81017 -96.96251
20060 32.85566 -97.25105
25 rows selected.
SQL>
SQL> -- clean up
SQL> BEGIN
2 -- stop the job
3 BEGIN
4 dbms_scheduler.stop_job('UW_File_Load', TRUE);
5 EXCEPTION
6 WHEN OTHERS THEN
7 NULL;
8 END;
9 -- drop program argument
10 dbms_scheduler.drop_program_argument('Run_LOAD_DATA', 1);
11 dbms_scheduler.drop_program_argument('Run_LOAD_DATA', 2);
12 -- disable the program
13 dbms_scheduler.disable('Run_LOAD_DATA', TRUE);
14 -- drop the program
15 dbms_scheduler.drop_program('Run_LOAD_DATA', TRUE);
16 -- drop the job
17 dbms_scheduler.drop_job('UW_File_Load', TRUE);
18 END;
19 /
PL/SQL procedure successfully completed.
SQL>
SQL> spool off
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
