# Launching SQL stored procedures

**URL:** <https://forum.inductiveautomation.com/t/launching-sql-stored-procedures/6094>\
**Category:** Ignition\
**Created:** [March 24, 2013, 9:30pm UTC](https://forum.inductiveautomation.com/t/launching-sql-stored-procedures/6094 "2013-03-24T21:30:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jose.granero](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jose.granero/32/11190_2.png) [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\
**Post date:** [March 24, 2013, 9:30pm UTC](https://forum.inductiveautomation.com/t/launching-sql-stored-procedures/6094/1 "2013-03-24T21:30:53Z")

</div>

What’s the best way to launch SQL stored procedures, according to determined schedules?

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [March 25, 2013, 6:48pm UTC](https://forum.inductiveautomation.com/t/launching-sql-stored-procedures/6094/2 "2013-03-25T18:48:24Z")

</div>

You can use a Stored Procedure Transaction Group with the execution scheduling based off of certain time periods, or a gateway/client timer script that executes a stored procedure call at given time(s). Here are some references to those features in the manual:

[inductiveautomation.com/support/ … occall.htm](http://inductiveautomation.com/support/usermanuals/ignition/system_db_createsproccall.htm)  
[inductiveautomation.com/support/ … \_group.htm](http://inductiveautomation.com/support/usermanuals/ignition/stored_procedure_group.htm)