Re: Fixed_date and dbms_job

2003-03-14 Thread Darrell Landrum
Thanks!!

Darrell Landrum
Database Administrator
Zale Corporation

>>> [EMAIL PROTECTED] 03/14/03 12:44PM >>>
It takes 16 failures to mark the job as "broken".

Igor Neyman, OCP DBA
[EMAIL PROTECTED] 



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:24 AM


> Ben,
>
> If this problem has not been fixed, check something else.
> Run:
> select job, what, broken, failures from dba_jobs;
>
> I don't know how many, but after a certain number of failures, a job is
marked as broken and won't run automatically.
>
>
> Darrell
>
>
>
> >>> [EMAIL PROTECTED] 03/14/03 08:38AM >>>
> Thanks Jacques,
>  Yes I did:
>
> VARIABLE jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno,
> 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
> true);
> commit;
> end;
> /
>
> Ben
>
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> > After calling dbms_job.submit, did you issue a
> > commit?
> >
> > > -Original Message-
> > > From: Kader Ben [mailto:[EMAIL PROTECTED] 
> > >
> > >  I'm simulating the date in future with
> > fixed_date.
> > > I wrote procedure to be called every seconde
> > through
> > > dbms_job to increment the fixed_date.
> > >
> > > I did that dbms_job.submit(:job_num,
> > 'myprocedure;',
> > > sysdate, 'sysdate');
> > >
> > > the  dba_jobs table show me the right interval un
> > > next_date:
> > >
> > >
> > > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> > INTERVAL
> > > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> > sysdate
> > >
> > > And the sysdate is:
> > > 13-JUN-2003 17:50:06
> > >
> > > But the job never execute.
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author: Kader Ben
>   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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> --
> Author: Darrell Landrum
>   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).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Igor Neyman
  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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  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).



Re: Fixed_date and dbms_job

2003-03-14 Thread Igor Neyman
It takes 16 failures to mark the job as "broken".

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:24 AM


> Ben,
>
> If this problem has not been fixed, check something else.
> Run:
> select job, what, broken, failures from dba_jobs;
>
> I don't know how many, but after a certain number of failures, a job is
marked as broken and won't run automatically.
>
>
> Darrell
>
>
>
> >>> [EMAIL PROTECTED] 03/14/03 08:38AM >>>
> Thanks Jacques,
>  Yes I did:
>
> VARIABLE jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno,
> 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
> true);
> commit;
> end;
> /
>
> Ben
>
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> > After calling dbms_job.submit, did you issue a
> > commit?
> >
> > > -Original Message-
> > > From: Kader Ben [mailto:[EMAIL PROTECTED]
> > >
> > >  I'm simulating the date in future with
> > fixed_date.
> > > I wrote procedure to be called every seconde
> > through
> > > dbms_job to increment the fixed_date.
> > >
> > > I did that dbms_job.submit(:job_num,
> > 'myprocedure;',
> > > sysdate, 'sysdate');
> > >
> > > the  dba_jobs table show me the right interval un
> > > next_date:
> > >
> > >
> > > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> > INTERVAL
> > > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> > sysdate
> > >
> > > And the sysdate is:
> > > 13-JUN-2003 17:50:06
> > >
> > > But the job never execute.
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kader Ben
>   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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Darrell Landrum
>   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).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  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).



Re: Fixed_date and dbms_job

2003-03-14 Thread Kader Ben
Many thanks Jared,

 Definitely I think this is only one away to resolve
my problem.

Have nice week end,

Ben


--- [EMAIL PROTECTED] wrote:
> You can't call a job every second via DBMS_JOB.
> 
> I believe that at best the resolution is 1 minute.
> 
> You could just open another session and run
> something like this:
> 
> declare
>fd varchar2(50) := '01/01/2010 00:00:00';
>v_sql varchar2(200);
> begin
>loop
>   v_sql := 'alter system set fixed_date = "' ||
> fd || '"';
>   execute immediate v_sql;
>   dbms_lock.sleep(1);
>   fd := to_char(to_date(fd,'mm/dd/
> hh24:mi:ss') + 1/86400, 
> 'mm/dd/ hh24:mi:ss');
>   end loop;
> end;
> /
> 
> Jared
> 
> 
> 
> 
> 
> 
> Kader Ben <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  03/13/2003 03:18 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Fixed_date and dbms_job
> 
> 
> Hi Listers,
> 
>  I'm simulating the date in future with fixed_date.
> I wrote procedure to be called every seconde through
> dbms_job to increment the fixed_date.
> 
> I did that dbms_job.submit(:job_num, 'myprocedure;',
> sysdate, 'sysdate');
> 
> the  dba_jobs table show me the right interval un
> next_date:
> 
>  
> BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> INTERVAL
> N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate
> 
> And the sysdate is:
> 13-JUN-2003 17:50:06
> 
> But the job never execute.
> 
> Could you please give me hint how to resolve this
> problem?
> 
> Thanks you,
> 
> Ben
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Kader Ben
>   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).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: 
>   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).
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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).



