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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
