1、map-sys-ig-系統(tǒng)安裝指導(dǎo)-b 安裝工作流提醒郵件定期發(fā)送項(xiàng)目名稱：map應(yīng)用框架map作者說明日期版本mike2013-10-11.0概述2前提2安裝步驟2設(shè)置數(shù)據(jù)庫郵件配置文件2建立定期發(fā)郵件任務(wù)3建立定期重置工作流提醒郵件的任務(wù)5啟動(dòng)工作流提醒郵件a動(dòng)發(fā)送7概述如需要發(fā)送t作流待辦和待閱的提醉郵件，可按木指導(dǎo)進(jìn)行設(shè)置。前提己安照安裝文檔系統(tǒng)安裝指導(dǎo)a.安裝基本模塊.docx安裝了基本模塊，并登陸系統(tǒng)能 正常使用。安裝步驟設(shè)置數(shù)據(jù)庫郵件配置文件1. 訪問mapdb所在的數(shù)據(jù)庫2. 點(diǎn)擊管理-數(shù)據(jù)庫郵件-添加-新建賬戶，配置文件名填寫sysmail m c管理s盤策bg®s

2、s逐數(shù)據(jù)收集資源凋控器田維護(hù)計(jì)劃s cjl sql server 日志a出分布式事務(wù)處理辦調(diào)器文件名稱、說明.黑戶和故障轉(zhuǎn)移優(yōu)先級(jí)。sn«ml口出文件名（說陰（s）：13遛文件將使用優(yōu)先級(jí)列裘中的下一個(gè)味戶。請(qǐng)指走與d®文件關(guān)莊的sttp 休戶（m）送/鼻涇加劉nds文件4>m戶休戶名（a）電子曲件地址他）照務(wù)22名稱（s）：3. 填寫用于在服務(wù)器端定期發(fā)郵件所用的郵件服務(wù)器和發(fā)件人賬戶信息，內(nèi)容應(yīng)和web服務(wù)器上的sendmailcmd.xml中的信息致建立定期發(fā)郵件任務(wù)1. 訪問mapdb所在的數(shù)據(jù)即服務(wù)器2. 啟動(dòng)sql scrvcrk理3. 建立作iksyss

3、endmailjob,腳本如下，推薦每隔10分鐘發(fā)送500條dbo.sysmail表屮的待 發(fā)郵件use msdbgo/* object: job syssendmail.jobscript date: 10/28/2013 14:15:04 */begin transactiondeclare sreturncode intselect sreturncode = 0/* object: jobcategory (data collector) script date: 10/28/2013 14:15:04 */if not exists (select name from msdbdbo

4、syscategories where name=n'data collector' and category_class=lbeginexec returncode - msdb.dbo.sp_add_category gclass-n1job*/ qtype-n*local', name-ndata collector1if (error <> 0 or ureturncode <> 0 goto quitwithrollbackenddeclare jobld binary(16)exec returncode = msdb dbo.sp_

5、add_job job_name=n'syssendmail_job1zenabled=lrnotify_level_eventlog=oznotifylevel_email=0,notify_level_netsend0,notify_level_page=0rdeletelevel=0fdescription=n1 無描述。1 /category_name=n1 data collector'/owner_login_name-n1sar job_id - jobld outputif (error <> 0 or ureturncode <> 0)

6、 goto quitwithrollback/* object: step stepl script date: 10/28/2013 14:15:04 */exec returncode = msdbdbosp_add_jobstep q job_id=jobld, step_name=n* stepl'/step_id-l/cmdexec_success code-0ron_success_action-lzon_success_step_id=0zon_£ail_action=2,on_fail_step_id-0,retry attempts-0,retry_inte

7、rval=0,os_run_priority=0r subsystem=n'tsql'.command=n * beginbegin transactionexec dbosyssendmail 500commit.end* rdataba$e_name=n1mapdb'/ flags-0(error <> 0or returncode <>0)goto quitwithrollbackexec returncode= msdbdbosp_update_job 0job_idjobld, start_step_idif (error <&g

8、t; 0or gretur“code <> 0)goto quitwithrollbackexec 0returncodemsdb dbo sp_add_jobschedulejob_id= jobid,name=n'schedulel1 /enabled-lr freq_type=4,f req_in, f re jsubday_t ype=4,req_subday_interval-10rfreq_relative_interval-oxfreq_recurrence_factor=0zactive_start_date=20131001zact ive_end_dat

