I have a task execution service, I need to add saving the work history of these tasks to the database. Is it possible to implement this functionality completely through Quartz? That is, for Quartz to create a table, collect the data, and record it. I know that there are ITriggerListener and IJobListener interfaces, but I can't find information on how to make these listeners write to the database themselves. Quartz is already configured on the service and writes to the required database. We only need information specifically on ITriggerListener and IJobListener. Thanks for the help

I tried to implement an IJobListener, but I'm not sure if it saves data in the database.

I have a task execution service, I need to add saving the work history of these tasks to the database. Is it possible to implement this functionality completely through Quartz? That is, for Quartz to create a table, collect the data, and record it. I know that there are ITriggerListener and IJobListener interfaces, but I can't find information on how to make these listeners write to the database themselves. Quartz is already configured on the service and writes to the required database. We only need information specifically on ITriggerListener and IJobListener. Thanks for the help

I tried to implement an IJobListener, but I'm not sure if it saves data in the database.

• c#
• quartz

• Please provide enough code so others can better understand or reproduce the problem. – Community Bot Commented 2 days ago

1 Answer 1

there is pattern named outbox you will store the message in database and on schedule on quartz background service you will retrieve data from that database and on Process you can have 2 column named "Processed at " and "message" which will be updated by quratz service.

In this pattern you are storing record of process status

So:

1. you will store message on your table and a table named "outbox"

2. Quratz will retrieve data from "outbox" table

3. Service will process the message then it will update the message status and time

For storing both table, If you use ef core you can use "Interceptors", it will help you OnSaveChanges you insert into another table and finally saveChange(Unit of Work).