> 1. have you tried select to_char(sysdate,'D') from dual ??
Yes, and it works fine on MY servers, but the docs say that the value
returned
depends on your NLS_TERRITORY setting. I am trying to get it to work for
everybody.
> This is really nice, but my only gripe with dbms-job is that is isn't
reliable ... it wasn't in 9ir1 on aix and we didn't even look at it in
9ir2. in 9ir1 dbms_job used to _forget_ to run jobs after some time and
the workaround was like setting job_processes to a very large number.
I am sorry to hear that. We are on 8.1.7 and have been using since 7.3
with no major problems.
>nevertheless, I think what you have attempted is fantastic and worthy of
adoption ...
Are you looking for money? :-)
Garry Gillies
Database Administrator
Business Systems
Weir Pumps Ltd
149 Newlands Road, Cathcart, Glasgow, G44 4EX
T: +44 0141 308 3982
F: +44 0141 633 1147
E: [EMAIL PROTECTED]
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
23/07/03 15:24
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: DBMS_JOB scheduling
Garry,
1. have you tried select to_char(sysdate,'D') from dual ??
This is really nice, but my only gripe with dbms-job is that is isn't
reliable ... it wasn't in 9ir1 on aix and we didn't even look at it in
9ir2. in 9ir1 dbms_job used to _forget_ to run jobs after some time and
the workaround was like setting job_processes to a very large number.
nevertheless, I think what you have attempted is fantastic and worthy of
adoption ...
CONFIDENTIAL:
The information contained in this email (including any attachments)
is confidential, subject to copyright and for the use of the
intended recipient only. If you are not the intended recipient
please delete this message after notifying the sender. Unauthorised
retention, alteration or distribution of this email is forbidden
and may be actionable.
Attachments are opened at your own risk and you are advised to scan
incoming email for viruses before opening any attached files. We
give no guarantee that any communication is virus-free and accept
no responsibility for virus contamination or other system loss or
damage of any kind.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Garry Gillies
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
