# Run SQL Update After Alarm Pipeline sent messages

**URL:** <https://forum.inductiveautomation.com/t/run-sql-update-after-alarm-pipeline-sent-messages/9495>\
**Category:** Ignition\
**Created:** [December 30, 2014, 3:56pm UTC](https://forum.inductiveautomation.com/t/run-sql-update-after-alarm-pipeline-sent-messages/9495 "2014-12-30T15:56:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tailfire](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\
**Post date:** [December 30, 2014, 3:56pm UTC](https://forum.inductiveautomation.com/t/run-sql-update-after-alarm-pipeline-sent-messages/9495/1 "2014-12-30T15:56:29Z")

</div>

I would like to know how to go about running a SQL update AFTER an alarm pipeline has sent its messages.  
I would like to keep this inside the gateway. Can this possibly be done within the Alarm notification pipeline?  
I have almost 30 tags in which can trigger this alarm. I just upgraded to 7.7.2 so there are definitely some new features for me to get a grasp on… Maybe with the “set property” or “script”…?  
Currently when a message gets sent I open MSSQL Management Studio and run the update query myself.  
There surely is a more graceful way to use ignition for this…?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [January 5, 2015, 6:35pm UTC](https://forum.inductiveautomation.com/t/run-sql-update-after-alarm-pipeline-sent-messages/9495/2 "2015-01-05T18:35:18Z")

</div>

We added a scripting block in 7.7.2… I think you could put that after your notification block and run your query there?