How can i setup an MV refresh job?
845836May 21 2012 — edited May 22 2012Hi,
We have an MV refresh scheduled every wknd through DBMS scheduler. But if it fails PRod support has to re-run by executing DBMS_MVIEW script that we have provided them. They want to avoid executing script and want some job which they can simply run.
We have autosys tool. But we can't create a batch script and run it thru autosys as in batch script we have to hardcode the passwd for connection string which is not allowed.
How can i create a job in database that they can siimply run if the scheduled MV refresh job fails? Also currently if a scheduled refresh job fails ther is no alert message. How should I setup an aleart messages for failure? Thanks in advance.
Database Version 11G