RE: HOURLY BASES

From: Chandini Paterson <chandini.paterson_at_morse.com>
Date: Wed, 10 Jan 2001 10:35:08 -0000
Message-Id: <10737.126245@fatcity.com>

Hi Mohan,

   You haven't specified which procedure/function you want to use in the Dbms_jobs package. From your mail I assume it is the Submit procedure to submit new jobs to the job queue.

   From the documentation

To submit a new job to the job queue, use the SUBMIT procedure in the DBMS_JOB package:

DBMS_JOB.SUBMIT(	job		OUT	BINARY_INTEGER,
	what		IN	VARCHAR2,
	next_date	IN	DATE DEFAULT SYSDATE,
	interval	IN	VARCHAR2 DEFAULT 'null',
	no_parse	IN	BOOLEAN DEFAULT FALSE)

The SUBMIT procedure returns the number of the job you submitted. Table 7 - 3 describes the procedure's parameters.

where
job This is the identifier assigned to the job you created. You must use the job number whenever you want to alter or remove the job.

what This is the PL/SQL code you want to have executed.

next_date This is the next date when the job will be run. The default value is SYSDATE.

interval This is the date function that calculates the next time to execute the job. The default value is NULL. INTERVAL must evaluate to a future point in time or NULL.

no_parse This is a flag. The default value is FALSE. If NO_PARSE is set to FALSE (the default), Oracle7 parses the procedure associated with the job. If NO_PARSE is set to TRUE, Oracle7 parses the procedure associated with the job the first time that the job is executed. If, for example, you want to submit a job before you have created the tables associated with the job, set NO_PARSE to TRUE.

HTH,
Chandini

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Viswalingam Mohan
Sent: 10 January 2001 09:50
To: Multiple recipients of list ORACLE-L Subject: HOURLY BASES

Hi all

i have a function which has to be executed on an hourly basis in oracle 7.2.3

what is the larst 2 arguments in the DBMS_JOBS

MOHAN
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Viswalingam Mohan
  INET: Viswalingam_Mohan_at_ril.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Wed Jan 10 2001 - 04:35:08 CST