\u4fdd\u5b88\u76e3\u8996\u7b49\u3067\u3001\u3088\u304f\u5229\u7528\u3059\u308b\u306e\u3060\u304c\u6bce\u56de\u5fd8\u308c\u308b\u306e\u3067\u5099\u5fd8\u9332\u7684\u306b\u3002<\/p>\n
CRON\u3067\u6bce\u65e5\u304a\u663c\u306e\uff11\uff12\u6642\u306b\u5b9f\u884c\u3059\u308b\u30b5\u30f3\u30d7\u30eb
\n[bash]
\n0 12 * * * bash \/path\/to\/dir\/hogefuga_report.sh
\n[\/bash]<\/p>\n
sendmail\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3001SQL(postgresql)\u3092\u5b9f\u884c\u3057\u3066\u7d50\u679c\u3092\u30e1\u30fc\u30eb\u9001\u4fe1\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u30b5\u30f3\u30d7\u30eb
\nhogefuga_report.sh
\n[bash]
\n#!\/bin\/sh<\/p>\n
#### \u6c4e\u7528\u30e1\u30fc\u30eb\u9001\u4fe1\u30b9\u30af\u30ea\u30d7\u30c8
\nexport PATH=$PATH:\/usr\/sbin
\nexport PGPASSWORD=naisyodayo<\/p>\n
NOWDATE=`date ‘+%m\u6708%d\u65e5 %R ‘`<\/p>\n
HOGE_CNT=`psql -U postgres -d dev –tuples-only -c ‘select count(*) as hoge_cnt from hogehoge_tbl’`
\nFUGA_CNT=`psql -U postgres -d dev –tuples-only -c ‘select count(*) as fuga_cnt from fugafuga_tbl’`
\nHOGE_CNT=`echo ${HOGE_CNT} | tr -d ” “`
\nFUGA_CNT=`echo ${FUGA_CNT} | tr -d ” “`<\/p>\n
MAIL_TO=”hogeko@hoge.com.jp”
\nMAIL_CC=”fugasuke@fuga.com.jp”
\nMAIL_BCC=”pekeo@peke.com.jp”
\nMAIL_FROM=”ore@oresama.com.jp”
\nSUBJECT=”\u4ffa\u69d8\u306e\u30ec\u30dd\u30fc\u30c8”
\nDATA=”\u4ffa\u69d8\u306e\u53cd\u97ff\u7d50\u679c\u306f\u4ee5\u4e0b\u3068\u306a\u308b”<\/p>\n
mail_send () {
\ncat << EOD | sendmail -t
\nFrom: ${MAIL_FROM}
\nTo: ${MAIL_TO}
\nCc: ${MAIL_CC}
\nBcc: ${MAIL_BCC}
\nSubject: ${SUBJECT}
\nMIME-Version: 1.0
\nContent-Type: text\/plain; charset=”UTF-8″<\/p>\n
\u4ffa\u69d8\u3078<\/p>\n
\u4eca\u65e5\uff08${NOWDATE}\uff09\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u9001\u308b\u306e\u3067\u3088\u304f\u898b\u308b\u3053\u3068\u3002<\/p>\n
${DATA}<\/p>\n
\u30fb\u307b\u3052\u6570
\n${HOGE_CNT}<\/p>\n
\u30fb\u30d5\u30ac\u6570
\n${FUGA_CNT}<\/p>\n
\u4ee5\u4e0a<\/p>\n
EOD
\n}<\/p>\n
mail_send<\/p>\n
exit 0
\n[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4fdd\u5b88\u76e3\u8996\u7b49\u3067\u3001\u3088\u304f\u5229\u7528\u3059\u308b\u306e\u3060\u304c\u6bce\u56de\u5fd8\u308c\u308b\u306e\u3067\u5099\u5fd8\u9332\u7684\u306b\u3002<\/p>\n
CRON\u3067\u6bce\u65e5\u304a\u663c\u306e\uff11\uff12\u6642\u306b\u5b9f\u884c\u3059\u308b\u30b5\u30f3\u30d7\u30eb [bash] 0 12 * * * bash \/path\/to\/dir\/hogefuga_report.sh [\/bash]<\/p>\n
sendmail\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3001SQL(postgresql)\u3092\u5b9f\u884c\u3057\u3066\u7d50\u679c\u3092\u30e1\u30fc\u30eb\u9001\u4fe1\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u30b5\u30f3\u30d7\u30eb hogefuga_report.sh [bash] #!\/bin\/sh<\/p>\n
#### \u6c4e\u7528\u30e1\u30fc\u30eb\u9001\u4fe1\u30b9\u30af\u30ea\u30d7\u30c8 export PATH=$PATH:\/usr\/sbin export PGPASSWORD=naisyodayo<\/p>\n
NOWDATE=`date ‘+%m\u6708%d\u65e5 %R ‘`<\/p>\n
HOGE_CNT=`psql -U postgres -d dev –tuples-only -c ‘select count(*) as hoge_cnt from hogehoge_tbl’` FUGA_CNT=`psql -U postgres -d dev –tuples-only -c ‘select count(*) as fuga_cnt from fugafuga_tbl’` HOGE_CNT=`echo ${HOGE_CNT} | tr […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-399","post","type-post","status-publish","format-standard","hentry","category-centos","odd"],"_links":{"self":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts\/399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=399"}],"version-history":[{"count":8,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts\/399\/revisions"}],"predecessor-version":[{"id":409,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=\/wp\/v2\/posts\/399\/revisions\/409"}],"wp:attachment":[{"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tkn.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}