Page 1 of 1

Passing a value from oracle table as a parameter

Posted: Thu Nov 11, 2010 6:43 am
by mac4rfree85
Hi Guys,

I have a table which maintains the start and end time of the job.
I need to pass the endtime of the last ran job as parameter to another job.
I have to query to get the endtime of the last ran job.
But how to pass that value as parameter to the other job.

Thanks for your help in advance,

Magesh

Posted: Thu Nov 11, 2010 6:44 am
by chulett
Search here for USERSTATUS.

Posted: Thu Nov 11, 2010 7:02 am
by mac4rfree85
thanks Ray for that info..
Incase if somebody is looking solution..this might help you.

http://dsxchange.com/viewtopic.php?t=13 ... a1d2cf1cd5

Posted: Thu Nov 11, 2010 8:39 am
by chulett
Not all answers come from Ray, although it seems like it some days. :wink:

Posted: Thu Nov 11, 2010 9:59 am
by daignault
Well I am trying. Ohhhh.... the OTHER Ray :)

Well, since Ray W is slightly older than me I guess he get's to use the name without extensions :)