When I used the hangfire Job and excuting the function [ RecurringJob.AddOrUpdate], received the Exception (msg:Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.”) .
Then I find the source Code from the hangfie github and found that the sql in source code use the [forceseek] grammar not supported in Sql server 2016 or higher version. So I want to know how I can fix the problem.
Not really sure what issue you’re having. I’m currently running Hangfire on an SQL Server 2019 database without any problems.
The documentation for SQL Server shows SET FORCEPLAN is available on every currently supported version of SQL Server, so that’s not the culprit. Might help to note what edition and version of SQL Server that you’re using.