Get email alerts for failed or canceled optimization requests

Resource Scheduling Optimization runs can fail for various reasons. As a best practice, we recommend that you set up an automated workflow that monitors optimization jobs and sends alerts based job status. Microsoft Power Automate is a comprehensive end-to-end automation platform that you can use to help with monitoring and send alerts when failures occur.

Create a flow in Power Automate

1. Sign in to Power Automate.

2. Select the environment where Resource Scheduling Optimization is installed.

3. Select Create, and then select Automated cloud flow.

4. Give your flow a name, and select the When a row is added, modified, or deleted trigger.

5. Configure the trigger parameters:

   • Change Type: Modified
   • Table Name: Scheduling Optimization Requests
   • Scope: Organization
   • Selected Columns: modifiedon, mydyn_optmizationstatus, and optmizationId

6. Add an action, and select Control.

7. Select Condition in the list. For alerts about any failures or cancellations in the past six hours, set up the following expression.

   AND
       modifiedon is greater than addHours(-6)
       OR
       OptimizationStatus is equal to 192350003
       OptimizationStatus is equal to 192350004
   

   In this expression, 192350003 represents a canceled optimization request, and 192350004 represents a failed request.

8. In the True branch of the condition, add an action, and select Send an email notification (V3).

9. Configure the parameters for the email notification. To include column values in the subject or body, select the lightning bolt symbol, and then select the name of the column in the filter box.