[NTLUG:Discuss] OT: crontab arguments question

[Stuart Johnston]

Fred James wrote:
> 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?

man 5 crontab

>        An  active line in a crontab will be either an environ-
>        ment setting or a cron command.  An environment setting
>        is of the form,
> 
>            name = value
> 
>        where   the   spaces  around  the  equal-sign  (=)  are
>        optional, and  any  subsequent  non-leading  spaces  in
>        value  will be part of the value assigned to name.  The
>        value string may be placed in quotes (single or double,
>        but matching) to preserve leading or trailing blanks.