| does not refresh the job automatically [message #190875] |
Fri, 01 September 2006 15:15  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
