参考:
https://www.cnblogs.com/zhenghengbin/p/12230300.html
https://blog.csdn.net/kangkanglou/article/details/82849744
https://blog.csdn.net/qq_35206261/article/details/90478221
一、配置JobEventConfig事件追踪
- 由于我用了多数据源,一个
@Bean(name = "sakuraDataSource")
、另一个@Bean(name = "sakura2DataSource")
,所以这里选择其中一个。 - 如果是单数据源
private DataSource sakuraDataSource;
换成private DataSource dataSource;
就行了
@Configuration
public class JobEventConfig {
@Autowired
private DataSource sakuraDataSource;
@Bean
public JobEventConfiguration jobEventConfiguration() {
return new JobEventRdbConfiguration(sakuraDataSource);
}
}
二、在作业中配置中增加事件追踪配置,如图:
加完以后的完整代码如下:
/**
* @author jushisi
* @description 配置任务
*/
@Configuration
public class JobConfig {
// private final int shardingTotalCount = 3;
// private final String shardingItemParameters = "0=A,1=B,2=C";
private final int shardingTotalCount = 1;
private final String shardingItemParameters = "";
@Autowired
private JobEventConfiguration jobEventConfiguration;
@Resource
private ZookeeperRegistryCenter regCenter;
@Bean
public TestAJob testAJob() {
return new TestAJob();
}
@Bean(initMethod = "init")
public SpringJobScheduler simpleJobScheduler(final TestAJob testAJob) {
LiteJobConfiguration liteJobConfig = getLiteJobConfiguration(testAJob.getClass(), testAJob.getCron(), testAJob.getJobParameters(), testAJob.getDescription());
return new SpringJobScheduler(testAJob, regCenter, liteJobConfig, jobEventConfiguration);
}
@Bean
public TestBJob testBJob() {
return new TestBJob();
}
@Bean(initMethod = "init")
public SpringJobScheduler mySimpleJobScheduler(final TestBJob testBJob) {
LiteJobConfiguration liteJobConfig = getLiteJobConfiguration(testBJob.getClass(), testBJob.getCron(), testBJob.getJobParameters(), testBJob.getDescription());
return new SpringJobScheduler(testBJob, regCenter, liteJobConfig, jobEventConfiguration);
}
/**
* @description 构建作业配置
* @author jushisi
*/
private LiteJobConfiguration getLiteJobConfiguration(final Class<? extends SimpleJob> jobClass,
final String cron,
final String jobParameters,
final String description) {
// 定义作业核心配置
String jobName = jobClass.getName();
JobCoreConfiguration coreConfig =
JobCoreConfiguration.newBuilder(jobName, cron, shardingTotalCount)
.shardingItemParameters(shardingItemParameters)
.description(description)
.jobParameter(jobParameters)
.build();
// 定义SIMPLE类型配置
SimpleJobConfiguration simpleJobConfig = new SimpleJobConfiguration(coreConfig, jobClass.getCanonicalName());
// 定义Lite作业根配置
LiteJobConfiguration simpleJobRootConfig = LiteJobConfiguration.newBuilder(simpleJobConfig).overwrite(true).build();
return simpleJobRootConfig;
}
}
四、启动项目时,elastic-job会自动在数据库中建两张表
表结构如下:
CREATE TABLE `job_execution_log` (
`id` varchar(40) NOT NULL,
`job_name` varchar(100) NOT NULL,
`task_id` varchar(255) NOT NULL,
`hostname` varchar(255) NOT NULL,
`ip` varchar(50) NOT NULL,
`sharding_item` int(11) NOT NULL,
`execution_source` varchar(20) NOT NULL,
`failure_cause` varchar(4000) DEFAULT NULL,
`is_success` int(11) NOT NULL,
`start_time` timestamp NULL DEFAULT NULL,
`complete_time` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `job_status_trace_log` (
`id` varchar(40) NOT NULL,
`job_name` varchar(100) NOT NULL,
`original_task_id` varchar(255) NOT NULL,
`task_id` varchar(255) NOT NULL,
`slave_id` varchar(50) NOT NULL,
`source` varchar(50) NOT NULL,
`execution_type` varchar(20) NOT NULL,
`sharding_item` varchar(100) NOT NULL,
`state` varchar(20) NOT NULL,
`message` varchar(4000) DEFAULT NULL,
`creation_time` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `TASK_ID_STATE_INDEX` (`task_id`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
四、登录Console管理端,配置事件追踪数据源