[rt-users] Cron Issues....

[Jeff Stark]

The only item in /var/log/cron is:

Jul 11 09:01:01 infrt01 crond[23295]: (root) CMD (run-parts
/etc/cron.hourly)

Is there somewhere else I should look?

Thanks,
-Stark



-----Original Message-----
From: Stephen Turner [mailto:sturner at MIT.EDU] 
Sent: Wednesday, July 11, 2007 12:22 PM
To: Jeff Stark; RT Users
Subject: Re: [rt-users] Cron Issues....

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