Auto monitor the data replication schedule job status in OAC

Aaron Zhong-Oracle

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

SharkNinjia

Description (Required):

Can we have a workaround in OAC Data Replicator to monitor the data replication schedule job status? E.g. send the email notice?

There is no way to set this in configuration page.

We have a idea that to add the trigger on the error info table to send a email when new record insert. If data has been processed to ADW database through scheduled job, we can consider to use such workaround.

However, sometime, the schedule job failed before it begin to process data. So this workaround not work all the time.

Any other ideas or better solution?

blob:https://community.oracle.com/900cc62b-d8f2-48de-b319-36c1832c4d5f
There was an error displaying this embed.

Use Case and Business Need (Required):

Get alters for scheduled data replicator jobs

Enhancement Request / Service Request:

We can config email notification for any data replicator job failure to simplify admin's job.

andrefecteau

Having this for dataflows and replications would be extremely helpful. Right now we have no way to know if they failed unless we look in the OAC interface.

Bret Grinslade - Oracle Analytics-Oracle

We are looking at some approach to notifications.

Mihaela Matei

@Bret Grinslade - Oracle Analytics-Oracle , are there any updates on this? Thanks

Bret Grinslade - Oracle Analytics-Oracle

We don't have an approach for data replication jobs. For data flows, you can review Gabrielle's new blog.

https://blogs.oracle.com/analytics/post/oracle-analytics-data-flow-notification-system