質問編集履歴
1
質問更新
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -10,11 +10,39 @@
|
|
|
10
10
|
|
|
11
11
|
```ここに言語を入力
|
|
12
12
|
|
|
13
|
+
■実行ユーザの権限 srdcsユーザ
|
|
14
|
+
|
|
15
|
+
srdcs04% env
|
|
16
|
+
|
|
17
|
+
USER=srdcs
|
|
18
|
+
|
|
19
|
+
LOGNAME=srdcs
|
|
20
|
+
|
|
21
|
+
HOME=/export/home/srdcs
|
|
22
|
+
|
|
23
|
+
PATH=/bin:/usr/bin:/usr/ucb:/etc:.:/usr/sfw/bin/gcc:/export/home/srdcs/embulk_test/bin/embulk
|
|
24
|
+
|
|
25
|
+
MAIL=/var/mail//srdcs
|
|
26
|
+
|
|
27
|
+
SHELL=/bin/csh
|
|
28
|
+
|
|
29
|
+
TZ=Japan
|
|
30
|
+
|
|
31
|
+
LANG=ja
|
|
32
|
+
|
|
33
|
+
TERM=xterm
|
|
34
|
+
|
|
35
|
+
DISPLAY=localhost:14.0
|
|
36
|
+
|
|
37
|
+
PWD=/export/home/srdcs
|
|
38
|
+
|
|
39
|
+
|
|
40
|
+
|
|
13
41
|
■crontab設定
|
|
14
42
|
|
|
15
43
|
|
|
16
44
|
|
|
17
|
-
|
|
45
|
+
srdcs04% crontab -l
|
|
18
46
|
|
|
19
47
|
|
|
20
48
|
|
|
@@ -24,7 +52,7 @@
|
|
|
24
52
|
|
|
25
53
|
■シェルスクリプト
|
|
26
54
|
|
|
27
|
-
|
|
55
|
+
srdcs04% cat /export/home/xxxxxx/embulk_test/sh/bulkinsert_T_RS_TRAN.sh
|
|
28
56
|
|
|
29
57
|
#
|
|
30
58
|
|
|
@@ -108,7 +136,7 @@
|
|
|
108
136
|
|
|
109
137
|
echo "Embulk command Error T_RS_TRAN_TABLE" >> ${mail_T_RS_TRAN_file}
|
|
110
138
|
|
|
111
|
-
${MAIL_CMD} -f embulk_
|
|
139
|
+
${MAIL_CMD} -f embulk_srdcs04@jp.xxxxx.com ${ADDR} < ${mail_T_RS_TRAN_file}
|
|
112
140
|
|
|
113
141
|
exit 1
|
|
114
142
|
|
|
@@ -144,7 +172,7 @@
|
|
|
144
172
|
|
|
145
173
|
echo "Embulk Log Error T_RS_TRAN_TABLE" >> ${CHECK_T_RS_TRAN_LOG}
|
|
146
174
|
|
|
147
|
-
${MAIL_CMD} -f embulk_
|
|
175
|
+
${MAIL_CMD} -f embulk_srdcs04@jp.xxxxx.com ${ADDR} < ${mail_T_RS_TRAN_file}
|
|
148
176
|
|
|
149
177
|
exit 1
|
|
150
178
|
|
|
@@ -184,7 +212,7 @@
|
|
|
184
212
|
|
|
185
213
|
■実行結果
|
|
186
214
|
|
|
187
|
-
|
|
215
|
+
srdcs04% tail -f check_T_RS_TRAN.log
|
|
188
216
|
|
|
189
217
|
=====================
|
|
190
218
|
|
|
@@ -198,11 +226,11 @@
|
|
|
198
226
|
|
|
199
227
|
■cronの権限
|
|
200
228
|
|
|
201
|
-
|
|
229
|
+
srdcs04% ls -ltrh /var/spool/cron/crontabs
|
|
202
|
-
|
|
203
|
-
|
|
204
|
-
|
|
230
|
+
|
|
231
|
+
|
|
232
|
+
|
|
205
|
-
-rw------- 1 root xxxxxx 1.2K 3月 5日 15:20
|
|
233
|
+
-rw------- 1 root xxxxxx 1.2K 3月 5日 15:20 srdcs
|
|
206
234
|
|
|
207
235
|
|
|
208
236
|
|