var builder = WebApplication.CreateBuilder(args);
...
builder.Host.UseSerilog();
...
var app = builder.Build();
...
app.UseSerilogSinks();

    public static WebApplication UseSerilogSinks(this WebApplication app)
    {
        var loggerConfig = new LoggerConfiguration()
            .MinimumLevel.Debug()
            .Enrich.FromLogContext()
            .Enrich.WithProperty("Application", "JobServer");

        loggerConfig = ConfigureDbSink(loggerConfig);

        Log.Logger = loggerConfig.CreateLogger();
        
        return app;
    }

    private static LoggerConfiguration ConfigureDbSink(LoggerConfiguration loggerConfig)
    {
        var msSqlServerSinkOptions = new MSSqlServerSinkOptions
        {
            AutoCreateSqlTable = true,
            SchemaName = "Hangfire",
            TableName = "JobEventLogs"
        };

        var columnOpts = new ColumnOptions();
        columnOpts.Store.Remove(StandardColumn.Properties);
        columnOpts.Store.Add(StandardColumn.LogEvent);
        columnOpts.Id.DataType = SqlDbType.BigInt;
        columnOpts.Id.NonClusteredIndex = true;
        columnOpts.LogEvent.DataLength = -1;
        columnOpts.TimeStamp.NonClusteredIndex = true;
        columnOpts.AdditionalColumns = new Collection<SqlColumn>
        {
            new SqlColumn { ColumnName = "JobId", DataType = SqlDbType.BigInt, NonClusteredIndex = true, AllowNull = false },
            new SqlColumn { ColumnName = "RecurringJobId", DataType = SqlDbType.NVarChar, NonClusteredIndex = true, AllowNull = true, DataLength = 512 },
            new SqlColumn { ColumnName = "SourceContext", DataType = SqlDbType.NVarChar, NonClusteredIndex = true, AllowNull = true, DataLength = 256 }
        };

        loggerConfig = loggerConfig.WriteTo.Logger(lc => lc
            .Filter.ByIncludingOnly(Matching.WithProperty("JobId"))
            .WriteTo.MSSqlServer(..., msSqlServerSinkOptions, columnOptions: columnOpts)
        );

        return loggerConfig;
    }