Re: Job Scheduling

[Andrew Barnett <abarnett@ISD.HIH.COM.AU>]

>SQR Users,
>
>We need to submit print jobs at a specified time. We are working on an
>ORACLE v7 database on a HP Unix machine.
>
>Can SQR do this for us? If so, how?
>If NOT, do you know how we can do it otherwise. Do you use some tool
>Equally important is the management of this process.
>
>Thanx
>Kishore Bharat
>[Systems Analyst - ISCOR Profile Products]
>----------------------------------------------------------------------
>Things that go away by themselves, often come back by themselves...
>

If you're keen you can write your own scheduler using the DBMS_JOB package in Oracle 7. You'll
need a daemon written in Pro*C or SQR which you can feed job requests to by using DBMS_ALERT
and/or DBMS_PIPE.

Such a system would also allow you to schedule server-side reporting from client-side
applications.

One day I'll write it myself...

--------------------------------------------------------
 Andrew Barnett                 abarnett@isd.hih.com.au
 - Wizzard
--------------------------------------------------------