Open merlinschumacher opened 3 months ago
@merlinschumacher Could you please provide a PR for this fix?
This is also an issue for PostgreSQL. It can be solved with the following configuration:
q.UsePersistentStore(c =>
{
c.UsePostgres(po =>
{
po.UseDriverDelegate<PostgreSQLDelegate>();
po.ConnectionStringName = "Database";
po.TablePrefix = "quartz.qrtz_";
});
c.UseNewtonsoftJsonSerializer();
});
But that's not really pretty
When using this library to create the tables for Quartz.NET the library uses the schema "quartz" by default. But Quartz.NET itself uses "dbo". The migrations only work when setting the schema manually, because Quartz.NET doesn't find the tables and . See https://github.com/quartznet/quartznet/blob/main/database/tables/tables_sqlServer.sql
The following error occurs: