passing sysdate from sqlplus into dsjob -run paramtere
Posted: Wed Mar 24, 2004 10:19 pm
Hi,
I want to pass the sysdate value that is generated by sql plus session
into my dsjob run command. I tried the below, but it is giving an error. Can some one let me know how to pass this variable from unix to dsjob -run [param] command.
sys=`$ORACLE_BIN/sqlplus -s user/pwd@project << eof
set heading off
select sysdate from dual;
exit;
end
eof`
export man=$sys
echo $man
$DSJOB/dsjob -run -param name=$man Proj1 jobp
thanks
I want to pass the sysdate value that is generated by sql plus session
into my dsjob run command. I tried the below, but it is giving an error. Can some one let me know how to pass this variable from unix to dsjob -run [param] command.
sys=`$ORACLE_BIN/sqlplus -s user/pwd@project << eof
set heading off
select sysdate from dual;
exit;
end
eof`
export man=$sys
echo $man
$DSJOB/dsjob -run -param name=$man Proj1 jobp
thanks