Merge command fails when combined with Job
Dear Friends,
When I execute a below merge command it succeed. But the merge command with job fails. Please suggest.
Merge command:
SQL> merge into NCMS20.WEBDATA_MARINE_BUOY@LINK_UDBMARINE_WEB.NCMS.AE dest using (select * from WEBDATA_MARINE_BUOY_STG where to_date(MEASURE_TIME_GST,'YYYY-MM-DD HH24:MI:SS') > sysdate-1) src
2 on (dest.STATION_ID=src.STATION_ID and dest.MEASURE_TIME_GST = to_date(src.MEASURE_TIME_GST,'YYYY-MM-DD HH24:MI:SS'))
3 when not matched then
4 insert(
5 STATION_ID,
MEASURE_TIME_GST,
6 7 WATER_LEVEL,
8 SIGNIFICANT_WAVE_HEIGHT,
9 PEAK_WAVE_PERIOD,
CURRENT_SPEED_BOTTOM,
CURRENT_SPEED_MID,