[rt-users] Cron Issues....

[Stephen Turner]

At Wednesday 7/11/2007 12:06 PM, Jeff Stark wrote:
>Hello everyone...
>
>RT 3.6.3, RHEL, Oracle DB.
>
>I have a cron job I created in cron.hourly...its pretty simplistic 
>and the command works great when I run it directly.  Being very new 
>to Linux,  I was hoping one of you may notice something simple that 
>I am missing here.
>
>
>#!/bin/sh
>
>/opt/rt3/bin/rt-crontool --search RT::Search::FromSQL  --search-arg 
>"(  Status = 'new' OR Status = 'open' OR Status = 'stalled' ) 
>AND  (  'CF.{Severity Level}' LIKE 'Sev 2  (Premier Support ONLY)' ) 
>AND  (  'CF.{Customer}' NOT LIKE '%(p)' AND 'CF.{Customer}' NOT LIKE 
>'%(ep)' )"   --action RT::Action::DemotePremierLevel
>
>
>Thanks,
>
>-Stark


Do you have any output from a cron run of this? It could be that the 
cron invocation is not getting the Oracle environment variables it needs.

Steve