Home » SQL & PL/SQL » SQL & PL/SQL » does not refresh the job automatically
does not refresh the job automatically [message #190875] Fri, 01 September 2006 15:15 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member

Hello Experts,


I have created a job to refresh automatically every hour which should refresh my materialized view. When I manuall execute this, it works fine and job status shows the next hour when it should refresh, but does not do it. Can you all please help me to see if I missed anything.

Thanks in advance.

Here is the job defination:
===========
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'SYS.dbms_refresh.refresh(''"myschema"."T_GROUP"'');'
,next_date => to_date('01/09/2006 13:16:58','dd/mm/yyyy hh24:mi:ss')
,interval => 'SYSDATE + 1/24 '
,no_parse => FALSE
);
END;
/
======= end of the job



Re: does not refresh the job automatically [message #190876 is a reply to message #190875] Fri, 01 September 2006 15:19 Go to previous message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

i am not sure abt the dbms_refresh...but while creation of materialised view there is an option such that the MV will be refreshed automatically...

CREATE MATERIALIZED VIEW T
REFRESH FAST START WITH SYSDATE NEXT trunc(SYSDATE) + 1
AS SELECT .....

below link can provide u with more detail
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1167235330355

Naveen

[Updated on: Fri, 01 September 2006 15:24]

Report message to a moderator

Previous Topic: URGENT!! URGENT!!
Next Topic: How to find Open Cursors
Goto Forum:
  


Current Time: Sat Dec 03 06:08:54 CST 2016

Total time taken to generate the page: 0.12563 seconds