9、e = 99991231,act ive_sqactive_end_time-235959rschedule_uid=n'lf8b5ac4-b3ca-4el9-940a-bfb0c7516e68if error <> 0 or returncode <> 0) goto quitwithrollbackexec returncode = msdbdbosp_add_jobserver job_id = 0jobld/ server_name = n' (local)if (error <> 0 or sreturncode <>

10、0) goto quitwithrollbackcommit transactiongoto endsavequitwithrollback:if (trancount > 0) rollback transactionendsave:建立定期重置工作流提醒郵件的任務(wù)1. 訪問mapdb所在的數(shù)據(jù)庫服務(wù)器2. 啟動(dòng)sql server理3. 建立作業(yè)wfmailreset.job,腳本如下，推薦每天凌晨1:00重置一次未處理的工作流 提醒郵件use msdbgo/* object: job (wfmailreset_jobscript date: 10/28/2013 14:13:11

11、*/begin transactiondeclare sreturncode intselect sreturncode = 0/* object: jobcategory (data collector) script date： 10/28/2013 14:13:11 */if not exists (select name from msdb.dbo.syscategories where name=n*data collector' and category_class=l)beginexec returncode = msdbdbosp_add_category class=

12、n,job', qtype=n'local', name=n1 data collector'if (error <> 0 or returncode <> 0 goto quitwithrollbackenddeclare jobld binary(16)exec returncode - msdbdbosp_add_job job_name-n*wfmailreset_job*,enabled-lrnotify_level_eventlog=orgnotifylevel_email=oznot ifylevel_not ify_lev

13、el_page=0/gdelete_level-ozdescription=n11zcategory_name=n1 data collector',owner_login_name=n'sa1z job_id = jobld outputif (error <> 0 or returncode <> 0) goto quitwithrollback/* object: step stepl script date: 10/28/2013 14:13:11 */exec returncode = msdbdbo.sp_add_jobstep job_id

14、=jobld, step_name=n'stepl',step_id=lrcmdexec_$uccess_code=0/on_success_action=l,on_success_step_id-o,on_fail_action=2<on_fail_step_id=orretry_attempts=o,retry_interval-0,os_runpriority-oz (jsubsystem-n1 tsql*,command-n'exec dbowfmailreset',databasq_narw=n 'mapdb',flag$=0if

15、 (terror <> 0or qreturncode <> 0) goto quitwithrollbackexec (jreturncode-msdbdbosp_update_job job.id 6jobld, start_step_id 1if (terror <> 0or returncode <> 0) goto quitwithrollbackexec returncode= msdbdbosp_add_jobschedule (?job_id=jobld, name=nrdaily1,enabled=l/req_type-4,qf

16、req_interval-lr req_subaay_type-lrf req_subday_interval=orf req_relative_interval=0,req_recurrence_factor-0/active_start_date=20131001ractive_end_date=99991231,act ive_start_time=10000.act ive_end_time=235959,schedule_uid-n'7fbfcd0f-d4ca-4c22-9d31-ca5963d81edd*if (terror <> 0 or returncode

17、 <> 0) goto quitwithrollbackexec returncodg = msdbdbosp_add_jobseever job_id = jobld, server_name = n (local)if (error <> 0 or returncode <> 0 goto quitwithrollbackcommit transactiongoto endsavequitwithrollback:if (00trancount > 0) rollback transactionendsave:go啟動(dòng)工作流提醒郵件自動(dòng)發(fā)送1. 在任一web服務(wù)器使用sa登錄系統(tǒng)，打開應(yīng)用圖標(biāo)工作流管理2. 點(diǎn)擊菜單提醒郵件