[NTLUG:Discuss] OT: crontab arguments question

[Stuart Johnston]

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.