Re: DBMS_JOB
From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 23 Jul 1999 14:42:03 GMT
Message-ID: <37a67ee9.100717524_at_newshost.us.oracle.com>
Date: Fri, 23 Jul 1999 14:42:03 GMT
Message-ID: <37a67ee9.100717524_at_newshost.us.oracle.com>
A copy of this was sent to ssmith3542_at_my-deja.com (if that email address didn't require changing) On Thu, 22 Jul 1999 20:00:02 GMT, you wrote:
>From a database perspective what does the DBA need to do in order for
>the DBMS_JOB utility to work?
>
set up the requisite init.ora parameters.
NAME TYPE VALUE ----------------------------------- ------- ------------------------------ job_queue_interval integer 60 job_queue_processes integer 3
monitor the alert.log file for jobs that are failing -- notify owner of jobs (in case owner of jobs is not watching the failures/broken columns in the user_jobs table).
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
-- See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle CorporationReceived on Fri Jul 23 1999 - 16:42:03 CEST