任务计划表结构
4.94 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
create table appdata.SLIS_BATCH_PLAN
(
sequence VARCHAR2(20) not null,
proc_code VARCHAR2(4),
branch_code VARCHAR2(10),
parameters VARCHAR2(2000),
scheduled_start_date DATE,
priority INTEGER,
proc_flag VARCHAR2(2),
create_date DATE,
create_user VARCHAR2(100),
fcu VARCHAR2(100),
fcd DATE,
lcu VARCHAR2(100),
lcd DATE,
job_no NUMBER,
job_source_module VARCHAR2(4),
start_date DATE,
end_date DATE
)
comment on table appdata.SLIS_BATCH_PLAN
is '任务计划表';
-- Add comments to the columns
comment on column appdata.SLIS_BATCH_PLAN.sequence
is '流水号';
comment on column appdata.SLIS_BATCH_PLAN.proc_code
is '批处理代码';
comment on column appdata.SLIS_BATCH_PLAN.branch_code
is '机构代码';
comment on column appdata.SLIS_BATCH_PLAN.parameters
is '批处理参数';
comment on column appdata.SLIS_BATCH_PLAN.scheduled_start_date
is '任务计划启动时间';
comment on column appdata.SLIS_BATCH_PLAN.priority
is '优先级';
comment on column appdata.SLIS_BATCH_PLAN.proc_flag
is '批处理状态';
comment on column appdata.SLIS_BATCH_PLAN.create_date
is '写入时间';
comment on column appdata.SLIS_BATCH_PLAN.create_user
is '写入用户';
comment on column appdata.SLIS_BATCH_PLAN.fcu
is '创建人';
comment on column appdata.SLIS_BATCH_PLAN.fcd
is '创建日期';
comment on column appdata.SLIS_BATCH_PLAN.lcu
is '修改人';
comment on column appdata.SLIS_BATCH_PLAN.lcd
is '修改日期';
comment on column appdata.SLIS_BATCH_PLAN.job_no
is 'job号';
comment on column appdata.SLIS_BATCH_PLAN.job_source_module
is 'job模块号';
comment on column appdata.SLIS_BATCH_PLAN.start_date
is '任务起始时间';
comment on column appdata.SLIS_BATCH_PLAN.end_date
is '任务结束时间(不精确,间隔时间越大差异越大)';
create table rendata.RN_ASSIGN_BATCH_RECORD
branch_code VARCHAR2(10) not null,
due_month DATE not null,
batch_code VARCHAR2(20) not null,
batch_seq VARCHAR2(20),
finish_flag VARCHAR2(1),
pk_serial VARCHAR2(20) not null,
created_user VARCHAR2(100) not null,
created_date DATE default sysdate not null,
updated_user VARCHAR2(100) not null,
updated_date DATE default sysdate not null
comment on table rendata.RN_ASSIGN_BATCH_RECORD
is '机构分单批次申请记录表';
-- Add comments to the columns
comment on column rendata.RN_ASSIGN_BATCH_RECORD.due_month
is '应缴月';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.batch_code
is '批处理代码';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.batch_seq
is '批处理流水';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.finish_flag
is '完成状态';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.pk_serial
is '数据主键';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.created_user
is '录入人';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.created_date
is '录入日期';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.updated_user
is '修改人';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.updated_date
is '修改日期';
create table appdata.SLIS_BATCH_PROC_ERROR_RECORD
(
sequence VARCHAR2(20) not null,
proc_code VARCHAR2(4),
ctrl_no VARCHAR2(40),
ora_error_code NUMBER(6),
error_message VARCHAR2(300),
operating_user VARCHAR2(100),
operating_date DATE,
sid NUMBER,
serial NUMBER,
branch_code VARCHAR2(10)
)
comment on table appdata.SLIS_BATCH_PROC_ERROR_RECORD
is 'SLIS系统批处理出错信息表';
-- Add comments to the columns
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.sequence
is '流水号-用于对应执行信息表数据';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.proc_code
is '批处理代码';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.ctrl_no
is '出错控制号';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.ora_error_code
is 'ora出错代码';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.error_message
is '出错信息';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.operating_user
is '操作执行用户';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.operating_date
is '操作执行时间';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.sid
is '运行该JOB的SID';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.serial
is 'SID对应的SERIAL#';
comment on column appdata.SLIS_BATCH_PROC_ERROR_RECORD.branch_code
is '机构代码';
select sbp.sequence,sbp.proc_code,sbp.branch_code,sbp.create_user,sbp.create_date,sbp.parameters,sbp.proc_flag,sbp.start_date,sbp.end_date
from SLIS_BATCH_PLAN sbp
where sbp.branch_code='865109'
and sbp.proc_code='R113'
and sbp.sequence='20150000000003992071'
and sbp.start_date
and sbp.end_date
;