Mobile alerting with tracking & escalation for Microsoft SQL Agent Jobs
Why Enterprise Alert
With the ever-increasing need to digitalize processes in production and administration, data is being collected and stored in various systems and formats. The main storage systems for the collected data are usually Microsoft SQL databases. Enterprise Alert tabs into the collected data to provide automatic, reliable, and easy to read notifications to concerned parties on the shop floor and administration through email, push, SMS, and voice calls – even targeting your on-call personnel.
How it Works
Create a SQL Server Agent Job running a PowerShell script to query and forward Data via a REST Request to a dedicated Enterprise Alert REST API link will provide a connection between the systems.
Forwards SQL information to Enterprise Alert for mobile alerting
Uses REST API to connect to your Enterprise Alert instance
Staff can acknowledge and take ownership of critical events that occur
Communicate within an alert to address a problem
Alerts are escalated in case of no response
On-call scheduling to alert the right people at the right time
How to Integrate
We will use a PowerShell script run by the SQL Server Agent to periodically extract information from the external database and then send a REST request to Enterprise Alert. Once received, the magic of EA takes over, filtering through the data to identify if the conditions are within range and then quickly notifying the Maintenance team of the issue.
Make sure to replace the place holders in the Connection String and in the URL with actual values.
Optional: Adapt the SQL query to match your needs
Go to Schedules and create a new schedule the setup below will trigger daily at 5 pm
In Enterprise Alert create new policies applying to the data being forwarded.
Notifications within the Enterprise Alert mobile app
Enterprise Alert comes complete with a mobile app allowing for all critical alert details to be seen from anywhere. Users can acknowledge and take ownership of alerts and with remote actions, even resolve them. Team members collaborate with their peers so that even if an on-call person is not the SME, that person is easily within reach via voice call, text or email.
A centralized Alert Center can be viewed from the web portal. All alerts, whether active, overdue or closed are visible to EA admins. Ownership and even delegation is as easy as drag-and-dropping the alert to the person/team.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.