Salesforce CMCA: How to Ensure Query Failure Notifications in Marketing Cloud

Receive Query Failure Notifications in Marketing Cloud

Question

A Marketing Cloud admin has scheduled a query on a daily basis. They notice the query sometimes fails to execute.

How would the admin ensure a notification is received when the query fails?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C.

B

If a Marketing Cloud admin has scheduled a query on a daily basis and notices that the query sometimes fails to execute, they can set up a notification to be received when the query fails. This can be achieved by configuring the "Event Notification Service" in the Setup app with their email address.

The Event Notification Service is a feature within Marketing Cloud that sends notifications when specific events occur within the platform. These events can include the failure of a query. To configure the Event Notification Service, follow these steps:

  1. Log in to Marketing Cloud and navigate to the Setup app.
  2. In the left-hand navigation menu, click on "Notifications" under the "Monitoring" section.
  3. Click on the "Event Notification Service" tab.
  4. Click the "New" button to create a new event notification.
  5. Select "Query Activity" as the event type.
  6. Choose the criteria for the notification, such as "when the query fails."
  7. Enter the email address of the admin who should receive the notification.
  8. Save the event notification.

Once the event notification is saved, the Marketing Cloud admin will receive an email notification when the query fails. This can help the admin quickly identify and resolve any issues with the query, ensuring that it runs successfully on a daily basis.