SFMC Automation Health Check
Updated: Oct 16, 2019
Need for Automation Heath Check:
In most of the business world, to implement a use case in Salesforce Marketing Cloud, we need to create lots and lots of automation's activity.
It will be very hard to keep track on which automation runs and which automation didn't run or it got failed.
In this blog, we are going too see how SSJS gets all the automation status running in the org and upserts the data into data extension. Sending an email to SFMC Admins with those data extension records.
Below SSJS will give you an idea of which automation has run which doesn't:
Add the SSJS in cloud page or automation SSJS activity.
Create a data extension with columns as mentioned in the screenshot. In the above case its 'Automation_Status'
Add records for which you need to monitor Automation status
Specify the automation name and customer key
You can check on the same data extension once the cloud page or automation activity completes.
You can see that the status and scheduled time would have added for the specified automation in data extension.
You can also use this data in data extension to send an email to specified people who needs to monitor.
Please feel free to leave a comment in case of any queries.