Passing a value from oracle table as a parameter

mac4rfree85 · Post by **mac4rfree85** » Thu Nov 11, 2010 6:43 am

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

chulett · Post by **chulett** » Thu Nov 11, 2010 6:44 am

Search here for USERSTATUS.

mac4rfree85 · Post by **mac4rfree85** » Thu Nov 11, 2010 7:02 am

thanks Ray for that info..
Incase if somebody is looking solution..this might help you.

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

chulett · Post by **chulett** » Thu Nov 11, 2010 8:39 am

Not all answers come from Ray, although it seems like it some days.

Post by **daignault** » Thu Nov 11, 2010 9:59 am

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 :)