Quartz.net JobStoreTX Job Save issue

我正在尝试为我的网站维护任务运行Quartz.net服务器。我在WCF应用程序(托管在IIS上)中创建了作业和触发器。因此，它们可以存储在数据库(SQL Server)。

现在我不能理解ADO。NET作业存储。这是我的网。配置部分:

<configSections>
    <section name="quartz" type="System.Configuration.NameValueSectionHandler" />
</configSections>
<quartz>
    <add key="quartz.threadPool.type" value="Quartz.Simpl.SimpleThreadPool, Quartz" />
        <add key="quartz.threadPool.threadCount" value="10" />
        <add key="quartz.threadPool.threadPriority" value="Normal" />
        <add key="quartz.jobStore.misfireThreshold" value="60000" />
        <add key="quartz.jobStore.type" value="Quartz.Impl.AdoJobStore.JobStoreTX, Quartz" />
        <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.**SqlServerDelegate**, Quartz" />
        <add key="quartz.jobStore.tablePrefix" value="QRTZ_" />
        <add key="quartz.jobStore.dataSource" value="ConnectionString" />
        <add key="quartz.dataSource.ConnectionString.connectionString" value="Server=*;Database=*;Uid=*;Pwd=*" />
        <add key="quartz.dataSource.ConnectionString.provider" value="SqlServer-20" />
        <add key="quartz.scheduler.instanceName" value="PaymentService" />
        <add key="quartz.jobStore.useProperties" value="true" />
</quartz>

这里是global。asax:

public class Global : System.Web.HttpApplication
    {
        public static ISchedulerFactory Factory;
        public static IScheduler Scheduler;
        protected void Application_Start(Object sender, EventArgs e)
        {
            Factory = new StdSchedulerFactory();
            Scheduler = Factory.GetScheduler();
            JobKey JobKey = new JobKey("GetOrderInfoJob", "Project");
            if (Scheduler.CheckExists(JobKey))
                Scheduler.DeleteJob(JobKey);
            IJobDetail job = JobBuilder.Create<PaymentServiceLogic>()
                .WithIdentity(JobKey)
                .StoreDurably()
                .RequestRecovery()
                .Build();
            TriggerKey triggerKey = new TriggerKey("GetOrderInfoTrigger", "Project");
            TriggerBuilder tb = TriggerBuilder.Create();
            tb.WithIdentity(triggerKey );
            tb.WithSimpleSchedule(a => a.WithIntervalInMinutes(1));
            tb.StartNow();
            tb.ForJob(job);
            ITrigger trigger = tb.Build();
            Scheduler.ScheduleJob(trigger);
            Scheduler.Start();
        }
}

一旦我在本地主机上启动了WCF服务，SQL Server中的QRTZ_JOB_DETAILS表中的作业有1个条目，但没有触发器。我已经测试了这段代码几次，现在没有工作正在存储，因此我有这个例外:

无法存储触发器作业:触发器引用的作业不存在。

是否有一些bug与工作的建设或AdoJobStore?

第二个问题是关于如何在global.asax中正确关闭。现在我已经决定了这个方法:

protected void Application_End(object sender, EventArgs e)
        {
            ICollection<IScheduler> all = Factory.AllSchedulers;
            foreach (IScheduler item in all)
            {
                item.Shutdown(true);
            }
        }

和实现我自己的日志在Application_Error.

Scheduler.ScheduleJob(trigger);

Scheduler.ScheduleJob(job, trigger);