Exception thrown: 'Quartz.JobPersistenceException' in System.Private.CoreLib.dll

[MiguelChen17]

public MySchedulerBackgroundService(IJobFactory jobFactory, MyJob myJob)
{
this.jobFactory = jobFactory;
var props = new NameValueCollection
{
{ "quartz.serializer.type", "json" },
{ "quartz.jobStore.type", "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz" },
{ "quartz.jobStore.useProperties", "true" },
// { "quartz.jobStore.driverDelegateType", "Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz" },
{ "quartz.jobStore.dataSource", "myDS" },
{ "quartz.jobStore.tablePrefix", "QRTZ_"},
{ "quartz.dataSource.myDS.connectionString", "Server=localhost;Port=3306;database=quartz1;Uid=root;pwd=12345678;CharSet=utf8;" },
{ "quartz.dataSource.myDS.provider", "MySqlConnector" }

        /*     { "quartz.serializer.type", "json" },
            { "quartz.jobStore.type", "Quartz.Simpl.RAMJobStore, Quartz" }*/
        };
        this.schedulerFactory = new StdSchedulerFactory(props);

        this.myJob = myJob;
    }

this my code.

[MiguelChen17]

Im using .net7 and quartz3.2

this is my code

1 is schedulerservice

namespace WorkerService3
{
using System;
using System.Collections.Specialized;
using System.Configuration;
using System.Reflection.Metadata;
using System.Threading;
using System.Threading.Tasks;
using Quartz;
using Quartz.Impl;
using Quartz.Impl.AdoJobStore;
using Quartz.Simpl;
using Quartz.Spi;

using System.Collections.Generic;

using System.Threading.Tasks;

public class MySchedulerBackgroundService : BackgroundService
{

    private readonly IJobFactory jobFactory;
    private readonly ISchedulerFactory schedulerFactory;
    private readonly MyJob myJob;

    public MySchedulerBackgroundService(IJobFactory jobFactory, MyJob myJob)
    {
        this.jobFactory = jobFactory;
        var props = new NameValueCollection
        {
          { "quartz.serializer.type", "json" },
{ "quartz.jobStore.type", "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz" },
{ "quartz.jobStore.useProperties", "true" },
     //       { "quartz.jobStore.driverDelegateType", "Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz" },
{ "quartz.jobStore.dataSource", "myDS" },
            { "quartz.jobStore.tablePrefix", "QRTZ_"},
{ "quartz.dataSource.myDS.connectionString", "Server=localhost;Port=3306;database=quartz1;Uid=root;pwd=12345678;CharSet=utf8;" },
{ "quartz.dataSource.myDS.provider", "MySqlConnector" }

        /*     { "quartz.serializer.type", "json" },
            { "quartz.jobStore.type", "Quartz.Simpl.RAMJobStore, Quartz" }*/
        };
        this.schedulerFactory = new StdSchedulerFactory(props);

        this.myJob = myJob;
    }

    protected override async Task ExecuteAsync(CancellationToken stoppingToken)
    {
    
        // Create a new scheduler
        var scheduler = await schedulerFactory.GetScheduler(stoppingToken);

        // Set the job factory for the scheduler
        scheduler.JobFactory = jobFactory;


       
        // Create a new job detail for the MyJob
        var jobDetail = JobBuilder.Create<MyJob>()
           .WithIdentity("job1", "group1")
           .Build();
       
        jobDetail.JobDataMap.Put("RetryCount", 3);


        var trigger = TriggerBuilder.Create()
            .WithIdentity("trigger1", "group1")
            .StartNow()
            //.WithCronSchedule("0 42 10 * * ?")
            .Build();

        List<string> serviceNames = new List<string> { "Fax"};


     

        // pass the service names to the job
        jobDetail.JobDataMap.Put("ServiceNames", serviceNames);

     //   scheduler.ListenerManager.AddJobListener(new JobFailureListener());

Console.WriteLine("booooooo");
await Task.Delay(5000);

        // Schedule the job with the trigger
        await scheduler.ScheduleJob(jobDetail, trigger, stoppingToken);

        // Start the scheduler
        await scheduler.Start(stoppingToken);
       
        // Wait for the service to be stopped
        await Task.Delay(-1, stoppingToken);
    }
}

/*    public override async Task StopAsync(CancellationToken stoppingToken)
    {
        await _scheduler.Shutdown(stoppingToken);
        await base.StopAsync(stoppingToken);
    }
}*/

}

2 is Myjob

using MimeKit;
using Quartz;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net.Mail;
using System.Net.NetworkInformation;
using System.Text;
using System.Threading.Tasks;
using MailKit.Net.Smtp;
using System.ServiceProcess;

namespace JobSchedulerDemo;
[Serializable]

public class MyJob: IJob
{

public async Task Execute(IJobExecutionContext context)
 {

    List<string> serviceNames = (List<string>)context.JobDetail.JobDataMap["ServiceNames"];

    foreach (string serviceName in serviceNames)
    {
        ServiceController service = new ServiceController(serviceName);
        Console.WriteLine(service.DisplayName + " has initial status of: " + service.Status);
        if (service.Status != ServiceControllerStatus.Running)
        {
            service.Start();
            Console.WriteLine(service.DisplayName + " Windows Service started successfully.");
        }
        else
        {
            Console.WriteLine("Windows Service is already running.");
        }

        
    }

  await Task.Delay(5000);

}

/*   private readonly ILogger<MyJob> _logger;

   public MyJob(ILogger<MyJob> logger)
   {
       _logger = logger;
   }

   public async Task Execute(IJobExecutionContext context)
   {
       _logger.LogInformation($"Tarefa1 iniciada em {DateTime.Now}");

       // Simulating task execution
       await Task.Delay(5000);

       _logger.LogInformation($"Tarefa1 concluída em {DateTime.Now}");
   }*/

}

[MiguelChen17]

I was thibking if I needed to match every parameter of databse in MYjob but not sure

[MiguelChen17]

my program class

 class Program

{
static async Task Main(string[] args)
{
var host = new HostBuilder()
.ConfigureServices((hostContext, services) =>
{

            services.AddTransient<MyJob>();
            services.AddSingleton<IJobFactory, SimpleJobFactory>();

//ervices.AddSingleton<ISchedulerFactory, services.AddTransient(); > ();

            services.AddHostedService<MySchedulerBackgroundService>();
        })
        .Build();

    await host.RunAsync();
}

}