Coba set parameter dengan menggunakan procedure
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE.
--create job
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'TSDW'
,start_date => TO_TIMESTAMP_TZ('2007/02/12
12:30:00.000000 +07:00','yyyy/mm/dd hh24:mi:ss.ff
tzh:tzm')
,repeat_interval => NULL
,end_date => NULL
,job_class => 'DEFAULT_JOB_CLASS'
,job_type => 'STORED_PROCEDURE'
,job_action => 'MYR.SALES_DET'
,comments => NULL
);
END;
/
--set argument 1 utk program MYR.SALES_DET
BEGIN
SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
job_name => 'TSDW',
argument_position => 1,
argument_value => '2007');
END;
/
--set argument 2 utk program MYR.SALES_DET
BEGIN
SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
job_name => 'TSDW',
argument_position => 2,
argument_value => '51');
END;
/
--enable job
EXEC DBMS_SCHEDULER.ENABLE('TSDW');
regards,
tomi
--- Asep Inbisco IT <[EMAIL PROTECTED]> wrote:
> Belum bisa juga Mas Bowo, saya juga sudah search
> tapi belum ketemu juga,
> mungkin tipikalnya store procedure bila di run di
> job schedule tidak
> menggunakan parameter.
>
>
>
> Salam
>
> Asep
>
>
____________________________________________________________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
