Have you checked number
of queues lately?
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
Re-submit the jobthat should work
It has a long theory!!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
11:00 PM
To: Multiple recipients of list
ORACLE-L
Subject: dbms_job issue.
Hello
You said for the last 3 days,
so what do you do to get it running again?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
12:30 PM
To: Multiple
Already tried to resubmit it twice, everytime its breaking around mid
night.
-Original Message-From: Venu Gopal
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003
10:40 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: dbms_job issue.
Re-submit
it to 'really high' number. I
don't remember the bug# right now ...
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18,
2003 2:00 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: dbms_job issue.
Already tried to resubmit
Resubmit it and it runs fine until mid night. So I really dont have any
stats for this week.
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003
10:45 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: dbms_job issue
[EMAIL PROTECTED] wrote:
Hello List, I am running into weird dbms_job issue. I have a dbms_job
to collect perfstat every 1 hour , job was running fine for last 8-9
months without any issue. For last 3 days job is stopping every night
around 2 AM. I am not seeing any trace file, any logs in
It would seem that dbms_system has become undocumented.
It used to be partially documented, e.g. there was a
description of set_sql_trace_in_session, but they seem
to have pulled that as of 8.1. You're supposed to use
dbms_support now, but that too seems to be undocumented.
At least on Solaris,
Hi
The package dbms_system is now private, the body and header are both
created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file
$ORACLE_HOME/rdbms/admin/dbmsutil.sql has the following in it now:
Rem dbms_system - database system level commands
Title: RE: dbms_job
www.orafaq.com/papers/dbms_sys.doc
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion
Thanks pete
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 26, 2003 02:44
Hi
The package dbms_system is now private, the body and header are both
created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file
Thanks chris.
Let me know if you find out anything more.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 23:39
It would seem that dbms_system has become undocumented.
It used to be partially documented, e.g. there was a
Title: 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
Title: RE: DBMS_JOB scheduling
Raj,
You must be speaking from UNIX
heights -J
Under Windows I find dbms_job much more
reliable than windows at scheduling.
Actually, never had problems with dbms_job
forgetting to run a job.
Igor Neyman, OCP DBA
[EMAIL PROTECTED
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
Title: RE: DBMS_JOB scheduling
Igor,
you are right ... as a unwritten policy we don't allow windows databases
... even for crash test dummies ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views
Title: RE: DBMS_JOB scheduling
nope ... at-least not yet.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
It will submit the job and continue. Even nicer is
that if you subsequently do a rollback later, then the
job will be roll'd back as well. In this way, you
could put dbms_job into (say) a trigger and if the
statement later roll's back you don't end up with a
mess
hth
connor
--- Basavaraja,
: Wednesday, February 19, 2003 8:25 PM
To: [EMAIL PROTECTED]; CHAN Chor Ling Catherine (CSC)
Subject:RE: DBMS_JOB : Can submit but does not execute
Make sure job_queue_processes 0. Also check job_queue_interval.
Jay Hostetter
Title: RE: DBMS_JOB : Can submit but does not execute
In 8i I have had bad luck of submitting it at sysdate and they don't fire ...
Once I got burned, I can afford 5 seconds ... if it is that critical, dbms_job isn't the tool for that job anymore.
Raj
Title: RE: DBMS_JOB : Can submit but does not execute
Maybe
this is stating the obvious, but make sure you do a COMMIT after submitting the
job. - Dave
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20,
2003 6:59 AMTo: Multiple
You have to give commit after submit the job.
-Original Message-
Ling Catherine (CSC)
Sent: Tuesday, February 18, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I have submitted a job but it does not execute. Why? Does the owner
require any privileges ? However, I can
Have you set the job_queue_processes parameter in you init.ora file?
CHAN Chor Ling Catherine (CSC) wrote:
Hi Gurus,
I have submitted a job but it does not execute. Why? Does the owner require any privileges ? However, I can use DBMS_JOB.CHANGE command to execute immediately. I would like the
You have to run the job after you submit it.
SQL exec dbms_job.run(24);
Also make sure all init.ora parameters are set eg (job_queue_interval ,
job_queue_processes )
HTH,
Rajesh
-Original Message-
Ling Catherine (CSC)
Sent: Tuesday, February 18, 2003 8:14 PM
To: Multiple recipients of
Make sure job_queue_processes 0. Also check job_queue_interval.
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
[EMAIL PROTECTED] 02/18/03 08:28PM
Hi Gurus,
I use the following command to execute immediately.
Connected.
SQL BEGIN
2 DBMS_JOB.RUN(1);
3 END;
4 /
Title: RE: DBMS_JOB : Can submit but does not execute
Also as a practice, I always submit sysdate + 5 seconds instead of sysdate.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD
That shouldn't matter. Look at DBA_JOBS when you startup an instance after
it's been down for a while (not that it would ever happen!). All pending
jobs (nextdate = SYSDATE) should be firing, at least as many
job_queue_processes as you have in the init.ora.
Rich
Rich Jesse
The PL/SQL packages that we have running as jobs resubmit themselves when the job is
complete. So we can just add logic before calling DBMS_JOB.SUBMIT. Can your PL/SQL
be modified in this way?
Jay
[EMAIL PROTECTED] 02/18/03 09:14AM
Hi All,
Does anybody know a way of to get DBMS_JOB to run
use a function:
check if 15 minutes after current time is in the don't run interval
if it is return the first time after the interval
if not return 15 minutes later
Pat
Hi All,
Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes,
unless
DOH!
You know, I knew that I had read about this somewhere, but couldn't for the
life of me remember where. You mentioning Tom kick started my aching brain!
;)
The asktom site is down at the moment whilst being upgraded, but I still
have the copy of Oracle magazine where Tom discussed this! For
Mark,
You may want to check http://asktom.oracle.com.
I think there are a few examples that you will find come close to what you are
looking for.
- Kirti
-Original Message-
Sent: Tuesday, February 18, 2003 8:14 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Does anybody
Just found an online version (in the spirit of sharing solutions ;D):
http://otn.oracle.com/oramag/oracle/03-jan/o13asktom.html
---snip---
Setting a Complex Interval
I am using DBMS_JOB, and I want to schedule a job that runs every 15 minutes
from Monday to Friday, between 6 a.m. and 6 p.m.
Hi Gurus,
I use the following command to execute immediately.
Connected.
SQL BEGIN
2 DBMS_JOB.RUN(1);
3 END;
4 /
PL/SQL procedure successfully completed.
--
-- I change the time for next execution to check whether it can submit on 18 Feb 2003
at 8am
--
1 begin
2 DBMS_JOB.CHANGE(1,
How about
dbms_job.submit(:jobno, 'statspack.snap',
sysdate+n/1440, 'sysdate
15/1440');
where n= a number of minutes to the nearest 15
minutes. So if it's 14:25
then it would
be sysdate+5/1440.
since you only need to do this one time, just make
sure that sysdate + n =
0, 15, 30 or 45
after the
Personally, I tend to just submit four jobs: one at the top of hour, one at
15 past, one at 30 past, and the fourth at 45 past. To alter the frequency,
just break or remove one or more of the jobs. Falls into the category of
not elegant, but it works...
- Original Message -
To:
Title: RE: dbms_job - running jobs every 15 minutes
I simplified it by using cron instead ... g
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect
That's exactly what I do. Phew! I thought I was the only one ;)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 8:03 AM
Personally, I tend to just submit four jobs: one at the top of hour, one
at
15 past, one at 30
Title: RE: dbms_job - running jobs every 15 minutes
Cron?
How 1980's :-))
RF
Robert G. FreemanTechnical Management
ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's
everywhere that I am!)Author of several books you can find on
Amazon.com!
-Original
Title: RE: dbms_job - running jobs every 15 minutes
Robert,
I have solid reasons not to trust dbms_job ... it didn't work reliably in
901x. Call me retro ... but "cron" rocks ...
8:)
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Ra
Title: RE: dbms_job - running jobs every 15 minutes
Cron? How RELIABLE !!
-Original Message-From: Freeman Robert - IL
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 22, 2003 10:10
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
dbms_job - running jobs every 15
Title: RE: dbms_job - running jobs every 15 minutes
LOL.
Ok, I
confess, my name's Robert and I'm a CRON user
Rf
Robert G. FreemanTechnical Management
ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's
everywhere that I am!)Author of several books you can find
One thing I've learned Arup, there are 15,000 ways of doing the same thing,
and a good many of those are as good as the other. Cron, dbms_job, at,
whatever works for you!!
Rf
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's
Title: RE: dbms_job - running jobs every 15 minutes
LOL. You are right about the job_scheduler in early
9i.
Had
all sorts of problems when I first started moving stuff to
9.0.1
and 9.0.2 and Oracle was no help figuring out what the
problem was.
I use
cron all the time, but I love
[EMAIL PROTECTED] wrote:
One potential problem with DBMS_JOBS as is being discussed here is that Oracle
computes the next_date at the end of the job. They do that so that if a job
-- INTERVAL is a date function, evaluated immediately before the job starts
-- executing...
runs longer than
Yea... I realized that after I sent the email, so I submitted my second
suggestion...
Thanks though for your thoughts!!
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on
]
Sent by: [EMAIL PROTECTED]
01/22/2003 06:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: dbms_job - running jobs every 15 minutes
That's exactly what I do. Phew! I thought I was the only one
:RE: dbms_job - running jobs every 15 minutes
How about this... this will start the job at the top of the following hour
and then schedule it every 15 minutes...
dbms_job.submit(:jobno,
'statspack.snap;',to_date(to_char(sysdate+60/1440,'mm/dd/ hh24'),
'mm/dd/ hh24') ,'to_date(to_char
]
cc:
Subject:RE: RE: dbms_job - running jobs every 15 minutes
Yea... I realized that after I sent the email, so I submitted my second
suggestion...
Thanks though for your thoughts!!
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
[EMAIL PROTECTED]
cc:
Subject:RE: dbms_job - running jobs every 15 minutes
How about this... this will start the job at the top of the following hour
and then schedule it every 15 minutes...
dbms_job.submit(:jobno,
'statspack.snap;',to_date(to_char(sysdate+60/1440,'mm/dd
[EMAIL PROTECTED] wrote:
Now as discussed, if the job is scheduled to start at 9:00 AM and
runbs for 5 minutes it's next_date for run #2 will be 9:20, not 9:15,
and it
will creep 5 minutes every time.
No, as written, my jobs start on every quarter hour, regardless of
runtime.
e.g. 09:00,
As an aside, if you want something to run twice a day at the same time (in
my case 11:50 AM/PM), this seems to work well for an interval:
trunc(sysdate) + (decode(to_char(sysdate,'AM'),'AM',1,2)*12+(11+(50/60)))/24
Enjoy! :)
Rich
Rich Jesse System/Database
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_job - running jobs every 15 minutes
Thanks Robert, I like this.
Simplified and still easy to read.
Jared
Robert
If a job takes longer than the next scheduled time to execute then I see a
problem. Suppose a job runs every 15 mins but runtime is 30 mins, the
number ofjobs will increase andcompete for the same resources.
I always use cron (80's kinda of control), and the 1st thing I do is check if
the
: Wednesday, January 22, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_job - running jobs every 15 minutes
Thanks Robert, I like this.
Simplified and still easy to read.
Jared
Robert Freeman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21
1980's??? Yes, but it works, ain't broke, reliable, KISS, and is easy
to implement.
I use cron from my Linux box to connect to the production Oracle
database (OpenVMS) and do a RMAN backup with the catalog on a second
Oracle database (OpenVMS) server. Beats the heck out of trying to get
the
Stephane Faroult wrote:
Vladimir (whose formula I am still trying to understand :-))...
TRUNC(SYSDATE) + (CEIL(TO_CHAR(SYSDATE, 'S') / 60 / :interval) / (24
* 60 / :interval));
P.S.: could you please answer my question ('100% CPU utilization,
urgent') thread?
--
Vladimir Begun
The
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: dbms_job - running jobs every 15 minutes
[EMAIL PROTECTED] wrote:
Now as discussed, if the job is scheduled to start at 9:00 AM and
runbs for 5 minutes it's next_date for run #2 will be 9
Jared
in general it's much more better to use bind variables, here
I do not use them, shame on me! :)
Hope the code below is ok for you at least it does not look
so complicated.
VARIABLE jobno NUMBER;
VARIABLE plsql VARCHAR2(1000);
EXEC :plsql := 'BEGIN statspack.snap; END;';
BEGIN
How about
dbms_job.submit(:jobno, 'statspack.snap', sysdate+n/1440, 'sysdate
15/1440');
where n= a number of minutes to the nearest 15 minutes. So if it's 14:25
then it would
be sysdate+5/1440.
since you only need to do this one time, just make sure that sysdate + n =
0, 15, 30 or 45
after the
How about this... this will start the job at the top of the following hour
and then schedule it every 15 minutes...
dbms_job.submit(:jobno,
'statspack.snap;',to_date(to_char(sysdate+60/1440,'mm/dd/ hh24'),
'mm/dd/ hh24') ,'to_date(to_char(sysdate+60/1440,''mm/dd/ hh24''),
''mm/dd/
Barbara Baker wrote:
Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1
List:
I want to change the perfstat statspack.snap procedure
FROM running every hour on-the-hour
TO running at 10 minutes till the hour.
(On-the-hour is conflicting with another procedure.)
I tried to Read The
Stephane:
Precisely what I was after!
Thanks so much for your help. I really appreciate it.
Barb
--- Stephane Faroult [EMAIL PROTECTED] wrote:
Barbara Baker wrote:
Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1
List:
I want to change the perfstat statspack.snap
procedure
FROM
Does this work for you:
select trunc(sysdate + 1/24,'hh') + 50/(60 * 24)from dual;
Your next will be: 'trunc(sysdate + 1/24,'hh') + 50/(60 * 24)'
Regards,
Waleed
-Original Message-
Sent: Friday, January 10, 2003 9:09 PM
To: Multiple recipients of list ORACLE-L
Stephane:
Bill,
Try putting a ';' after snap that may fix it.
SQL variable x number;
SQL begin
2 dbms_job.submit(:x,'statspack.snap;',sysdate,'sysdate + 1/24');
3 end;
4 /
I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on
Metalink, I've try to run the following:
SQL
/Tech International, Sussex, WI USA
-Original Message-
From: kkennedy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBMS_JOB interval wierdness
When the job aborts, it increments the failures column (until
Nope. 1 PM just like it should, only every day instead of every week. I've
tried it with the 7 in and out of the TRUNC with the same results.
One other thing I just noticed is that the job returns an error each time it
is run due to bug in DBMS_STATS. I'm rectifying that now with trapping and
When the job aborts, it increments the failures column (until it hits the broken point
at 16 failures) and resubmits itself with an internally calculated restart time.
From the Oracle Administrators Guide:
If a job returns an error while Oracle is attempting to execute it, Oracle tries to
Goulet
Reply Separator
Subject:RE: DBMS_JOB interval wierdness
Author: Jesse; Rich [EMAIL PROTECTED]
Date: 7/16/2002 12:24 PM
Nope. 1 PM just like it should, only every day instead of
every week. I've
tried it with the 7 in and out
Hi
I had same situation before. Check owner of the job and security and add
necessary privilege.
Mitchell
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 10:33 AM
Dear gurus !
I submit a job via the DBMS_JOB package , it
Have you set job_queue_processes and job_queue_interval parameters? If
job_queue_processes is zero, the job will always run manually but never
automatic.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
Andrey,
Are you issuing a commit after your dbms_job.submit?
jack
--- Andrey Bronfin [EMAIL PROTECTED] wrote:
Dear gurus !
I submit a job via the DBMS_JOB package , it looks
OK , select from
user_jobs shows that broken='N' .
When i execute the job manually , using dbms_job.run
, it runs
Check if you have a non-zero value for JOB_QUEUE_PROCESSES?
HTH
CP
[EMAIL PROTECTED] wrote:
Dear gurus !
I submit a job via the DBMS_JOB package , it looks OK , select from
user_jobs shows that broken='N' .
When i execute the job manually , using dbms_job.run , it runs , but it does
not run
No , it was not ;-)
Sorry , i knew it , but overlooked it ;-)
It's working now !
Thanks a lot to all who replied !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Sun, July 14, 2002 5:51 PM
To: Andrey Bronfin; LazyDBA.com Discussion
Is
Hi all,
I have used the dbms_job package in some cases.
Normally I use the INTERVAL
method of the packages. i.e. 30 sec.
But
soemtimes it occurs, that users change their system
time to the future to
test something,
then changing back to the correct time.
The INTERVAL job then stops, as
Did you set JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL in your
initsid.ora parameter file?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 12:13 PM
Hi,
We have a job own by user
If the parameters suggested are already set up right , I have one more thing
to ask...
1. is this something do with the DB Link ???
2. if so , the user running the job is having any private DBLINK ???
--Madhu
PS: If the DB LINK is used to run this job , you need to have a private
dblink
Are there any jobs running? There's a couple of init.ora parameters that must be set
first.
Jim
-Original Message-
Sent: Friday, April 19, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
If the parameters suggested are already set up right , I have one more thing
to ask...
1.
Did you commit after submitting the job or the session is still open?
Waleed
-Original Message-
Sent: Friday, April 19, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
Hi,
We have a job own by user MTSSYS which we scheduled to run every 1 minute
but it is not running itself.
So this means that every day at 6 pm th eprocedure 'procedure' runs.
/Roland
Thomas, Kevin [EMAIL PROTECTED]@fatcity.com den 2001-09-11 03:30 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Hi Roland,
Yes, that's correct.
Kev.
-Original Message-
Sent: 12 September 2001 09:45
To: Multiple recipients of list ORACLE-L
So this means that every day at 6 pm th eprocedure 'procedure' runs.
/Roland
Thomas, Kevin [EMAIL PROTECTED]@fatcity.com den 2001-09-11 03:30
PST
Sänd svar till
Hi Roland,
declare
l_job number;
begin
dbms_job.submit( l_job, 'procedure;',
trunc(sysdate)+18/24, 'trunc(sysdate)+18/24' );
end;
This runs at exactly 6pm every day (18 hours into the day, replace procedure
with the name of the stored procedure that you want to run.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hi,
You need to find the job number, then use DBMS_JOB.REMOVE(). This is all
in the documentation:
http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/jobq.htm#10
57
Note that the job will complete before being removed from the queue.
g
-Original Message-
Sent: Tuesday,
Rangachari Sundar wrote:
Hi All,
Can Anyone tell me how to stop a background job initiated through a
DBMS_JOB package when it is no longer required?
Thanks in advance.
Regards
Sundar
--
desc dbms_job
I believe that this will have some effect:
exec
Hola,
You can use dbms_job.remove(jobnumber)
Suerte !!
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
809-565-3121
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Rangachari
Sundar
Enviado el: Tuesday, 28 August, 2001 1:21 AM
Para:
Roland:
This anonymous PL/SQL block submits a job that will insert a row into
mytable:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'insert into mytable values (''One'',''Two'',''Three'');'
'SYSDATE, 'SYSDATE + 1');
commit;
END;
/
The SYSDATE parameter says, Run this
See http://www.jlcomp.demon.co.uk/faq/dbms_job.html
hth
connor
--- [EMAIL PROTECTED] wrote: Hallo,
How can I schedule a pl/sql job, I want this to
happen:
Every Sunday at 11 pm I want to do an insert into a
table.
How shoudl I write the code in the DBMS_JOB
satement.?
Roland S
,
Shailesh To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED] cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
ate.ny.us Subject: RE: DBMS_JOB
,
Shailesh To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED] cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
ate.ny.us Subject: RE: DBMS_JOB
Sent
Mitchell,
What did you specify for next_date? Try to set it to something like a
second after you setup the job.. It should work and you should not have to
execute a new job...
I think JOB_QUEUE_PROCESSES is the maximum number of jobs that can run in
parallel and JOB_QUEUE_INTERVAL is the
If order to stop those funny date , can you show me the code of your pl/sql
and let us try to solve it ? Becoz it seen you try to add in those error
date into your next_date ?
You might need to create a lookup table to key in those require date,and let
it parse to the procedure automatical..
Ramon,
When a job is broken the next_date is set to
01/01/4000.
I'm not sure I understand exactly what your initial
request was, but you can alter the next_date and
interval for any job using DBMS_JOB.CHANGE (or by
calling DBMS_JOB.NEXT_DATE and DBMS_JOB.INTERVAL
individually).
For examples of
July, 2001 3:50 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: DBMS_JOB
Ramon,
When a job is broken the next_date is set to
01/01/4000.
I'm not sure I understand exactly what your initial
request was, but you can alter the next_date and
interval for any job using DBMS_JOB.CHANGE
PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ramon Estevez
Enviado el: Monday, 02 July, 2001 9:01 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: DBMS_JOB
Thanks to all that reply,
I want to clean the queue, erase to the jobs, and reschedule them again
Ramon Estevez
*809-565
Query user_jobs view. It will give you the procedure name, last date time
when it was executed and the next date time when it will get executed
next.
Prakash
-Original Message-
Sent: Friday, June 29, 2001 5:02 PM
To: Multiple recipients of list ORACLE-L
Hi List,
How do I know
Thanks Ray and Dick,
This the output, obviously some mistakes(*), how do I stop them from
executing, (take them out)
LAST_DATE NEXT_DATE
-- --
carga_d 29/06/2001 30/06/2001
mueve_h_f 20/02/2001 01/01/4000*
carga_d
Here's a script I use to view jobs:
set linesize 132
select to_char(job,'FM990') job,
substr(schema_user,1,6) owner,
substr(what,1,20) procedure,
to_char(last_date,'MM/DD/YY HH24:MI') LAST RUN,
decode(this_date,null,
' '||to_char(next_date,'MM/DD/YY HH24:MI'),
'*'||to_char(this_date,'MM/DD/YY
we had these situations for this we had to break the job first and then
kill the snp process after some time u will see the sid out of v$session.
Even if you kill the snp it will be kicked back later on from pid or spid i
think i am not sure but it works
Try this out it should work
Well there
1 - 100 of 105 matches
Mail list logo