Connecting Tech Pros Worldwide Forums | Help | Site Map

Question on SQL-based Administrative Task Scheduler

situ
Guest
 
Posts: n/a
#1: Oct 22 '08
i'm using db2 9.5 for windows. have created the following task ..

call SYSPROC.ADMIN_TASK_ADD ( 'TASK1','2008-10-22
12:05:36.343000',NULL,NULL,'0 0 1 *
*','CCDB','SAMPLE',NULL,NULL,NULL )

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
Guest
 
Posts: n/a
#2: Nov 2 '08

re: Question on SQL-based Administrative Task Scheduler


On Oct 22, 7:44*am, situ <SRIDHAR...@rediffmail.comwrote:
Quote:
i'm using db2 9.5 for windows. have created the following task ..
>
call *SYSPROC.ADMIN_TASK_ADD ( 'TASK1','2008-10-22
12:05:36.343000',NULL,NULL,'0 0 1 *
*','CCDB','SAMPLE',NULL,NULL,NULL )
>
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/db...le/dm-0809see/
Closed Thread


Similar DB2 Database bytes