Question

[Jay R. Ashworth]

On Fri, Jan 14, 2005 at 02:43:52PM -0500, Courtney wrote:
> One of the reps here wants a report every other Friday...I was thinking of
> getting week number and dividing by two, if there is a remainder, than dont
> select...any other ways?  BTW...we run on UNIX so it would be a cron job...

This depends on which cron you're running, is it SCO?

There's no great answer to this.  You *need* to use Week of Year,
because if you use Week of Month, you'll either skip a week or get two
in a row, depending on which werek numbers you choose, and which months
have 5 weeks in them.  

But cron's dont tend to *have* "Week of Year", that I've seen.  You
might just use at to schedule a script that runs the job then reskeds
itself for +14 days.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system adminstrator.  Or two.  --me