using System;

using System.Text;using log4net;

using Quartz;

namespace WebAPI.Task.Jobs

{

    public sealed class VCodeExpired : IJob

    {

        private readonly ILog _logger = LogManager.GetLogger(typeof(VCodeExpired));

        public void Execute(IJobExecutionContext context)

        {

            string result = string.Empty;

            try

            {

                StringBuilder strSql = new StringBuilder();

                strSql.Append("UPDATE [dbo].表 SET [VCode]=NULL ");

                result = DbHelperSQL.ExecuteSql(strSql.ToString()) >  ? "成功" : "失败";

            }

            catch (Exception ex)

            {

                result = ex.Message;

            }

            _logger.Info(string.Format("VCodeExpired—>{0}", result));

        }

    }

}

using System.ServiceProcess;

using Common.Logging;

using Quartz.Impl;

namespace Quartz.Net.Service

{

    public partial class QuartzService : ServiceBase

    {

        private readonly ILog logger;

        private IScheduler scheduler;

        public QuartzService()

        {

            InitializeComponent();

            logger = LogManager.GetLogger(GetType());

            ISchedulerFactory schedulerFactory = new StdSchedulerFactory();

            scheduler = schedulerFactory.GetScheduler();

        }

        protected override void OnStart(string[] args)

        {

            scheduler.Start();

            logger.Info("Quartz服务成功启动");

        }

        protected override void OnStop()

        {

            scheduler.Shutdown();

            logger.Info("Quartz服务成功终止");

        }

        protected override void OnPause()

        {

            scheduler.PauseAll();

        }

        protected override void OnContinue()

        {

            scheduler.ResumeAll();

        }

    }

}

using System;

using System.IO;

using log4net;

namespace KYINT.WebAPI.Task

{

    class Program

    {

        static void Main(string[] args)

        {

            ILog _logger = LogManager.GetLogger(typeof(Program));

            try

            {

                HostFactory.Run(x =>

                {

                    x.UseLog4Net();

                    x.Service<QuartzService>();

                    x.SetDescription("服务描述");

                    x.SetDisplayName("服务显示名称");

                    x.SetServiceName("服务名称");

                    x.EnablePauseAndContinue();

                });

            }

            catch (Exception ex)

            {

                _logger.Error(ex.Message);

            }

        }

    }

}

# You can configure your scheduler in either <quartz> configuration section

# or in quartz properties file

# Configuration section has precedence

quartz.scheduler.instanceName = QuartzTest

# configure thread pool info

quartz.threadPool.type = Quartz.Simpl.SimpleThreadPool, Quartz

quartz.threadPool.threadCount = 10

quartz.threadPool.threadPriority = Normal

# job initialization plugin handles our xml reading, without it defaults are used

quartz.plugin.xml.type = Quartz.Plugin.Xml.XMLSchedulingDataProcessorPlugin, Quartz

quartz.plugin.xml.fileNames = ~/quartz_jobs.xml

# export this server to remoting context

#quartz.scheduler.exporter.type = Quartz.Simpl.RemotingSchedulerExporter, Quartz

#quartz.scheduler.exporter.port = 555

#quartz.scheduler.exporter.bindName = QuartzScheduler

#quartz.scheduler.exporter.channelType = tcp

#quartz.scheduler.exporter.channelName = httpQuartz

<?xml version="1.0" encoding="utf-8" ?>

<job-scheduling-data xmlns="http://quartznet.sourceforge.net/JobSchedulingData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.0">

  <processing-directives>

    <overwrite-existing-data>true</overwrite-existing-data>

  </processing-directives>

  <schedule>

    <job>

      <name>VCodeExpired</name>

      <group>VCodeExpiredJob</group>

      <description>VCodeExpired</description>

      <job-type>WebAPI.Task.Jobs.VCodeExpired,WebAPI.Task</job-type>

      <durable>true</durable>

      <recover>false</recover>

    </job>

    <trigger>

      <cron>

        <name>VCodeExpiredTrigger</name>

        <group>VCodeExpiredJob</group>

        <job-name>VCodeExpired</job-name>

        <job-group>VCodeExpiredJob</job-group>

        <cron-expression>59 59 23 * * ? *</cron-expression>

      </cron>

    </trigger>

  </schedule>

</job-scheduling-data>