Question on SQL-based Administrative Task Scheduler

[situ]

i'm using db2 9.5 for windows. have created the following task ..

call SYSPROC.ADMIN_T ASK_ADD ( 'TASK1','2008-10-22
12:05:36.343000 ',NULL,NULL,'0 0 1 *
*','CCDB','SAMP LE',NULL,NULL,N ULL )

here i'm calling a procedure CCDB.SAMPLE with out any input parameter
in ADMIN_TASK_ADD procedure.

i want to known is it a correct way to execute the procedure without
input parameter..

do i need to add values() clause even though I'm not passing any input
parameter.

your help in this regard is highly appreciated.


Regards,
Situ

[ysee.geo@gmail.com]

Re: Question on SQL-based Administrative Task Scheduler

On Oct 22, 7:44 am, situ <SRIDHAR...@red iffmail.comwrot e:

i'm using db2 9.5 for windows. have created the following task ..
>
call  SYSPROC.ADMIN_T ASK_ADD ( 'TASK1','2008-10-22
12:05:36.343000 ',NULL,NULL,'0 0 1 *
*','CCDB','SAMP LE',NULL,NULL,N ULL )
>
here i'm calling a procedure CCDB.SAMPLE with out any input parameter
in ADMIN_TASK_ADD procedure.
>
i want to known is it a correct way to execute the procedure without
input parameter..
>
do i need to add values() clause even though I'm not passing any input
parameter.
>
your help in this regard is highly appreciated.
>
Regards,
Situ

Correct. If you have no input parameter, using NULL is correct.

The following developerWorks article might be of some interest to you:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0809see/