[rt-users] Cron Issues....
Stephen Turner
sturner at MIT.EDU
Wed Jul 11 12:22:28 EDT 2007
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
More information about the rt-users
mailing list