[NTLUG:Discuss] OT: crontab arguments question

[Fred James]

Stuart Johnston wrote:

>Why don't you put this in the oracle user's crontab?
>
>Or quote the -c arg:
>
>su - oracle -c '/apps/oracle/ppdb_scripts/SidTest/willi.sh ppdb'
>
>Fred James wrote:
>  
>
>>All
>>OT: crontab arguments question
>>I need to pass an argument to my program from the crontab entry
>>Problem: the first argument is taken by an environmental script
>>Question: how do I provide for this?
>>
>>Example:
>>55 13 * * * su - oracle -c /apps/oracle/ppdb_scripts/SidTest/willi.sh ppdb
>>    the su - oracle -c is required to set certain environmental variable 
>>or nothing works
>>    the ppdb is the SID the the su - oracle eats up on the way through, 
>>and I need to send another ppdb to my program
>>
>>something like ...
>>55 13 * * * su - oracle -c /apps/oracle/ppdb_scripts/SidTest/willi.sh 
>>ppdb ppdb
>>... except that doesn't work ...
>>
>>Thank you in advance for any help you may be able to offer
>>Regards
>>Fred James
>>
>>    
>>
Stuart Johnson
Perhaps there is something goofy going on, but this is in the Oracle 
crontab (SGI 6.4)
Regards
Fred James