QuartzNet简单实例

1 篇文章 0 订阅

1.要执行的作业

using System.Collections.Generic;

using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Quartz;
using System.Data.SqlClient;
namespace Schedule
{
    public class JobDemo:IJob
    {
        public int count = 0;
        public void Execute(IJobExecutionContext context)
        {
            SqlConnection connet = new SqlConnection();
            connet.ConnectionString = "server=.;database=mydatabase;uid=sa;pwd=yezhu@2017";
            connet.Open();
            SqlCommand com = new SqlCommand();
            com.Connection = connet;
            com.CommandText = "Select * from infos";
            SqlDataReader dr = com.ExecuteReader();
            dr.Close();
            connet.Close();
            ++count;
            Console.WriteLine(count);
            Console.WriteLine(DateTime.Now.ToString("r"));
        }
    }
}


2.作业参数配置

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Quartz;
using Common.Logging;
using log4net;
using Quartz.Impl;
using Topshelf;
namespace Schedule
{
    class Program
    {
        static void Main(string[] args)
        {
            //Console.WriteLine(DateTime.Now.ToString("r"));
            //创建一个作业调度池
            ISchedulerFactory schedf = new StdSchedulerFactory();
            IScheduler sched = schedf.GetScheduler();
            //创建一个具体的作业
            IJobDetail job = JobBuilder.Create<JobDemo>().Build();
            //DateTimeOffset starttime = DateBuilder.NextGivenSecondDate(DateTime.Now.AddSeconds(1), 1);
            //DateTimeOffset endtime = DateBuilder.NextGivenSecondDate(DateTime.Now.AddSeconds(1), 59);
            DateTimeOffset starttime =DateTime.Now.AddMinutes(1);
            DateTimeOffset endtime = DateTime.Now.AddMinutes(2);
            //创建一个触发器
            ISimpleTrigger trigger =
                (ISimpleTrigger)TriggerBuilder.Create()
                    .StartAt(starttime)
                    .EndAt(endtime)
                    .WithSimpleSchedule(x => x.WithIntervalInSeconds(1).WithRepeatCount(4)).Build();
            //ICronTrigger trigger = (ICronTrigger)TriggerBuilder.Create().StartAt(starttime).EndAt(endtime)
            //                          .WithCronSchedule("1,10,14 10,20,25,26,33,54 * * * ? ")
            //                          .Build();
            //加入作业调度池
            sched.ScheduleJob(job, trigger);
            //开始运行
            sched.Start();
            //挂起2天
            //Thread.Sleep(TimeSpan.FromSeconds(2));
            //2天后关闭作业调度,将不在执行
            //sched.Start();
            //sched.Shutdown();
            Console.ReadKey();
        }
    }
}


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值