# Using a SQL triggar run a clover graph

**URL:** <https://forum.cloverdx.com/t/using-a-sql-triggar-run-a-clover-graph/2138>\
**Category:** CloverDX Platform\
**Created:** [December 22, 2022, 11:24am UTC](https://forum.cloverdx.com/t/using-a-sql-triggar-run-a-clover-graph/2138 "2022-12-22T11:24:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![William\_Wilson](https://avatars.discourse-cdn.com/v4/letter/w/3e96dc/32.png) [@William\_Wilson](https://forum.cloverdx.com/u/William_Wilson)\
**Post date:** [December 22, 2022, 11:24am UTC](https://forum.cloverdx.com/t/using-a-sql-triggar-run-a-clover-graph/2138/1 "2022-12-22T11:24:55Z")

</div>

I want a clover graph to run when a record is inserted into a sql table.

Is there a way a sql triggar could kick off a clover graph?

---

<div class="post-metadata">

**Author:** ![Vladimir\_Barton](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/vladimir_barton/32/167_2.png) [@Vladimir\_Barton](https://forum.cloverdx.com/u/Vladimir_Barton)\
**Post date:** [December 23, 2022, 9:37am UTC](https://forum.cloverdx.com/t/using-a-sql-triggar-run-a-clover-graph/2138/2 "2022-12-23T09:37:41Z")

</div>

Hello William,

Unfortunately, there is currently no native feature in CloverDX for this specific task. Nevertheless, the versatility of CloverDX offers a variety of workaround options some of which might depend also on the DB vendor. Generally speaking, there are 2 main features that you can take advantage of: schedules and event listeners.

One of the possible approaches would be to the schedule a jobflow to run a on regular basis with a relatively short interval (seconds or tens of seconds) that would extract the latest record from a given table and compare it to the record from a previous run. If records don’t match the jobflow will trigger the desired graph execution.

The latter option would depend more on the type/vendor of the DB. Basically, the DB would have to be able to trigger touching/updating a file based on a newly inserted record. Combined with a file event listener set up to listen on such a file, CloverDX would trigger the desired graph execution.

Feel free to specify your database vendor and version and we can dive into this a bit more.

Cheers.