public static void Start()
{
Job myJob = new Job()
{
JobTypeData = new JobType()
{
JobTypeCode = "SQL_QUERY",
JobTypeName = "数据库查询",
JobTypeProcesser = "MyJob.ServiceImpl.SqlQueryJobProcessServiceImpl"
},
JobTimeList = new List <JobTime>(),
JobTypeCode = "SQL_QUERY",
JobCommand = "SELECT id, a, b, c FROM test_abc",
JobSetting = @"Data Source=localhost\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True",
};
// 时间机制， 是 每 10 秒处理一次.
myJob.JobTimeList.Add(new JobTime()
{
JobTimeType = JobTime.JOB_TIME_TYPE_IS_DELAY_SECOND,
JobTimeValue = "10"
});
IJobManager jobManager = new OneJobManager(myJob);
JobFinishDelegate showResult = new JobFinishDelegate(ShowResult);
jobManager.JobFinish = showResult;
jobManager.Start();
}
public static void Start()
{
Job myJob = new Job()
{
JobTypeData = new JobType()
{
JobTypeCode = "SQL_QUERY",
JobTypeName = "数据库查询",
JobTypeProcesser = "MyJob.ServiceImpl.SqlQueryJobProcessServiceImpl"
},
JobTimeList = new List <JobTime>(),
JobTypeCode = "SQL_QUERY",
JobCommand = "SELECT id, a, b, c FROM test_abc WHERE id = 'TEST2'",
JobSetting = @"Data Source=localhost\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True",
};
string [] runTimeArray =
{
"00:00", "30:30",
"01:00", "31:30",
"02:00", "32:30",
"03:00", "33:30",
"04:00", "34:30",
"05:00", "35:30",
"06:00", "36:30",
"07:00", "37:30",
"08:00", "38:30",
"09:00", "39:30",
"10:00", "40:30",
"11:00", "41:30",
"12:00", "42:30",
"13:00", "43:30",
"14:00", "44:30",
"15:00", "45:30",
"16:00", "46:30",
"17:00", "47:30",
"18:00", "48:30",
"19:00", "49:30",
"20:00", "50:30",
"21:00", "51:30",
"22:00", "52:30",
"23:00", "53:30",
"24:00", "54:30",
"25:00", "55:30",
"26:00", "56:30",
"27:00", "57:30",
"28:00", "58:30",
"29:00", "59:30",
};
// 时间机制， 是 每个小时的 指定时间点才执行.
myJob.JobTimeList.Add(new JobTime()
{
JobTimeType = JobTime.JOB_TIME_TYPE_IS_HOURLY,
JobTimeValue = String.Join(";", runTimeArray)
});
IJobManager jobManager = new OneJobManager(myJob);
JobFinishDelegate showResult = new JobFinishDelegate(ShowResult);
jobManager.JobFinish = showResult;
jobManager.Start();
}