Re: Fixed_date and dbms_job

2003-03-14 Thread Jared . Still
You can't call a job every second via DBMS_JOB.

I believe that at best the resolution is 1 minute.

You could just open another session and run
something like this:

declare
   fd varchar2(50) := '01/01/2010 00:00:00';
   v_sql varchar2(200);
begin
   loop
  v_sql := 'alter system set fixed_date = "' || fd || '"';
  execute immediate v_sql;
  dbms_lock.sleep(1);
  fd := to_char(to_date(fd,'mm/dd/ hh24:mi:ss') + 1/86400, 
'mm/dd/ hh24:mi:ss');
  end loop;
end;
/

Jared






Kader Ben <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/13/2003 03:18 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Fixed_date and dbms_job


Hi Listers,

 I'm simulating the date in future with fixed_date.
I wrote procedure to be called every seconde through
dbms_job to increment the fixed_date.

I did that dbms_job.submit(:job_num, 'myprocedure;',
sysdate, 'sysdate');

the  dba_jobs table show me the right interval un
next_date:

 
BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC INTERVAL
N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate

And the sysdate is:
13-JUN-2003 17:50:06

But the job never execute.

Could you please give me hint how to resolve this
problem?

Thanks you,

Ben


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).



RE: Fixed_date and dbms_job

2003-03-14 Thread Darrell Landrum
Ben, 

If this problem has not been fixed, check something else.
Run:
select job, what, broken, failures from dba_jobs;

I don't know how many, but after a certain number of failures, a job is marked as 
broken and won't run automatically.


Darrell



>>> [EMAIL PROTECTED] 03/14/03 08:38AM >>>
Thanks Jacques,
 Yes I did:

VARIABLE jobno number; 
BEGIN 
DBMS_JOB.SUBMIT(:jobno,
'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
true); 
commit; 
end; 
/ 

Ben

--- Jacques Kilchoer <[EMAIL PROTECTED]>
wrote:
> After calling dbms_job.submit, did you issue a
> commit?
> 
> > -Original Message-
> > From: Kader Ben [mailto:[EMAIL PROTECTED] 
> > 
> >  I'm simulating the date in future with
> fixed_date.
> > I wrote procedure to be called every seconde
> through
> > dbms_job to increment the fixed_date.
> > 
> > I did that dbms_job.submit(:job_num,
> 'myprocedure;',
> > sysdate, 'sysdate');
> > 
> > the  dba_jobs table show me the right interval un
> > next_date:
> > 
> >  
> > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> INTERVAL
> > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> sysdate
> > 
> > And the sysdate is:
> > 13-JUN-2003 17:50:06
> > 
> > But the job never execute.
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Kader Ben
  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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  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).



RE: Fixed_date and dbms_job

2003-03-14 Thread Kader Ben
Thanks Jacques,
 Yes I did:

VARIABLE jobno number; 
BEGIN 
DBMS_JOB.SUBMIT(:jobno,
'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
true); 
commit; 
end; 
/ 

Ben

--- Jacques Kilchoer <[EMAIL PROTECTED]>
wrote:
> After calling dbms_job.submit, did you issue a
> commit?
> 
> > -Original Message-
> > From: Kader Ben [mailto:[EMAIL PROTECTED]
> > 
> >  I'm simulating the date in future with
> fixed_date.
> > I wrote procedure to be called every seconde
> through
> > dbms_job to increment the fixed_date.
> > 
> > I did that dbms_job.submit(:job_num,
> 'myprocedure;',
> > sysdate, 'sysdate');
> > 
> > the  dba_jobs table show me the right interval un
> > next_date:
> > 
> >  
> > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> INTERVAL
> > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> sysdate
> > 
> > And the sysdate is:
> > 13-JUN-2003 17:50:06
> > 
> > But the job never execute.
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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).



Re: Fixed_date and dbms_job

2003-03-14 Thread Kader Ben
Thnks Michal for your input,

All seems right for me:
SQL> show parameter job

NAME TYPEVALUE
 ---
--
job_queue_interval   integer 90
job_queue_processes  integer 2

