Materialized view is there a way to remove the scheduled job via the alter command
Good morning. This is for Oracle 12.1 or 12.2.
The developers have created a materialized view and scheduled a job to refresh daily using this:
START WITH TO_DATE('16-05-2019 05:00:00','dd-mm-yyyy hh24:mi:ss') NEXT trunc(sysdate) + 05/24 + 1 /* 5:00 a.m. *
i have tried figuring this out but have not found anything.
Is there an alter materialized view command to remove this schedule?
(instead of dropping and recreating the view)
Thanks for the help.