[NTLUG:Discuss] OT: crontab arguments question

[Fred James]

Stuart Johnston wrote:

>Fred James wrote:
>  
>
>>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)
>>    
>>
>
>Add the environment variables that you need into the top of your crontab.
>  
>
Stuart Johnston
I am not familiar with that - could you point me to documentation, please?
Regards
Fred James