Michal I cannot put next_date to 'sysdate+1/86400'
because this date will never be reached since I use
ALTER SYSTEM SET FIXED_DATE  = sysdate+deta

Where the delta is the incremental time to simulate
pseudo-time in the future. And the main objective of
the procedure to do.


Ben



--- Michal Zaschke <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> 1) check job_queue_processes and job_queue_interval
> parameters in your 
> init.ora file
> 2) have a commit after dbms_job.submit
> 3) if you want the procedure to be executed every
> second, then the next 
> date should be 'sysdate+1/86400' =>
> dbms_job.submit(:job_num, 'myprocedure;',sysdate,
> 'sysdate+1/86400');
> 
> Mike
> 
> Kader Ben wrote:
> > Hi Listers,
> > 
> >  I'm simulating the date in future with
> fixed_date.
> > I wrote procedure to be called every seconde
> through
> > dbms_job to increment the fixed_date.
> > 
> > I did that dbms_job.submit(:job_num,
> 'myprocedure;',
> > sysdate, 'sysdate');
> > 
> > the  dba_jobs table show me the right interval un
> > next_date:
> > 
> >  
> > BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC
> INTERVAL
> > N  13-JUN-03 00:00:00 13-JUN-03 17:50:06
> sysdate
> > 
> > And the sysdate is:
> > 13-JUN-2003 17:50:06
> > 
> > But the job never execute.
> > 
> > Could you please give me hint how to resolve this
> > problem?
> > 
> > Thanks you,
> > 
> > Ben
> > 
> > 
> > __
> > Do you Yahoo!?
> > Yahoo! Web Hosting - establish your business
> online
> > http://webhosting.yahoo.com
> 
> 
> -- 
>   Ing. Michal Zaschke
> DB Administrator
> Sokolovska uhelna, a.s.
> tel.: +420 352 465417
> e-mail: [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Michal Zaschke
>   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).
> 


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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).



Re: Fixed_date and dbms_job

2003-03-14 Thread Michal Zaschke
Hi,

1) check job_queue_processes and job_queue_interval parameters in your 
init.ora file
2) have a commit after dbms_job.submit
3) if you want the procedure to be executed every second, then the next 
date should be 'sysdate+1/86400' =>
dbms_job.submit(:job_num, 'myprocedure;',sysdate, 'sysdate+1/86400');

Mike

Kader Ben wrote:
Hi Listers,

 I'm simulating the date in future with fixed_date.
I wrote procedure to be called every seconde through
dbms_job to increment the fixed_date.
I did that dbms_job.submit(:job_num, 'myprocedure;',
sysdate, 'sysdate');
the  dba_jobs table show me the right interval un
next_date:
 
BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC INTERVAL
N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate

And the sysdate is:
13-JUN-2003 17:50:06
But the job never execute.

Could you please give me hint how to resolve this
problem?
Thanks you,

Ben

__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com


--
 Ing. Michal Zaschke
   DB Administrator
Sokolovska uhelna, a.s.
tel.: +420 352 465417
e-mail: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michal Zaschke
 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).


RE: Fixed_date and dbms_job

2003-03-13 Thread Jacques Kilchoer
Title: RE: Fixed_date and dbms_job





After calling dbms_job.submit, did you issue a commit?


> -Original Message-
> From: Kader Ben [mailto:[EMAIL PROTECTED]]
> 
>  I'm simulating the date in future with fixed_date.
> I wrote procedure to be called every seconde through
> dbms_job to increment the fixed_date.
> 
> I did that dbms_job.submit(:job_num, 'myprocedure;',
> sysdate, 'sysdate');
> 
> the  dba_jobs table show me the right interval un
> next_date:
> 
>  
> BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC INTERVAL
> N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate
> 
> And the sysdate is:
> 13-JUN-2003 17:50:06
> 
> But the job never execute.





Fixed_date and dbms_job

2003-03-13 Thread Kader Ben
Hi Listers,

 I'm simulating the date in future with fixed_date.
I wrote procedure to be called every seconde through
dbms_job to increment the fixed_date.

I did that dbms_job.submit(:job_num, 'myprocedure;',
sysdate, 'sysdate');

the  dba_jobs table show me the right interval un
next_date:

 
BROKEN  ST_DATE LAST_SEC  NEXT_DATE NEXT_SEC INTERVAL
N  13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate

And the sysdate is:
13-JUN-2003 17:50:06

But the job never execute.

Could you please give me hint how to resolve this
problem?

Thanks you,

Ben


__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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).