DispatcherV2 库
表名 | 说明 | 备注 |
Dispatcher | 调度工具配置表 | |
DispatcherProgress | ||
DispatcherRuntime | 调度工具执行时间表 | |
DispatcherRuntimeHistory | 调度工具执行历史表 | |
Worker | 调度执行表 | 重要步骤3 |
WorkerCancellation | ||
WorkerHistory | 调度执行历史表 | 重要步骤4 |
WorkerProgress | ||
WorkerQueue | 调度对列表 | 重要步骤 2 |
WorkerSchedule | 调度计划一览表 | |
WorkerTemplate | 调度模板表 | 重要1 |
调度解析以及执行过程
1 读取当前所在的Dispatcher组,
2.读取 WorkerTemplate 表 产生调度队列 到 WorkerQueue表,
3.然后 根据配置的 多线程任务调度数, 分配调度到 Worker 表,(WorkerQueue 的对应数据 做移出)然后 由调度执行工具执行.
4.执行成功后,记录转移到 WorkerHistory
字段及类型列表
1 ------Dispatcher()
2 ID int(10)
3 DispatcherGroupID nvarchar(100)
4 DispatcherID nvarchar(100)
5 DispatcherApplication nvarchar(1000)
6 DispatcherStatus nvarchar(100)
7 MaxDOP int(10)
8 MaxQueueLength int(10)
9 MinQueueLength int(10)
10 WorkerAddIn nvarchar(-1)
11 Debug int(10)
12 DispatcherData nvarchar(-1)
13 DispatcherRuntimeData nvarchar(-1)
14 DispatcherQueryWorkerMaxInterval int(10)
15 DispatcherCheckAliveTimeout int(10)
16 CreateTime datetime(23)
17
18 ------DispatcherProgress()
19 ID int(10)
20 DispatcherID nvarchar(100)
21 DispatcherProgressType nvarchar(100)
22 Message nvarchar(-1)
23 DispatcherRuntimeID nvarchar(100)
24 LogTime datetime(23)
25
26 ------DispatcherRuntime()
27 ID int(10)
28 DispatcherID nvarchar(100)
29 MachineName nvarchar(100)
30 DispatcherRuntimeID nvarchar(100)
31 DispatcherState nvarchar(-1)
32 LastCheckAliveTime datetime(23)
33
34 ------DispatcherRuntimeHistory()
35 ID int(10)
36 DispatcherID nvarchar(100)
37 MachineName nvarchar(100)
38 DispatcherRuntimeID nvarchar(100)
39 Action nvarchar(100)
40 UpdateTime datetime(23)
41
42 ------Worker()
43 ID int(10)
44 WorkerID nvarchar(100)
45 WorkerName nvarchar(100)
46 WorkerGroupID nvarchar(100)
47 DispatcherID nvarchar(100)
48 DispatchTime datetime(23)
49 BeginTime datetime(23)
50 FinishTime datetime(23)
51 WorkerStatus nvarchar(100)
52 Priority int(10)
53 WorkerMode nvarchar(100)
54 Retry int(10)
55 Timeout int(10)
56 Wait int(10)
57 IgnoreError int(10)
58 WorkerDependancy nvarchar(1000)
59 Parameter nvarchar(-1)
60 DynamicParameter nvarchar(-1)
61 DynamicParameterExecuted bit(1)
62 WorkerData nvarchar(-1)
63 Message nvarchar(-1)
64 WorkerRuntimeID nvarchar(100)
65 DispatcherRuntimeID nvarchar(100)
66 BatchID nvarchar(100)
67 Debug int(10)
68 CreateTime datetime(23)
69 ApplicationName nvarchar(100)
70 Owner nvarchar(100)
71
72 ------WorkerCancellation()
73 ID int(10)
74 WorkerID nvarchar(100)
75 Termiate bit(1)
76 Message nvarchar(-1)
77 RequestTime datetime(23)
78
79 ------WorkerHistory()
80 ID int(10)
81 WorkerID nvarchar(100)
82 WorkerName nvarchar(100)
83 WorkerGroupID nvarchar(100)
84 DispatcherID nvarchar(100)
85 DispatchTime datetime(23)
86 BeginTime datetime(23)
87 FinishTime datetime(23)
88 WorkerStatus nvarchar(100)
89 Priority int(10)
90 WorkerMode nvarchar(100)
91 Retry int(10)
92 Timeout int(10)
93 Wait int(10)
94 IgnoreError int(10)
95 WorkerDependancy nvarchar(1000)
96 Parameter nvarchar(-1)
97 DynamicParameter nvarchar(-1)
98 DynamicParameterExecuted bit(1)
99 WorkerData nvarchar(-1)
100 Message nvarchar(-1)
101 WorkerRuntimeID nvarchar(100)
102 DispatcherRuntimeID nvarchar(100)
103 BatchID nvarchar(100)
104 Debug int(10)
105 CreateTime datetime(23)
106 ApplicationName nvarchar(100)
107 Owner nvarchar(100)
108
109 ------WorkerProgress()
110 ID int(10)
111 WorkerIdentity int(10)
112 WorkerID nvarchar(100)
113 WorkerProgressType nvarchar(100)
114 WorkerStatus nvarchar(100)
115 Message nvarchar(-1)
116 WorkerRuntimeID nvarchar(100)
117 DispatcherRuntimeID nvarchar(100)
118 LogTime datetime(23)
119
120 ------WorkerQueue()
121 WorkerQueueID int(10)
122 WorkerID nvarchar(100)
123 WorkerName nvarchar(100)
124 WorkerGroupID nvarchar(100)
125 DispatcherID nvarchar(100)
126 DispatchTime datetime(23)
127 BeginTime datetime(23)
128 FinishTime datetime(23)
129 WorkerStatus nvarchar(100)
130 Priority int(10)
131 WorkerMode nvarchar(100)
132 Retry int(10)
133 Timeout int(10)
134 Wait int(10)
135 IgnoreError int(10)
136 WorkerDependancy nvarchar(1000)
137 Parameter nvarchar(-1)
138 DynamicParameter nvarchar(-1)
139 DynamicParameterExecuted bit(1)
140 WorkerData nvarchar(-1)
141 Message nvarchar(-1)
142 WorkerRuntimeID nvarchar(100)
143 DispatcherRuntimeID nvarchar(100)
144 BatchID nvarchar(100)
145 Debug int(10)
146 CreateTime datetime(23)
147 ApplicationName nvarchar(100)
148 Owner nvarchar(100)
149
150 ------WorkerSchedule()
151 ID int(10)
152 WorkerID nvarchar(100)
153 EffectivityTime datetime(23)
154 ExpirationTime datetime(23)
155 FrequencyType nvarchar(100)
156 FrequencyInterval int(10)
157 DailyTimeOnce time(16)
158 DailyHourInterval int(10)
159 DailyMinuteInterval int(10)
160 DailyTimeWindow nvarchar(100)
161 CreateTime datetime(23)
162
163 ------WorkerTemplate()
164 WorkerID nvarchar(100)
165 WorkerName nvarchar(100)
166 WorkerGroupID nvarchar(100)
167 DispatcherID nvarchar(100)
168 Priority int(10)
169 WorkerMode nvarchar(100)
170 Retry int(10)
171 Timeout int(10)
172 Wait int(10)
173 IgnoreError int(10)
174 WorkerDependancy nvarchar(1000)
175 Parameter nvarchar(-1)
176 DynamicParameter nvarchar(-1)
177 WorkerData nvarchar(-1)
178 Debug int(10)
179 CreateTime datetime(23)
180 ApplicationName nvarchar(100)
181 Owner nvarchar(100)
View Code
