CODEWITHSUNDEEP
sql-serverasp.net-web-apihangfire
Poseidon
Poseidon

Reputation: 101

Triggering Hangfire Jobs using SQL

I have a Hangfire service running on one of my servers, I'm a DBA and sometimes I'm asked to trigger jobs using the Dashboard, but it takes me a lot of time to connect to the jobs' server due to some connectivity and security issues. And to overcome that, I want to trigger those jobs by inserting in Hangfire's tables on the database, I can already query those tables to find which job executed when and whether they failed, succeeded or still enqueued, does anyone know an approach to do so?

I've included a sample of two tables which I think will be used to do this trick, their names are Hash and Set respectively:

"Hash" Table

Set Table

Upvotes: 2

Views: 1936

Answers (1)

firatt_
firatt_

Reputation: 176

Hangfire normally uses a gui like swagger in .net (http://localhost:5000/hangfire) , there should be a immediate trigger feature. If not a second option is changing the cron expression for every minute or maybe every 30 seconds.

Upvotes: 1

Related Questions