Schedule task on trigger

[bowbahdoe]

Hi - I know it must be possible in concept, but I'm looking for any documentation on how to schedule a task on insert/update of a table.

I can respond to that with a trigger, but I don't know what data to insert into the scheduled events table.

[kagkarlsson]

You just have to replicate what is done here: https://github.com/kagkarlsson/db-scheduler/blob/master/db-scheduler/src/main/java/com/github/kagkarlsson/scheduler/jdbc/JdbcTaskRepository.java#L214

Keep in mind that this may change in future versions of db-scheduler

[bowbahdoe]

Well the database schema would also have to change in said future versions, so its not like it could be done trivially.

The reason I want to do this is specifically that it is really easy to build "event driven" systems if you can run code on inserts/updates as opposed to explicitly scheduling a background job for later. Those explicit schedule points are a lot harder to reason about than generic db triggers.