c FA!Lmsdb d'j4a>I+bOnuQ R>I+bOnuQA!L@2 }{E^Qi0/.~~.2<<JZZZZZZZjjjt~0c-HVh9:@ @;qOJ=Qү&MSDBLogA!Lmsdb d'jP4a>I+bOnuQ R>I+bOnuQA!L@2 }{E^QiA!Lmsdb d'jh4a>I+bOnuQ R>I+bOnuQA!L@2 }{E^Qi@A!Lmsdb d'jh4a>I+bOnuQ R>I+bOnuQA!L@2 }{E^Qi|j #KP jZp0`i͞#LiR5-=i^Ci$DjEj Fj Gj Hj  Ij :Jj  Kj  Lj  Mj Nj Oj Pj QjRjSjTjUj VjWj XjYjZj[j\j]j^j_j `j!aj"JII8HhGFED(DXCBA@@H?x>=<<8;h:987(7X65433H2x10H0(@@Pj8)jΞ#Lj(@@@@@@@Fj@C@3Ξ#LFileSize>j@i @  aj@@j@i%pj@Ξ#L(@@@@@@@bjHs0j@Ξ#Lj@(@@@@@@@" jPo`j #Lj5-=jCj#DjPEjP FjP GjP HjP IjP ;Jj  KjP  LjP  MjP  NjP OjP PjP QjPRjPSjPTjPUjP VjPWjP XjPYjPZjP[jP\jP]jP^jP_jP`jP ajP!Hx8h(X  H x 8h(X(P j`WjP #LjP(jh]!1`jP #L(>j@i @  aj@@j@i%pj@Ξ#L(jpWjh #Ljh(@`MSh-%bhJEfh-%b$kW$kȃc$kWl`MSlȃcl`MS2 mȃc2 mW 2 mȃc/Ps-%b/Psgq/Ps-%bh@Dtgkh@Dtgqh@Dtg@(Xvu(x˿w(<8zy(u\{(|<1`1t aJ1` tab>1`2taJ1`2f bles r>1`3tJ1`)J_rNR01`,t/"L1`,* FROM>1`pmJ1`1J@ (aa` J A)ELSE >1`6pcJ1`Jnsa`(aem J F NOT N1`7p  a`1`8p  a`>1`9p'E"1`" il a " & 9_q1`:p  a`>1`;p&)0U)Aab0-a00@Astatuslt_ ) JF(@att>1`<p)/)y 6astatusen ) qV 1`=p  a`>1`>p')1`<)Ets0-a00EpriorityND  ) nduݼ >1`?p )/)" t6a"priorit@ @ ) ^4X|a 1`@p  a`>1`Ap()1`?)O 0-aOqueuing_orderh ) 8 >1`Bp8)1`@),ch6a,queuing_order ) e = 1) 1`Cp  a` 1`Dpa 211`Ep aibit@>1`Fp()1`B)00OQaat ) 8 BOQj  EXE1`Gp  a`>1`Hp))1`G)_ 0-a$$_conversation_group_id_ ) 8kTRE>1`Ipu)/)< 6a<convers@tion_group_id ) $u)0Me_uid)1`Jp  a`>1`Kp*)1`I)[ N0-a$$[conversation_handle  ) VSme >1`Lpz)1`J)8 h6a8conversation_handle ) 'w%)id1`Mp  a`>1`Np+@1`L)c, 0-acmessage_sequence_number  ) }suu >1`Op)*)@_f6a@message_sequence_number ) X4zre1`Pp  a`>1`Qp,)1`O)Iro0-a$$Imessage_id@,  ) Oyents, >1`Rp)1`P)&bj6a&message_idma ) ϷJe,1`Sp  a`>1`Tp-)1`R)Sab0-a88 Smessage_type_id@ ) a >1`Up )1`S)0 6a0message_type_id@ ) ta:hre1`Vp  a`>1`Wp.)1`U)I 0-a 88 Iservice_idhe  ) ?xIQueryR>1`Xp,)/ )&t 6a &service_id  ) Ct 1`Yp  a`>1`Zp/)1`X)[is0-a 88 @[service_contract_ide ) ߸Vy/RITE(@>1`[p()1`Y)8Co6a 8service_contract_id ) ĘҒod1`\p  a`>1`]p0)1`[)IRE0-a Ivalidation ta ) &=h#tsExis>1`^p ).`%@)&nt6a &validationtt ) z̢fi1`_p  a`>1``p1)1`^)Oil0-a 88 Onext_fragmentr )  gVml>1`aps'). ),//6a ,next_fragment ) N @1`bp  a`>1`cp@2)1`a)O 0-a 88 Ofragment_size ) aZ>1`dp{)/),6a ,fragment_size ) u_W`t1`ep  a`>1`fp3)1`d)S0-aSfragment_bitmap ) O@>0>1`gpx)1`e)01/6a0fragment_bitmap ) ;9lat1`hp  a`>1`ip4)1`g)[It0-a@[binary_message_bodyq ) $ -- S>1`jp-)1`M)8ma6a8binary_message_body@ ) .{ai>1`kp'E"1`:"f rquia " & 9tp>1`lp;/3> 9ya+1d1e   :?VKe 1`mp  y> c1` >1`np8/XM--Iy@ TRA  &R4W-->1`pp5/+: yet  ?bUw t> c1`ochme>1`qp91`pM= Iy d   ]git>1`sp51@qenyo   ̨.tE>1`tp+/(>RA:y0c)  (>1`up,1`u>:y$  /̧7K>1`vp-1`v>:y0@i  c0G)>1`wp.1`w>:y$   F2>1`xp/1`x>:y&#p  * .[>>1`yp01`y>:y.) @ >ա>1`zp11`z>^:y$6i  3r6z)>1`{p21`{>:y8Ft  tFhF>1`|p31`|>:y 8J b  C8$de>1`}@41`}>:y 8N   gy>1`~p51`~>:y R   Z@<>1`p61`>:y 8T   bec>1`p71`@>:y 8X   )" b>1`p81`>:y\   {>1`p91`>:y@_  Q:*)> c1`r@>1`p:1`sMIy ^  nH)Һ>1`p51`ty  Hju$1`py>1`p)6/x96Y0'a y Yqueue_clustered_index @6 sj ivi>1`p}6/.6:6a:queue_clustered_indexs 6 0 J)>1`p7//7a 7 +{N>1`pR7187a 7 r$aN@u3/"LBnSpli@Page M*>1`u 71`-c`>1`u 72@@1`u7P1`u7;>1`u71`@@-%b-%bȃctȃceȃcȃcȃcȃcȃcacJEf_aJEf gkgqgqXvrXv@ XvXvXv XvXvryXvleXvtXvXv xxex)xxx^x@xesx)xx <8z<8zu<8z<8z<8z<8z^<8z<8zes<8z<8z<8z =z@u\{uu\{ u\{u\{u\{u\{u\{t_u\{u\{|||u|)~<1`u 71`@>^>1`u71`out>1`u787-%b@801`u/"L1`utp>1`p71`7aM 7 ˢUF6>1`pS71`7 a 7 mC7>1@p71`7par 7 2>>1`pT71`7na 7 80>1`p71`7a( 7 X>1`pU71`7a" 7 xRF/>1`p@71`7a@q 7 bZ_>1`pV71`7a 7 }w>1`p<.0E<" 0<a " < k:0$1`py^>1`p;1`m + )y  :?V@>1`p<1`>a9za)/5/5  y01`p  z> c1`R>1`p;1`MIz   q]C|>1`p51@ z   Sŗ>1`p:1`>:z0   :A>1`p;1`>:z0  7%+>1`p<1`>:z@  B>1`p=1`>v:z$    g; >1`p>1`>:z$  +G>1`p?1`>:z8++ @ #49$1`pz>1`p*61`6Y0'a z Yqueue_secondary_index 6 :)EK>1`p}61`6: 6a:queue_secondary_index 6 թBM^>1`p71`7a@ 7 P>1`pS71`7a 7 XF o^>1`p71`7a 7 u>1`pU71`7a 7 Y-^>1`p71`7a 7 @q>1`pW71`7a 7 + g^>1`p71`7a8 7 ቑk>1`pY71`7a 7 fh^^>1`p71`7a  7 >1@p[71`7a 7 T3Sʾ^>1`p71`7a  7 s1`p\71`7a  7 &fф^>1`p<1`<"0<a " < \Xe >1`@'E"1`l"$Ka " & 9$1`pz0>1`p<1` ) z  y0l_m01`p/"L1`K}|`|{h{zpzyxyyxxwwvvut8ttpsr0rqpPpo(onnnmhmlhlkpkjxjiiihhhhgP_^^`^^]8]\\X[0[ZZYYpXW0WVUPUTTpSR0RQPPPO(ONXNMPM(MLLKJJJPI(IHGG0GFXFE ED`DHCxCB@BBA@@ @p?H?>== =`<8<;:::9998H8 8766H65x5544@4330322"("!!@! H ` x@P8(H@`p@PPx(^% K h@YXHX>0rUzK0qK(H%^PC K ħ==0=>c/'22 0/p``K`tp`%)aykbrf uT_d s0Pcp1+> c1`(1v"/`"Vs0,1v"/ "@&1v"/C"0:&1vz!"1`" 1v<1`<V0 1vqJ1`6J1 vcJ1`7J1 v"1" c1(ucd1 v  @uc>1 v"1 "f 0,ucIT1v#"1`"@1)&uc@queue_messages_1659152956 " b/kFal>1v*"1`"@0 &uc@queue_messages_1659152956 "@ Mi>1vz"1" db1vrJ1 J (uc1vcJ1 J 1v"1"@par metuc " ԭ 1v  1vQ )0x)Ag 0-uc00AstatuslIn ) \N,loggin>1v)1`=)= 6ucstatusLe ) Gftӯ @1v  1vQ )1)EDB0-uc@00Epriorityysm ) #I, >1v )1`C)"el6uc"priority  ) hSR FORMA1v  1vQ )1)OEN0-ucOqueuing_order  ) Eool_>1v:)1), @uc,queuing_order ) &P(o1v  1"vQ )1)00OQuc ) EooKOQj1#v  1$vQ )1#)_0-uc$$@_conversation_group_id ) }JW=>1%vw)1`k)<6uc<conversation_group_id ) 2G L1&v  1'vQ )1%)[ 0-uc$$[conversation_handle ) & >1(v}@1&)86uc8conversation_handle ) 䨉b1)v  1*vQ)1()c0-uccmessage_sequence_number ) d2O"Yb>1+v)1`V)@_6uc@message_sequence_number ) @=->1,v  1-vQ)1+)Ic0-uc$$Imessage_id ) ~U0>1.v)1,)&a6uc&message_idb ) $ 1/v  10vQ)1.)Sy0-uc88 @Smessage_type_id ) x](>11v )1/)0ry6uc0message_type_id ) Bber12v  13vQ)11)I0-uc 88 Iservice_id ) 40>14v.)1`\)&6uc @&service_idH ) X"ލ15v  16vQ)14)[0-uc 88 [service_contract_id ) E0>17v))15)86uc 8service_contract_id ) >18v  19vQ@17)I0-uc Ivalidation> ) L?>1:v)1`_)&6uc &validation ) ?a[1;v  1<vQ)1:)O0-uc 88 Onext_fragment  ) i[Sz>1=@s()1`b),6uc ,next_fragment ) ݾ1>v  1?vQ)1=)O0-uc 88 Ofragment_size  ) 5%̶v>1@v})1`h),6uc ,fragment_size ) CL̪61Av@  1Cw )1`c-"@@1Dw)P1Ew)Q-R7\>1Fw)1FNKQ[CMCIISWOCESOEKGGO]]YYCKkMKQ_MaCGIKKWOQ??ICGOEGOMU@_UQ_[MMMYQKEc_MYMQAK[QM0-Bd4K@login_name0-Bd4Q@database_name 0-Bd4[@database_user_name0-7e$$C@job_idp0-7e4M@server_name0-;++f$$C@job@_id0-JEf88 Iprofile_id@0-JEf88 Iaccount_id0-JEf88 Ssequence_number0-JEf==iWlast_mod_datetime0-JEf4.ֺjOlast_mod_user0-tOg$$C@job_id0-tOg88 @E@step_id4w0-tOg88 S@sql_message_id0-tOg88 O@sql_severity0-tOg@4E@message0-tOg88 K@run_status0-tOg88 G@run_datek0-tOg88 G@run_time0-tOg 88@ O@run_duration0-tOg 88 ]@operator_id_emailed0-tOg 88 ]@operator_id_netsenti0-tOg 88 Y@operator_id_pagedc0-tOg 88 Y@retries_attemptedt0-tOg4C@server0-@Og88 K@session_id0-sh88 k@required_microsoft_version0-i4M@server_name0-i4K@local_time0-i88 Q@poll_interval_0-i88 _@time_zone_adjustmen@ts0-i4M@server_name_0-i88 a@adjustment_in_minutesa0-Xj$$C@job_id0-Xj4G@job_name0-gk4IservertypeJy0-gkhhBmKis_incoming0-gkhh@gnKis_outgoing0-gk==KoWlast_mod_datetime0-gk4spOlast_mod_user0-k4Q@target_server0-(l4?@seed0-Mm4?@name0-MmP4I@subsystem0-Mm@4C@server0-Mm4G@username0-Mm4O@databasenameX0-Mm00E@enabledg0-Mm88 G@freqtype0-Mm88 O@freqinterval0-Mm 88 M@freqsubtype0-@Mm 88 U@freqsubinterval0-Mm 88 _@freqrelativeinterval0-Mm 88 _@freqrecurrencefactor0-Mm 88 U@activestartdatey0-Mm88 Q@activeenddates0-Mm88 _@activ@estarttimeofday0-Mm88 [@activeendtimeofday0-Mm88 M@nextrundate0-Mm88 M@nextruntime@0-Mm88 M@runpriorityr0-Mm4Y@emailoperatorname0-Mm88 Q@r@etryattempts0-Mm88 K@retrydelay0-Mm4E@command0-Mm88 c@loghistcompletionlevel0-Mm88 _@emailcompletionlevel0-Mm4M@description0-Mm`4Y@tag@additionalinfoo_0-Mm88 M@tagobjectid0-Mm88 Q@tagobjecttype0-Mm88 A@newid0-Mmcc4K@parametersu0-Mm 88 [@cmdexecsuccesscode0-Mm!4Q@category_name@0-Mm"88 M@category_id <1Gw Q)1@L&n>1HwQ)1HR7\ >1IwR).Q0>1Jwo&)0x)Bdemp_01Cw/"L1C>0>1BvQ@1I)S 0-ucSfragment_bitmap ) Cr/>1Mvy)1A)06uc0fragment_bitmap ) w*.s1Nv  1OvQ)1M)[t0-uc@[binary_message_body )@ ,]ԗ-7\>1Pv.)1))8_6uc8binary_message_body ) 5'>1Qv"1"euuc " ԭ >1Rv=1`>9{uc+1d1  D1Sv  {> @1 >1Tv<1`M I{   7Ρ7>1Vv51`{  -Hy > c1U0>1Wv=1VM(@I{   38@,%>1Yv51W{  8+>1Zv@1`>:{0  zƽ>1[vA1[>:{$@  rNIy>1\vB1\>:{0  ޜr>1]vC1]>O:{$  'Wqh>1^vD1^>:{&#  Jk}@>1_vE1_>l:{.  _O>1`vF1`>x3:{$6  S4>1avG1a>l:{8F  ]+>1bvH@1b>:{ 8J )  #Y'>1cvI1c>:{ 8N   mE)>1dvJ1d>3 :{ R e  :!̗ >1evK1e@:{ 8T r  [)>1fvL1f>:{ 8X   HEe>1gvM1g>h:{\n  |CRa>1hvN1h>:{@@  0d^e> c1Xj>1iv>1YMeI{ A  2tL((>1kv51Ze{i  gE\$1lv{>1mv@6/x<6Yc0'uc { Yqueue_clustered_index) 6 >~-3 >1nv}61`6: 6uc:queue_clustered_index 6 4>1ov 71`7AucC 7 b,]>1pvf71`7@euc  7 1>.>1qv 71p7uc  7 Y>1rvg71q7uc 7 "0>1sv 71r7uc 7 {TE i>1tvh71s7@uc 7 O>1uv 71t7ucr 7 Cq|s>1vvi71u7ucl 7 ]Fr >1wv 71v7uc 7 =[5p >1xvj71w7uc@ 7 ңK>1yv<.D<"01{v=1S + qe{  D>1|v>1|>9|uc)/5/5  .z1}v@  |> c1jx>1~v?1kMI|     PПF>1v51l3|   qewq>1vO1i>:|0@  x+->1vP1>:|0  |L!a>1vQ1>:|  n>1vR1>:|$ y  @ %Y?>1vS1>:|$  Di2~>1vT1>:|8++  ]'X$1v|.>1v61n6Y30'uc | Yqueue_sec@ondary_index 6 ܱ/>1v}61o6:6uc:queue_secondary_index 6 b&`K>1v71x7uc  7 nVn?s>1vg71y7uc 7 }ySK>1v71@7uc  7 iZxZQ>1vi717uc 7 5/K>1v717uc  7 vV~>1vk717uc 7 nK>1v717@uc  7 3$r#>1vm717uc 7 ɉZ2K>1v717uc  7 QOh/R]>1vo717uc 7 q)K>1v717uc@   7 KaS>1vp717uc  7 XK>1v<1z<"01v"1R"$3uc " ԭ$1v|>1v>1}@ )K |  .z01v/"L13@baa0a`0`_8_^@^]H]\P\[X[Z8ZxYPYXXpWV0VUUhTTSHSRR RQ(QP0PO8ON@NMHMLKKHKJ@JII`HG GFE@EDD`CB BA@h@?`?>8>===<.`ygK.`xK3 ~ K jƋc4>.`zK.`yK~3  K MKuJ>.`{gK.`zK)3 ~ K 14o'>.`|K.`{K~3 d K Hf@cod>.`}gK.`|K3 ~ K @cm>.`~K.`}K~3  K rl\>.`gK.`~Kg3 ~ K #>'>.`K.`K!~3 e K m )>.@gK.`K3 ~ K )9>.`K.`K~3  K ZQy)>.`gK.`K3 ~ K ;5'>.`K.`K~3  K &1Sla >.`@K.`K&3 ~ K @>.`K.`K_~3  K Ge>.`gK.`Kۜ3 ~ K ;ї%ELf>.`K.`K~3  K djLog>.`+b)@-bN03  @@FNsysmail_mailitemsdbomsdbO b _>.`G)b).b< 63 6<sysmail_mailitemsdbo b (0.`"L.`(mlk`kjhjipihxhgggffeeddc cb(ba0a`8`_@_^H^]P]\X\[`[ZhZYpYXxXXWWVVUUT TS(SR0RQ@QPPpON8NMMXLKKxJI(IpHGGxFEEPDCBHBA@(@?>@>==H<;:p:98988P76065x554`4 4P#""h""`! p0Hx  h``x(C"6lu"C"6/b>c)t_v)n)6 0P xp1F@x3/"LB+]CREATE SERVICEt1x >1xQ:1P:U0'/"L/"L UInternalMailService.c : spm>1xS:1P:4 &4InternalMailService :@ +@_>1xJ1Jma` J *>.0>1xcJ1Ja` J "Gw>1xJ1J7 J X! >1xc9J1J7 J C~x"L@1x >1 xglK1PK K asE>1 xilK1PK K asE 01x/"L1(0x(@+5I+Z=+Z=+.v+~x+ syE':E':Ei<Ei<O=~1O=~1O.vO syt@v%tv%tv%t0st.vt.gzLv%Lv%Lv%L0sL.v=~1=~1=~1.v syjn~jn~jn~@5I5IZ=Z==~1=~1.v sy =~1 =~1 v% v% v%b~b~b~5I5I@v%v%v%q.vW~9K~ iMJiMJiMJiMJiMJN]? ~ 3 ~3 ~3 ~3 ~3 ~3H~3 ~ 3 ~ 3 ~ 3 ~ 3 ~ 3 ~3 ~3 ~3 ~3 ~3 ~3 ~3 ~3 ~3 ~3 ~3 ~3@@@@@P x1# @y3/"LB`CREATE SERVICE1y >1yQ:1:U0'/"L/"L UExternalMailService : B|">1yS:1:4&4ExternalMailService :@ )ia>1yJ1J1ycJ1J 1yJ1J7 J Gvs>1yc:J1J7c J }M@(@1y >1 ygoK1 K K Kf>1 yimK1 K-- K 8M6$ember 01y/"L1NT gro(0x( be NOT NULL -- -- if a @role_principal_id is specified, a NULL login is allowed -- in this case we check if the msdb database user a@sociated -- with the current security context is member of the specified -- msdb database role (this allows us to verify if a particular -- msdb database loginless msdb user is member of that msdb role) CREATE PROCEDURE dbo.sp_sqlagent_is_member ( @group_sid VARBINARY(85) = NULL, @role_principal_id INT = NULL, @login_sid VARBINARY(85) ) AS BEGIN DECLARE @ret_success INT DECLARE @login NVARCHAR(256) DECLARE @impersonated INT DECLARE @group_name NVARCHAR(256) @SELECT @ret_success = 0 --failure SELECT @impersonated = 0 IF (@group_sid IS NOT NULL AND @login_sid IS NULL) RETURN(0) --a sysadmin can check for every user group membership IF (@login_sid IS NOT NULL) AND (ISNULL(IS_SRVROLEMEMBER('sysadmin'),0) = 1) BEGIN --get login name from principal_id SELECT @login = SUSER_SNAME(@login_sid) IF SUSER_SNAME() <> @login BEGIN --impersonate EXECUTE sp_setuserbylogin @login SELECT @impersonate@ = 1 END END IF @group_sid IS NOT NULL SELECT @group_name = SUSER_SNAME(@group_sid) ELSE SELECT @group_name = USER_NAME(@role_principal_id) -- return success, if login is member of the group, and failure if group doesnt exist or login is not member of the group SELECT @ret_success = ISNULL(IS_MEMBER(@group_name),0) --revert to self IF @impersonated = 1 EXECUTE sp_setuserbylogin RETURN @ret_success END T0Y` @8@CREATE DEFAULT default_zero AS 00> 8CREATE PROCEDURE sp_help_jobactivity @job_id UNIQUEIDENTIFIER = NULL, -- If provided should NOT also provide job_name @job_name sysname = NULL, -- If provided should NOT also provide job_id @session_id INT = NULL AS BEGIN DECLARE @retval INT DECLARE @session_id_as_char NVARCHAR(16) SET NOCOUNT ON -- Remove any leading/trailing spaces from parameters (except @owner_login_name) SELECT @jobHname = LTRIM(RTRIM(@job_name)) -- Turn [nullable] empty string parameters into NULLs IF (@job_name = N'') SELECT @job_name = NULL IF ((@job_id IS NOT NULL) OR (@job_name IS NOT NULL)) BEGIN EXECUTE @retval = sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id OUTPUT IF (@retval <> 0) @@@@@P!z 1G~+> c1(deEA@z3h/"LB*CreatProc transaction1z  d>1z "1"b0,dP h/"Lh/"L bsp_maintplan_delete_log> " 娞>1z]@0"<M&d<sp_maintplan_delete_log " ^C>1zF%"0("<e&d<sp_maintplan_delete_log " `~>1zz%"1" d " a*>1zl<.0Y<i0d 8CREATE P@OCEDURE sp_maintplan_delete_log @plan_id UNIQUEIDENTIFIER = NULL, @subplan_id UNIQUEIDENTIFIER = NULL, @oldest_time DATETIME = NULL AS BEGIN -- @plan_id and @subplan_id must be both NULL or only one exclusively set IF (@plan_id IS NOT NULL) AND (@subplan_id IS NOT NULL) BEGIN RAISERROR(12980, -1, -1, '@plan_id', '@subplan_id') RETURN(1) END --Scenario 1: User wants to delete all logs --Scenario 2: User wants to delete @ll logs older than X date --Scenario 3: User wants to delete all logs for a given plan --Scenario 4: User wants to delete all logs for a specific subplan --Scenario 5: User wants to delete all logs for a given plan older than X date --Scenario 6: User wants to delete all logs for a specific subplan older than X date -- Special case 1: Delete all logs IF (@plan_id IS NULL) AND (@subplan_id IS NULL) AND (@oldest_time IS NULL) BEGIN DELETE msdb.dbo.sysmaintplan_logdetail @ DELETE msdb.dbo.sysmaintplan_log RETURN (0) END DELETE msdb.dbo.sysmaintplan_log WHERE ( task_detail_id in (SELECT task_detail_id FROM msdb.dbo.sysmaintplan_log WHERE ((@plan_id IS NULL) OR (plan_id = @plan_id)) AND ((@subplan_id IS NULL) OR (subplan_id = @subplan_id)) AND ((@oldest_time IS NULL) OR (start_time < @oldest_time))) ) RETURN (0) END  < ft,:>1@z)1G)E0-d$$E@plan_id ) @>1 z2)0')"s6d"@plan_id> ) Z]'>1 z)1 )KLe0-d$$K@subplan_id ) BK1>1 z)0@/)(6d(@subplan_id ) s7Ճ>1 z)1 )M0-d==M@oldest_time ) a>1 zG)0P)*c6d*@oldest_timeO ) OCDer >1z "1")d "@ 娞>1z "1" d " 娞>1zgK0(Kda D K eVWa>1zK0(KOa Dd K 1>1zgK1Kda D K =m>1@zK1Ka DdW K *|D9>1zgK1Knda D K |O 2>1zK1Ka Dd K ~:u >1zgK1Kida D K x2>1>1z@K1Ka Dde K މI8mdle>1zgK1Kda D K OQ^>1zK1Kga Dde K <%)>1zgK1KdEG K \seq>1zK1@KEGd> K @ǻ1>1zEb0(bL0d @>DLsysmaintplan_logdbomsdb b Õh>1z4b0<b:e6d4:sysmaintplan_logdbo  b v<0>1zEb1bX880d @@PXsysmaintplan_logdetaildbomsdb b Ű@3>1z5b1bF6d@Fsysmaintplan_logdetaildbo b -`01zh/"L1)XPX`hpx  ` (  x(Iservice_id ) 40>14v.)1`\)&6uc @&service_idH ) X"ލ15v  16vQ)14)[0-uc 88 [service_contract_id ) E0>17v))15)86uc 8service_contract_id ) >18v  19vQ@17)I0-uc Ivalidation> ) L?>1:v)1`_)&6uc &validation ) ?a[1;v  1<vQ)1:)O0-uc 88 Onext_fragment  ) i[Sz>1=@s()1`b),6uc ,next_fragment ) ݾ1>v  1?vQ)1=)O0-uc 88 Ofragment_size  ) 5%̶v>1@v})1`h),6uc ,fragment_size ) CL̪61AvH  1Cw )1`c-"@@1Dw)P1Ew)Q-R7\>1Fw)1FNKQ[CMCIISWOCESOEKGGO]]YYCKkMKQ_MaCGIKKWOQ??I@@@@J aR"P#6  1L> c1(e ;fEA@{3/"LB*CreatProc transaction1{  e>1{ "1"jc0,eP /"L/"L jsp_maintplan_delete_subplan " E]oilS>1{@^"1"D&eDsp_maintplan_delete_subplan " #c.0>1{F&"1"D&eDsp_maintplan_delete_subplan " F>1{z'"1" e> " sO4A9>1{k<.0d<70e@ 78CREATE PROCEDURE sp_maintplan_delete_subplan @subplan_id UNIQUEIDENTIFIER, @delete_jobs BIT = 1 AS BEGIN DECLARE @retval INT DECLARE @job UNIQUEIDENTIFIER DECLARE @jobMsx UNIQUEIDENTIFIER SET NOCOUNT ON SET @retval = 0 -- Raise an error if the @subplan_id doesn't exist IF( NOT EXISTS(SELECT * FROM sysmaintplan_subplans WHERE subplan_id = @subplan_id)) BEGIN DECLARE @subplan_id_as_char VA@CHAR(36) SELECT @subplan_id_as_char = CONVERT(VARCHAR(36), @subplan_id) RAISERROR(14262, -1, -1, '@subplan_id', @subplan_id_as_char) RETURN(1) END BEGIN TRAN --Is there an Agent Job/Schedule associated with this subplan? SELECT @job = job_id, @jobMsx = msx_job_id FROM msdb.dbo.sysmaintplan_subplans WHERE subplan_id = @subplan_id EXEC @retval = msdb.dbo.sp_maintplan_delete_log @subplan_id = @subplan_id IF (@retval <> 0) BEGIN @ ROLLBACK TRAN RETURN @retval END -- Delete the subplans table entry first since it has a foreign -- key constraint on its job_id existing in sysjobs. DELETE msdb.dbo.sysmaintplan_subplans WHERE (subplan_id = @subplan_id) IF (@delete_jobs = 1) BEGIN --delete the local job associated with this subplan IF (@job IS NOT NULL) BEGIN EXEC @retval = msdb.dbo.sp_delete_job @job_id = @job, @delete_unused_schedule = 1 @ IF (@retval <> 0) BEGIN ROLLBACK TRAN RETURN @retval END END --delete the multi-server job associated with this subplan. IF (@jobMsx IS NOT NULL) BEGIN EXEC @retval = msdb.dbo.sp_delete_job @job_id = @jobMsx, @delete_unused_schedule = 1 IF (@retval <> 0) BEGIN ROLLBACK TRAN RETURN @retval END END END @ COMMIT TRAN RETURN (0) END  < L&6o>1{)1 )K0-e$$K@subplan_id ) P?>1 {)1 )(6e(@subplan_id ) 嶮>1 { )1 )M0-ehhM@delet@e_jobs ) >1 {)0P,)*36e*@delete_jobs ) WQ>1 { "1"e " E]o>1 { "1 " e " E]o>1{gK1KerU @K \׸@3 >1{K1KrUe K c4{3 >1{gK1K'ed K ҝo%s'>1{+K0Kde3 K sM3>1{gK1Ke^= K {Q@>1{[K1K^=e K :' >1{gK1Ke^= K p7:_s>1{ZK1K3^=e K \">1{gK1Ke^= K QjH>>1@{aK1K^=e K O >1{gK1Ke^= K ^fA3 >1{bK1K^=e K J>1{Eb1bF0e @8>Fsp_delete_jobdbomsdb b@ *??>1{!b0(b46e.4sp_delete_jobdbo b <;4(+P>1{Eb1bZ0e @LRZsp_maintplan_delete_logdbomsdb b {+[ >1{>b1bH6eBHsp_maintplan_delete_logdbo b@ H>1{Eb1bD0e pDsysmaintplan_subplans b eS>1{8b1 b<6e<sysmaintplan_subplans b fqnts>1 {Eb1bV0e @HNVsysmaintplan_subplansdbomsdbb b@ 5>1!{;b1 bD6e>Dsysmaintplan_subplansdbo b 5|f ~101{/"L12Xhhpx((x @ 8x(ments_transfer b SG|)>04U[b03b<[0^ p<sysmail_mailitems b@ 2x$>05UGYb04b416^4sysmail_mailitems b ~yzCh>06U\b05b\0^ @NT\sysmail_principalprofiledbomsdb b >F >07UGdb06bJ6^ DJsysmail_principalprofiledbo Hb /iwl >08U]b07bF0^ pFsysmail_query_transfer b X>09Ub0/b>6^ >sysmail_query_transfer b &׊#ar>0:U^b09b^0^ @PV^sysmail_verify_profilH@ RP#6  1c`> c1( ;fY_gEA@|30"LB*CreatProc transaction1|  ;f>1|"1"r0, ;fP 0"L0"L rsp_maintplan_update_subplan_tsxt " <2rvi>1@_"1"L& ;fLsp_maintplan_update_subplan_tsx " NHN>1|F'"1"L& ;fLsp_maintplan_update_subplan_tsx " 1{>1|z)"1"  ;f " *J>1|n<'<@0 ;f 8-- This procedure is called when a maintenance plan subplan record -- needs to be created or updated to match a multi-server Agent job -- that has arrived from the master server. CREATE PROCEDURE sp_maintplan_update_subplan_tsx @subplan_id UNIQUEIDENTIFIER, @plan_id UNIQUEIDENTIFIER, @name sysname, @description NVARCHAR(512), @job_id UNIQUEIDENTIFIER AS BEGIN -- Find out what schedule, if any, is associated@with the job. declare @schedule_id int select @schedule_id = (SELECT TOP(1) schedule_id FROM msdb.dbo.sysjobschedules WHERE (job_id = @job_id) ) exec sp_maintplan_update_subplan @subplan_id, @plan_id, @name, @description, @job_id, @schedule_id, @allow_create=1 -- Be sure to mark this subplan as coming from the master, not locally. update sysmaintplan_subplans set msx_plan = 1 where subplan_id = @subplan_id @END T  < &0Sai>1| )1 )KD 0- ;f$$K@subplan_ide ) GIF (@l>1 |)1 )( 6 ;f(@subplan_id ) 5 tog>1 | )1 )E 0- ;f$$E@plan_id  ) iDte@>1 |3)1 )"ou6 ;f"@plan_id  ) IOp_name>1 | )1 )?og0- ;f4?@name  )  t>1 |x)0Q) 6 ;f@name ) ']& EX>1|)1 )M0- ;f@4M@description8 ) 25kp_>1|&)1 )*ed6 ;f*@descriptionna ) RI= NULL>1|)1)CNU0- ;f$$C@job_idd ) ˀ^(g SET>1|I)05)  (6 ;f @job_id )@ "P= >1|"1"ntoNUL ;f " <2N'>1|"1"S N T N ;f " <2et>1|gK1K  ;fH0 K D{ >1| K0( K H0 ;f  K V|銘 IF >1|@K1Kon ;fH0 K OU+,on_id >1| K1K( H0 ;fes K !y~ = @se>1|gK1K16 ;f^= K BX[Rssion_>1|]K1K ^= ;f,  K zwm; ja.jo>1|gK1@K  ;f^= K 7, >1|fK1Kte^= ;f.l K v, >1|Eb1!bP 0 ;f pPsp_maintplan_update_subplan b #xJ j>1|@b1bHo.6 ;fHsp_maintplan_update@subplan b T >1|E b1bJ@j0 ;f @<BJsysjobschedulesdbomsdbd  b .F0>1|Ab)Cb8i6 ;f28sysjobschedulesdbo b a|֞>1 |E!b1bD0 ;f pDsysmaintplan_subplans @b wD>1!|9b1"b<"6 ;f<sysmaintplan_subplans b L+01|0"L1p(X`hp X ( X  Px(h0 a`h4[dbo].[sp_ExternalMailQueueListener] < I8u>1`paJ1PJ@(Na` J ٜml_mes>1`pcJ1PJa` J 慯>1`p'A"1`"a` " ߼yF > c1`(a1`p'E"1`"@ 0,aITa`/"L/"L fqueue_messages_1627152842 " & 9E>1`p""/h "@o&a@queue_messages_1627152842 " ^n>1`p)"1`"@t&a@queue_messages_1627152842 " o n>1`pz"1`"@ .a`aQ " ~=v>ion@r3/"LB$:BTree Split/Shrink.6 c.X6 c1`O6 c1`V@s3/"LB aAllocMixedExtentdRou61` sc0bmicH61`!s c1`bBro01` s/"L1` ssi>1`r J1` ccro`so>1`$r bJ4@1`%rJ6c0bP1`&rJ/SQ@@@@_g |P2  1-;> c1(Y_ghEA@}3u0"LB*CreatProc transaction1}  Y_g>1}"1"l0,Y_gP u0"Lu0"L lsp_maintplan_subplans_by_job " 8qQU>1>1}@_"1"F&Y_gFsp_maintplan_subplans_by_job^ " lqM >1}F'"1"Fs&Y_gFsp_maintplan_subplans_by_job " Bog>1}z,"1" Y_g " tG>1}p<.PM<F 0Y_g@ F8-- If the given job_id is associated with a maintenance plan, -- then matching entries from sysmaintplan_subplans are returned. CREATE PROCEDURE sp_maintplan_subplans_by_job @job_id UNIQUEIDENTIFIER AS BEGIN select plans.name as 'plan_name', plans.id as 'plan_id', subplans.subplan_name, subplans.subplan_id from sysmaintplan_plans plans, sysmaintplan_subplans subplans where plans.id = subplans.plan_id and (job_id = @job_id or msx_job_id = @job_id) @order by subplans.plan_id, subplans.subplan_id END s  < nR a>1}$)1)Cif0-Y_g$$C@job_idv ) s35ate >1 }K)1) ld6Y_g @job_id ) j-s >1 }"1"NUL) Y_g " 8qQUo.>1 }@"1 "URN (0)Y_g " 8qQU.s>1 }E.b1!b>ta0Y_g p>sysmaintplan_plans  b 1 }7b1"b6ub6Y_g6sysmaintplan_plans  b ߪi_JHld>1}E/b1 bD 0Y_g pDsysmain@plan_subplans b kt.>1};b1b<_6Y_g<sysmaintplan_subplans b |)01}u0"L1> 8 XxP8x( z)1 )KLe0-d$$K@subplan_id ) BK1>1 z)0@/)(6d(@subplan_id ) s7Ճ>1 z)1 )M0-d==M@oldest_time ) a>1 zG)0P)*c6d*@oldest_timeO ) OCDer >1z "1")d "H 娞>1z "1" d " 娞>1zgK0(Kda D K eVWa>1zK0(KOa Dd K 1>1zgK1Kda D K =m@@t P| 1 "> c1(h˧iEA@~30"LB*CreatProc transaction1 ~  h>1 ~"1 "hc0,hP 0"L0"L hsp_maintplan_open_logentry " uh]>1 ~_@1"B&hBsp_maintplan_open_logentryb " W #>1 ~F'"1"B&hBsp_maintplan_open_logentryb " ;kh F>1 ~z."1" h " C< sO4>1 ~p<1<0h @8CREATE PROCEDURE sp_maintplan_open_logentry @plan_id UNIQUEIDENTIFIER, @subplan_id UNIQUEIDENTIFIER, @start_time DATETIME = NULL, @task_detail_id UNIQUEIDENTIFIER = NULL OUTPUT AS BEGIN --Set defaults IF (@start_time IS NULL) BEGIN SELECT @start_time = GETDATE() END SELECT @task_detail_id = NEWID() --Insert a new record into sysmaintplan_log table INSERT INTO msdb.dbo.sysmaintplan_log(task_detail_id, p@an_id, subplan_id, start_time) VALUES(@task_detail_id, @plan_id, @subplan_id, @start_time) RETURN (@@ERROR) END id < jA) >1 ~&)1 )Ege0-h$$E@plan_idid, ) C: >1  ~4)1 )"an6h"@plan_id.s ) 3% @subp>1  ~')1  )@KCK0-h$$K@subplan_ide ) :ks a fo>1  ~)1 )(EL6h(@subplan_id ) |Y9=su>1  ~()1  )Ke 0-h==K@start_time  ) v[EXEC @>1  ~R)07)(e 6h@(@start_time ) qˆ >1 ~))1  )S 0-h$$S@task_detail_id  ) SNOT NU>1 ~H)1  )0 @6h0@task_detail_id )  <>1 ~))1 )ETUN @h  ) S >1@~"1 ">h " uh>1 ~"1 " h " uh >1 ~ K0 Kha D K EJpla>1 ~K1Ka Dh K *|hh>1 ~!K1 @K)ha D K =q͈<0>1 ~K1 Kba Dh  K lv >1 ~"K1 Kha D K =k0 >1 ~K1 K a Dh K =1>1 ~#K1 K@ha D K E1>1 ~K1 K{a Dh K s`T1>1 ~E0b1bL0h @>DLsysmaintplan_logdbomsdb b #˞e>1 ~5b1b:6h4:sysmaintplan_logdbo b @01 ~0"L1 Kh@HP X h 8 x@0x( >1{gK1Ke^= K p7:_s>1{ZK1K3^=e K \">1{gK1Ke^= K QjH>>1@{aK1K^=e K O >1{gK1Ke^= K ^fA3 >1{bK1K^=e K J>1{Eb1bF0e @8>Fsp_delete_jobdbomsdb b@ *??>1{!b0(b46e.4sp_delete_jobdbo b <;4(+P>1{Eb1bZ0e @LRZsp_maintplan_delete_logdbomsdb b {+[ >1{>b1bH6eBHsp_maintplan_delete_logdbo b@ H>1{Eb1bD0e pDsysmaintplan_subplans b eS>1{8b1 b<6e<sysmaintplan_subplans b fqnts>1 {Eb1bV0e @HNVsysmaintplan_subplansdbomsdbb b@ 5>1!{;b1 bD6e>Dsysmaintplan_subplansdbo b 5|f ~101{/"L12Xhhpx((x @ 8x(ments_transfer b SG|)>04U[b03b<[0^ p<sysmail_mailitems b@ 2x$>05UGYb04b416^4sysmail_mailitems b ~yzCh>06U\b05b\0^ @NT\sysmail_principalprofiledbomsdb b >F >07UGdb06bJ6^ DJsysmail_principalprofiledbo Hb /iwl >08U]b07bF0^ pFsysmail_query_transfer b X>09Ub0/b>6^ >sysmail_query_transfer b &׊#ar>0:U^b09b^0^ @PV^sysmail_verify_profilH@@@@@9 l"P  10S > c1 (˧i̅jEA@3-1"LB*CreatProc transaction10  ˧i>10"1 "j0,˧iP -1"L-1"L jsp_maintplan_close_logentry_ " 26Mu <>10@]"1 "D&˧iDsp_maintplan_close_logentry " H">10F%"1 "D&˧iDsp_maintplan_close_logentry " ?:x >10z0"1 " ˧i " $ >10p<1 <z0˧i@ z8CREATE PROCEDURE sp_maintplan_close_logentry @task_detail_id UNIQUEIDENTIFIER, @end_time DATETIME = NULL, @succeeded TINYINT AS BEGIN --Set defaults IF (@end_time IS NULL) BEGIN SELECT @end_time = GETDATE() END -- Raise an error if the @task_detail_id doesn't exist IF( NOT EXISTS(SELECT * FROM sysmaintplan_log WHERE (task_detail_id = @task_detail_id))) BEGIN DECLARE @task_detail_id_as_char VARC@AR(36) SELECT @task_detail_id_as_char = CONVERT(VARCHAR(36), @task_detail_id) RAISERROR(14262, -1, -1, '@task_detail_id', @task_detail_id_as_char) RETURN(1) END UPDATE msdb.dbo.sysmaintplan_log SET end_time = @end_time, succeeded = @succeeded WHERE (task_detail_id = @task_detail_id) RETURN (@@ERROR) END hi < iom the>10.)1 )Sla0-˧i$$@S@task_detail_id ) ʻj> >10 I)1 )06˧i0@task_detail_id ) @l>10 /)10 )G 0-˧i==G@end_time ) *DpW >10 [)1)$6˧i$@end_time ) |C>iDte@>10 0)10 )Iou0-˧i00I@succeeded ) /粎1>10 2)10 )&6˧i&@succeeded  ) ٲf>10"10"@a˧i " 26MuEX>10"10"- ;f˧i@ " 26Mu>10.K1 K˧ia D K 5ه>10K1 Ka D˧i K A`_1>10/K10K˧ia D K $qN SET>10K10K (a D˧i@ K ;{@ >100K10K˧ia D K "ɚ>1>10K10K Na D˧i K o'>10E3b1 b:H0˧i p:sysmaintplan_log b  >104b1 b2F 6˧i2sys@aintplan_logK b 5|p ;>10E4b10bL0˧i @>DLsysmaintplan_logdbomsdb b @@~>1>107b10b:;6˧i4:sysmaintplan_logdbo b PҠ1010.1"L10,  8   8 x @8x(K1@K  ;f^= K 7, >1|fK1Kte^= ;f.l K v, >1|Eb1!bP 0 ;f pPsp_maintplan_update_subplan b #xJ j>1|@b1bHo.6 ;fHsp_maintplan_update@subplan b T >1|E b1bJ@j0 ;f @<BJsysjobschedulesdbomsdbd  b .F0>1|Ab)Cb8i6 ;f28sysjobschedulesdbo b a|֞>1 |E!b1bD0 ;f pDsysmaintplan_subplans @b wD>1!|9b1"b<"6 ;f<sysmaintplan_subplans b L+01|0"L1p(X`hp X ( X  Px(h0 a`h4[dbo].[sp_ExternalMailQueueListener] < I8u>1`paJ1PJ@(Na` J ٜml_mes>1`pcJ1PJa` J 慯>1`p'A"1`"a` " ߼yF > c1`(a1`p'E"1`"@ 0,aITa`/"L/"L fqueue_messages_1627152842 " & 9E>1`p""/h "@o&a@queue_messages_1627152842 " ^n>1`p)"1`"@t&a@queue_messages_1627152842 " o n>1`pz"1`"@ .a`aQ " ~=v>ion@r3/"LB$:BTree Split/Shrink.6 c.X6 c1`O6 c1`V@s3/"LB aAllocMixedExtentdRou61` sc0bmicH61`!s c1`bBro01` s/"L1` ssi>1`r J1` ccro`so>1`$r bJ4@1`%rJ6c0bP1`&rJ/SQH@@@@@@m]HPY:P` 1@> c10(̅j=ykEA@31"LB*CreatProc transaction1@  ̅j>1@!"10"b0,̅jP 1"L1"L bsp_maintplan_update_logy " K 8qQ>1@b@10"<&̅j<sp_maintplan_update_log " 3!'{ ">1@F*"10"<&̅j<sp_maintplan_update_log " g|ob>1@z2"10" ̅j " ӶY,+ @31"LBSplitPage >1@@ <1Dc it a @ain@1@ <P1@ <q?UEIDEN>1@ <1@ %D, 0Xj 8CREATE PROCEDURE sp_multi_server_job_summary @job_id UNIQUEIDENTIFIER = NULL, @job_name sysname = NULL AS BEGIN DECLARE @retval INT SET NOCOUNT ON IF ((@job_id IS NOT NULL) OR (@job_name IS NOT NULL)) BEGIN EXECUTE @retval = sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id OUTPUT IF (@retval <> 0) RETURN(1) -- Failure END -- NOTE: We join with syscategories - not sysjobservers - since we want to include jobs -- which are of type multi-server but@which don't currently have any servers SELECT 'job_id' = sj.job_id, 'job_name' = sj.name, 'enabled' = sj.enabled, 'category_name' = sc.name, 'target_servers' = (SELECT COUNT(*) FROM msdb.dbo.sysjobservers sjs WHERE (sjs.job_id = sj.job_id)), 'pending_download_instructions' = (SELECT COUNT(*) FROM msdb.dbo.sysdownloadlist sdl @ WHERE (sdl.object_id = sj.job_id) AND (status = 0)), 'download_errors' = (SELECT COUNT(*) FROM msdb.dbo.sysdownloadlist sdl WHERE (sdl.object_id = sj.job_id) AND (sdl.error_message IS NOT NULL)), 'execution_failures' = (SELECT COUNT(*) FROM msdb.dbo.sysjobservers sjs @ WHERE (sjs.job_id = sj.job_id) AND (sjs.last_run_date <> 0) AND (sjs.last_run_outcome <> 1)) -- 1 is success FROM msdb.dbo.sysjobs sj, msdb.dbo.syscategories sc WHERE (sj.category_id = sc.category_id) AND (sc.category_class = 1) -- JOB AND (sc.category_type = 2) -- Multi-Server AND ((@job_id IS NULL) OR (sj.job_id = @job_id)) AND ((@job_name IS NULL) OR (sj.name = @job_name)) RETURN(0) @- Success END >0k 8CREATE PROCEDURE sp_target_server_summary @target_server sysname = NULL AS BEGIN SET NOCOUNT ON SELECT server_id, server_name, 'local_time' = DATEADD(SS, DATEDIFF(SS, last_poll_date, GETDATE()), local_time_at_last_poll), last_poll_date, 'unread_instructions' = (SELECT COUNT(*) FROM msdb.dbo.sysdownloadlist sdl WHERE (UPPER(sdl.target_serve@) = UPPER(sts.server_name)) AND (sdl.status = 0)), 'blocked' = (SELECT COUNT(*) FROM msdb.dbo.sysdownloadlist sdl WHERE (UPPER(sdl.target_server) = UPPER(sts.server_name)) AND (sdl.error_message IS NOT NULL)), poll_interval FROM msdb.dbo.systargetservers sts WHERE ((@target_server IS NULL) OR (UPPER(@target_server) = UPPER(sts.server_name))) END 0(l 8@REATE PROCEDURE sp_uniquetaskname @seed NVARCHAR(92) AS BEGIN DECLARE @newest_suffix INT SET NOCOUNT ON -- We're going to add a suffix of 8 characters so make sure the seed is at most 84 characters SELECT @seed = LTRIM(RTRIM(@seed)) IF (DATALENGTH(@seed) > 0) SELECT @seed = SUBSTRING(@seed, 1, 84) -- Find the newest (highest) suffix so far SELECT @newest_suffix = MAX(CONVERT(INT, RIGHT(name, 8))) FROM msdb.dbo.sysjobs -- DON'T use sysjobs_view here! WHERE (name LI@E N'%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]') -- Generate the task name by appending the 'newest suffix' value (plus one) to the seed IF (@newest_suffix IS NOT NULL) BEGIN SELECT @newest_suffix = @newest_suffix + 1 SELECT 'TaskName' = CONVERT(NVARCHAR(92), @seed + REPLICATE(N'0', 8 - (DATALENGTH(CONVERT(NVARCHAR, @newest_suffix)) / 2)) + CONVERT(NVARCHAR, @newest_suffix)) END ELSE SELECT 'TaskName' = CONVERT(NVARCHAR(92), @seed + N'00000001') END 0Bm @8((0))a0Mm D8$h]d#33<1@  q<.h60>1@ q<1@ ?b b>1@?<.hAqXX>1@h<1`<dXj401@1"L1@\>1@q@1@<r)0̅j r8CREATE PROCEDURE sp_maintplan_update_log --Updates the log_details table @task_detail_id UNIQUEIDENTIFIER, --Required @Line1 NVARCHAR(256), --Required @Line2 NVARCHAR(256) = NULL, @Line3 NVARCHAR(256) = NULL, @Line4 NVARCHAR(256) = NULL, @Line5 NVARCHAR(256) = NULL, @server_name sysname, --Req@ired @succeeded TINYINT, --Required @start_time DATETIME, --Required @end_time DATETIME, --Required @error_number int=NULL, @error_message NVARCHAR(max) = NULL, @command NVARCHAR(max) = NULL AS BEGIN --Prep strings SET NOCOUNT ON SELECT @Line1 = LTRIM(RTRIM(@Line1)) SELECT @Line2 = LTRIM(RTRIM(@Line2)) SELECT @Line3 = LTRIM(RTRIM(@Line3)) SELECT @Line4 = LTRIM(RTRIM(@Line@)) SELECT @Line5 = LTRIM(RTRIM(@Line5)) INSERT INTO msdb.dbo.sysmaintplan_logdetail( task_detail_id, line1, line2, line3, line4, line5, server_name, start_time, end_time, error_number, error_message, command, succeeded) VALUES( @task_detail_id, @Line1, @Line2, @Line3, @Line4, @Line5, @server_name, @ @start_time, @end_time, @error_number, @error_message, @command, @succeeded) RETURN (@@ERROR) END  < ˴vB7>1@3)10 )S0-̅j$$S@task_detail_id7 ) XyWH_>1@K)10)0E6̅j0@task_detail_id ) 4"@>1@4)1@)A0-̅j4A@Line1 ) W،>1@)1)46̅j@Line1t ) :5Md6n>1@5)1@)Ai0-̅j4A@Line2ve ) A1@)1@@)886̅j@Line2 ) ۭ~id>1@6)1@)A_0-̅j4A@Line3qu ) y 0->1@)1@)t6̅j@Line3 ) %\>1@7)1@)A0-̅j4A@Line4@ ) `Qep_>1@)1@)m6̅j@Line4 ) /h>1@8)1@)A40-̅j4A@Line5  ) `N$*K>1@)1@)6̅j@Line5g ) J>1@9)1@)@M0-̅j4M@server_name ) %I&o>1@.)1 )*6̅j*@server_named ) QzU-tOg@31"LBpSplitPageg 61@!)1`!catt>1@" )1@ cs@>1@# )1@#c-@sh61@$ l).Yced_@1@%)6c1`'cP1@&)-R88>1@()1@(-CGIKKWOQ??ICGOEGOMU__UQ_[MMMYQKEc_MYMQAK[QMm0-@j$$C@job_idr0-Xj4G@job_namea0-gk4Iservertype0-gkhhBmKis_incoming0-gkhhgnKis_outgoing0-gk==KoWlast_mod_datetimeK0-gk4spOlast@_mod_users0-k4Q@target_server_m0-(l4?@seeds0-Mm4?@name0-MmP4I@subsystem0-Mm4C@server0-Mm4G@username0-Mm4O@datab@asename0-Mm00E@enabled0-Mm88 G@freqtype0-Mm88 O@freqinterval0-Mm 88 M@freqsubtype0-Mm 88 U@freqsubintervalre0-Mm 88 _@freqrelativeintervale0-Mm@ 88 _@freqrecurrencefactor0-Mm 88 U@activestartdateva0-Mm88 Q@activeenddatenc0-Mm88 _@activestarttimeofdaya0-Mm88 [@activeendtimeofday0-Mm88 M@nextr@undateti0-Mm88 M@nextruntimeiv0-Mm88 M@runpriorityM0-Mm4Y@emailoperatornametr0-Mm88 Q@retryattemptsio0-Mm88 K@retrydelayl0-Mm4E@command0-Mm@88 c@loghistcompletionlevelt0-Mm88 _@emailcompletionlevelm0-Mm4M@descriptionon0-Mm`4Y@tagadditionalinfoti0-Mm88 M@tagobjectidcr0-Mm88 Q@tagobjectty@pedi0-Mm88 A@newid0-Mmcc4K@parameters0-Mm 88 [@cmdexecsuccesscode0-Mm!4Q@category_nameam0-Mm"88 M@category_idec<1@) :)1@+ >1@*)1@*R>1@+R)1J@>1@,o')1K)Xj01@!1"L1@!>1@ :)1@+)I&0-̅j00I@succeeded )  >1@/3)1@@)&6̅j&@succeeded ) S>1@0;)1@/)K0-̅j ==K@start_time ) K[_bi>1@1T)1@ )(6̅j (@start_time ) ܨ݅8e>1@2<)1@1)Gy0-̅j ==@G@end_time ) ep>1@3\)10 )$s6̅j $@end_time ) @>1@4=)1@3)O"0-̅j 88 O@error_number ) C9|>1@5c)1@4),6̅j ,@error_number ) ~6_(U@>1@6>)1@5)Q0-̅j 4Q@error_message ) Ȋ9U >1@7c)1@6).6̅j .@error_message ) Sy>1@8?)1@7)E0-̅j 4E@command= ) 1R]>1@9@4)03)"6̅j "@command ) >} Y>1@:!"1@"̅j " K>1@;!"1@;" ̅j " K>1@<1K10KA̅jEG K M>1@=K1@KEG̅j K w8-\>1@>2K1@=K̅jEG K cy[<]>1@?K1@>KEG̅j K A*>1@@3K1@?K̅jEG K 510>1@AK1@@K@EG̅j K AV5>1@B4K1@AK̅jEG K E]EF>1@CK1@BKEG̅j K q >1@D5K1@CK̅jEG K [\ҸIF>1@EK1@DKH@EG̅j K I#:{>1@F6K1@EK ̅jEG K h]|c>1@GK1@FKEG̅j  K G>1>1@H7K1@GK{̅jEG K B$ʙe>1@IK1@HKEG̅j@ K W,.>1@J8K1@IK̅jEG K "O>1@KK1@JKEG̅j K m&W>1@L9K1@KK̅jEG  K 2n@ >1@MK1@LKEG ̅j K@ M9@>1@N:K1@MK ̅jEG  K ZW>1@OK1@NKEG ̅j K d>1@P;K1@OK̅jEG  K +a>1@QK1@PKEG ̅j K 9{4|@>1@R<K1@QK̅jEG  K 3I d_i>1@SK1@RKEG ̅j6 K Kc>1@T=K1@SK̅jEG  K >1@UK1@TK EG ̅j K { "1>1@V@E5b10bX10̅j @JPXsysmaintplan_logdetaildbomsdb b r ae >1@W9b10bF6̅j@Fsysmaintplan_logdetaildbo b !ۻ#01@1"L1@ucPONMxMLLLKKJJIIH HG(GF0FE8ED@DCHCBPBAXA@x@?H?>>p=<8<;;X:9 9880877`))((P(('h''x&%H%@$ $x#"P"!(! pHX@ x(uv 71t7ucr 7 Cq|s>1vvi71u7ucl 7 ]Fr >1wv 71v7uc 7 =[5p >1xvj71w7uc@ 7 ңK>1yv<.D<"01{v=1S + qe{  D>1|v>1|>9|uc)/5/5  .z1}v@  |> c1jx>1~v?1kMI|     PПF>1v51l3|   qewq>1vO1i>:|0@  x+->1vP1>:|0  |L!a>1vQ1>:|  n>1vR1>:|$ y  @ %Y?>1vS1>:|$  Di2~>1vT1>:|8++  ]'X$1v|.>1v61n6Y30'uc | Yqueue_sec@ondary_index 6 ܱ/>1v}61o6:6uc:queue_secondary_index 6 b&`K>1v71x7uc  7 nVn?s>1vg71y7uc 7 }ySK>1v71@7uc  7 iZxZQ>1vi717uc 7 5/K>1v717uc  7 vV~>1vk717uc 7 nK>1v717Huc  7 3$r#>1vm717uc 7 ɉZ2K>1v717uc  7 QOh/R]>1vo717uc 7 q)K>1v@@@@@@@0@X 4u<%KCr- @"P+"0`1pip{> c1@(=ykvnlEA@31"LB*CreatProc transaction1p  =yk>1p%"1@<"jc0,=ykP 1"L1"L jsp_maintplan_update_subplan  " btj>1>1p@c"1@"D&=ykDsp_maintplan_update_subplan " *>1>1pF+"1@"D&=ykDsp_maintplan_update_subplan " HsOs5>1>1pz4"1@" =yk" " TfK>1>1p<1@ < 0=yk@ 8CREATE PROCEDURE sp_maintplan_update_subplan @subplan_id UNIQUEIDENTIFIER, @plan_id UNIQUEIDENTIFIER = NULL, @name sysname = NULL, @description NVARCHAR(512) = NULL, @job_id UNIQUEIDENTIFIER = NULL, @schedule_id INT = NULL, @allow_create BIT = 0, @msx_job_id UNIQUEIDENTIFIER = NULL AS BEGIN SET NOCOUNT ON SELECT @name = LTRIM(RTRIM(@name)) SE@ECT @description = LTRIM(RTRIM(@description)) --Are we creating a new entry or updating an existing one? IF( NOT EXISTS(SELECT * FROM msdb.dbo.sysmaintplan_subplans WHERE subplan_id = @subplan_id) ) BEGIN -- Only allow creation of a record if user permits it IF(@allow_create = 0) BEGIN DECLARE @subplan_id_as_char VARCHAR(36) SELECT @subplan_id_as_char = CONVERT(VARCHAR(36), @subplan_id) RAISERROR(14262, -1, -1, '@subplan_id',@@subplan_id_as_char) RETURN(1) END --Insert it's a new subplan IF (@name IS NULL) BEGIN RAISERROR(12981, -1, -1, '@name') RETURN(1) -- Failure END IF (@plan_id IS NULL) BEGIN RAISERROR(12981, -1, -1, '@plan_id') RETURN(1) -- Failure END INSERT INTO msdb.dbo.sysmaintplan_subplans( subplan_id, plan_id, subplan_description, subplan_na@e, job_id, schedule_id, msx_job_id) VALUES( @subplan_id, @plan_id, @description, @name, @job_id, @schedule_id, @msx_job_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_job_id UNIQUEIDENTIFIER SELECT @s_subplan_name = subplan_name, @s_job_id = job_id FROM msdb.@bo.sysmaintplan_subplans WHERE (@subplan_id = subplan_id) --Determine if user wants to change these variables IF (@name IS NOT NULL) SELECT @s_subplan_name = @name IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @description, job_id = @s_job_id, @ schedule_id = @schedule_id, msx_job_id = @msx_job_id WHERE (subplan_id = @subplan_id) END RETURN (@@ERROR) END  < Y|>1p)1@))K0-=yk$$K@subplan_id ) &gɬ>1p  )1@0)(6=yk(@subplan_id ) /M,@>1p )1p )E0-=yk$$E@plan_id )  >1p 5)1  )"6=yk"@plan_id  ) tntp>1p )1p )?0-=yk4?@name ) ci>1p ~)1@@)6=yk@name ) ЯِHP>1p)1p )M0-=yk4M@description  ) Ti>1p')1@8)*36=yk*@description ) j&>1p)1p)C0-=yk$$@C@job_id ) -?aae>1pM)1 ) 6=yk @job_id ) В^>1p)1p)M0-=yk88 M@schedule_id  ) ͏ه>1pi)0V)*6=yk*@schedule_ide ) Ӧ4db>1@)1p)O0-=ykhhO@allow_create  ) 4zy@>1pmK)0K),6=yk,@allow_create ) { e_l>1p )1p)K0-=yk$$K@msx_job_id ) |3let>1p@[)1p)(6=yk(@msx_job_id ) rd>1p%"1p">=yk " btj>1p%"1p"_ u=yk " btjf>1pMK1@UK=yk^= K ^Mntp>1p^K1@V@K^==yk K N̾b>1pNK1pKl=yk^= K j-2i>1p_K1pK^==yk  K ُ8>nts>1pOK1pK=yk^= K &Fle>1p`K1pK@x$^==yk K \1p PK1pKi=yk^= K q,6>1p!bK1p K^==yks K ;pal>1p"QK1p!K=yk^= K -O>1p#gK1p"Kb^=@=yk  K #UΎ8>1p$RK1p#K=yk^= K {44!er>1p%iK1p$K^==yk K Je:sys>1p&SK1p%K=yk^= K 47_Ĭ>1p'lK1p&Kr^==yk @K X >1p(E;b1@WbV0=yk @HNVsysmaintplan_subplansdbomsdb  b Y$t!p>1p)Cb1@XbD6=yk>Dsysmaintplan_subplansdbo b .h4001p1"L1p x!   (08@HPp8h8P0x8@x( `hpp0H 8 (08 @ H P X ` hpx (= 0, @rc = 0 WHILE (@timediff <= @receive_timeout) BEGIN -- Delete all messages from @msgs table DELETE FROM @msgs -- Pick all message from queue SET @rec_timeout = @receive_timeout - @timediff WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM Extern@lMailQueue INTO @msgs), TIMEOUT @rec_timeout -- Check if there was some error in reading from queue SET @rc = @@ERROR IF (@rc <> 0) BEGIN IF(@rc < 4) -- make sure return code is not in reserved range (1-3) SET @rc = 4 --Note: we will get error no. 9617 if the service queue 'ExternalMailQueue' is currently disabled. BREAK END --If there is no message in the queue return 1 to indicate a timeout @ IF NOT EXISTS(SELECT * FROM @msgs) BEGIN SET @rc = 1 BREAK END -- Create a cursor to iterate through the messages. DECLARE msgs_cursor CURSOR FOR SELECT conversation_handle, service_contract_name, message_type_name, CONVERT(VARCHAR(MAX), message_body) FROM @msgs; -- Open the cursor OPEN msgs_cursor; -- Perform the first fetch and store the values in the v@riables. FETCH NEXT FROM msgs_cursor INTO @conversation_handle, @service_contract_name, @message_type_name, @xml_message_body -- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE (@@FETCH_STATUS = 0) BEGIN -- Check if the message is a send mail message IF(@message_type_name = N'{//www.microsoft.com/databasemail/messages}SendMail') BEGIN @ -- Get the handle to the xml document EXEC @rc = sp_xml_preparedocument @idoc OUTPUT, @xml_message_body, N'' IF(@rc <> 0) BEGIN IF(@rc < 4) -- make sure return code is not in reserved rang (1-3) SET @rc = 4 END @ ELSE -- parse the document and process its contents BEGIN -- Execute a SELECT statement that uses the OPENXML rowset provider to get the MailItemId. SELECT @mailitem_id = MailItemId FROM OPENXML (@idoc, '/requests:SendMail', 1) WITH (MailItemId INT './MailItemId') --Close the handle to the xml document EXEC sp_xml_removedocument @idoc -H get account information SELECT @profile_id = profile_id FROM sysmail_mailitems WHERE mailitem_id = @mailitem_id IF(@profile_id IS NULL) -- mail item has been deleted from the database BEGIN -- log warning SET @localmessage = FORMATMESSAGE(14667, convert(NVARCHAR(50), @mailitem_id)) exec msdb.dbo.sysmail_logmailep dm LP01v> c1p(vnl8bmEA@3=2"LC*CreatProc transaction1  vnl>1)"1p"d0,vnlP =2"L=2"L dsp_maintplan_delete_plan " j 26M>1_@1p">&vnl>sp_maintplan_delete_plano " h">1F'"1p">&vnl>sp_maintplan_delete_plans " I+ >1z7"1p" vnl " &i:] >1<1p<0vnl 8CREATE P@OCEDURE sp_maintplan_delete_plan @plan_id UNIQUEIDENTIFIER AS BEGIN SET NOCOUNT ON DECLARE @sp_id UNIQUEIDENTIFIER DECLARE @retval INT SET @retval = 0 --Loop through Subplans DECLARE sp CURSOR LOCAL FOR SELECT subplan_id FROM msdb.dbo.sysmaintplan_subplans WHERE plan_id = @plan_id FOR READ ONLY OPEN sp FETCH NEXT FROM sp INTO @sp_id WHILE @@FETCH_STATUS = 0 BEGIN EXECUTE @retval = sp_maintplan_delete_subplan@@subplan_id = @sp_id IF(@retval <> 0) BREAK FETCH NEXT FROM sp INTO @sp_id END CLOSE sp DEALLOCATE sp RETURN (@retval) END  < 1Qm'O UPD>1)1p)Ed 0-vnl$$E@plan_idTUR ) 󠣸 >1 6)1p )"6vnl"@plan_id ) ;-$y>1@ )"1">vnl " j>1 )"1 "_ dvnl " j>1 \K1p'Kivnle K QSd_t>1 ,K1Kevnl K #d>1\K1 @Kvnl^= K m'L#9Q-˧i>1_K1p(K ^=vnl K 62a>1]K1Kuvnl^= K Lz>t>1dK1K^=vnl6M K I>1E>b1p)b@"0vnl pPsp_maintplan_delete_subplan b  >1@b1bH6vnlHsp_maintplan_delete_subplan b Z?>1E?b1bV0vnl @HNVsysmaintplan_subplansdbomsdb b >1Db1p*HbD6vnl>Dsysmaintplan_subplansdbo b phMK01=2"L11x  p H P X hp x( K o'>10E3b1 b:H0˧i p:sysmaintplan_log b  >104b1 b2F 6˧iP R"P).01^~> c1(8bm\VnEA@32"LC*CreatProc transaction1  8bm>1-"1 "X0,8bmP 2"L2"L Xsp_maintplan_start " e*>1b"1@"2&8bm2sp_maintplan_starta " $Ag >1F*"1"2&8bm2sp_maintplan_startn " i@^te_l>1z9"1" 8bm" " )8rE@32"LCSplitPage61<1@"@>1  <1@$c$>1  <1 c$@61  <0 d@1 <6c1@'dP1  <?S BEG>1 <1@ %D0=yk 8CREATE PROCEDURE sp_maintplan_update_subplan @subplan_id UNIQUEIDENTIFIER, @plan_id UNIQUEIDENTIFIER = NULL, @name sysname = NULL, @description NVARCHAR(512) = NULL, @job_id UNIQUEIDENTIFIER = NULL, @schedule_id INT = NULL, @allow_create BIT = 0, @msx_job_id UNIQUEIDENTIFIER = NULL AS BEGIN SET NOCOUNT ON S@LECT @name = LTRIM(RTRIM(@name)) SELECT @description = LTRIM(RTRIM(@description)) --Are we creating a new entry or updating an existing one? IF( NOT EXISTS(SELECT * FROM msdb.dbo.sysmaintplan_subplans WHERE subplan_id = @subplan_id) ) BEGIN -- Only allow creation of a record if user permits it IF(@allow_create = 0) BEGIN DECLARE @subplan_id_as_char VARCHAR(36) SELECT @subplan_id_as_char = CONVERT(VARCHAR(36), @subplan_id) @RAISERROR(14262, -1, -1, '@subplan_id', @subplan_id_as_char) RETURN(1) END --Insert it's a new subplan IF (@name IS NULL) BEGIN RAISERROR(12981, -1, -1, '@name') RETURN(1) -- Failure END IF (@plan_id IS NULL) BEGIN RAISERROR(12981, -1, -1, '@plan_id') RETURN(1) -- Failure END INSERT INTO msdb.dbo.sysmaintplan_subplans( subplan_id, plan_id, subp@an_description, subplan_name, job_id, schedule_id, msx_job_id) VALUES( @subplan_id, @plan_id, @description, @name, @job_id, @schedule_id, @msx_job_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_job_id UNIQUEIDENTIFIER SELECT @s_subplan_name = subplan_name, @s_job_id @ = job_id FROM msdb.dbo.sysmaintplan_subplans WHERE (@subplan_id = subplan_id) --Determine if user wants to change these variables IF (@name IS NOT NULL) SELECT @s_subplan_name = @name IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @description, @ job_id = @s_job_id, schedule_id = @schedule_id, msx_job_id = @msx_job_id WHERE (subplan_id = @subplan_id) END RETURN (@@ERROR) END R0k 8CREATE PROCEDURE sp_target_server_summary @target_server sysname = NULL AS BEGIN SET NOCOUNT ON SELECT server_id, server_name, 'local_time' = DATEADD(SS, DATEDIFF(SS, last_poll_date, GETDATE()), local_time_at_last_poll), l@st_poll_date, 'unread_instructions' = (SELECT COUNT(*) FROM msdb.dbo.sysdownloadlist sdl WHERE (UPPER(sdl.target_server) = UPPER(sts.server_name)) AND (sdl.status = 0)), 'blocked' = (SELECT COUNT(*) FROM msdb.dbo.sysdownloadlist sdl WHERE (UPPER(sdl.target_server) = UPPER(sts.server_name)) AND (sdl.error_message IS NOT @ULL)), poll_interval FROM msdb.dbo.systargetservers sts WHERE ((@target_server IS NULL) OR (UPPER(@target_server) = UPPER(sts.server_name))) END 0vnl 8CREATE PROCEDURE sp_maintplan_delete_plan @plan_id UNIQUEIDENTIFIER AS BEGIN SET NOCOUNT ON DECLARE @sp_id UNIQUEIDENTIFIER DECLARE @retval INT SET @retval = 0 --Loop through Subplans DECLARE sp CURSOR LOCAL FOR SELECT subplan_id FROM msdb.dbo.sysmain@plan_subplans WHERE plan_id = @plan_id FOR READ ONLY OPEN sp FETCH NEXT FROM sp INTO @sp_id WHILE @@FETCH_STATUS = 0 BEGIN EXECUTE @retval = sp_maintplan_delete_subplan @subplan_id = @sp_id IF(@retval <> 0) BREAK FETCH NEXT FROM sp INTO @sp_id END CLOSE sp DEALLOCATE sp RETURN (@retval) END 0(l 8CREATE PROCEDURE sp_uniquetaskname @seed NVARCHAR(92) AS BEGIN DECLARE @newest_suffix INT S@T NOCOUNT ON -- We're going to add a suffix of 8 characters so make sure the seed is at most 84 characters SELECT @seed = LTRIM(RTRIM(@seed)) IF (DATALENGTH(@seed) > 0) SELECT @seed = SUBSTRING(@seed, 1, 84) -- Find the newest (highest) suffix so far SELECT @newest_suffix = MAX(CONVERT(INT, RIGHT(name, 8))) FROM msdb.dbo.sysjobs -- DON'T use sysjobs_view here! WHERE (name LIKE N'%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]') -- Generate the task name by appending the 'newest@suffix' value (plus one) to the seed IF (@newest_suffix IS NOT NULL) BEGIN SELECT @newest_suffix = @newest_suffix + 1 SELECT 'TaskName' = CONVERT(NVARCHAR(92), @seed + REPLICATE(N'0', 8 - (DATALENGTH(CONVERT(NVARCHAR, @newest_suffix)) / 2)) + CONVERT(NVARCHAR, @newest_suffix)) END ELSE SELECT 'TaskName' = CONVERT(NVARCHAR(92), @seed + N'00000001') END 0Bm %8((0))RIM0Mm D8$h]d#3 = L<1@ <1  >1<1?  line1>1?<1@ ver_na>1i<1@< =yk e, 012"L1 >1 <1<, 08bm 8CREATE PROCEDURE sp_maintplan_st@rt @plan_id UNIQUEIDENTIFIER = NULL, @subplan_id UNIQUEIDENTIFIER = NULL AS BEGIN SET NOCOUNT ON DECLARE @jobid UNIQUEIDENTIFIER DECLARE @retval INT SET @retval = 0 -- A @plan_id or @subplan_id must be supplied IF (@plan_id IS NULL) AND (@subplan_id IS NULL) BEGIN RAISERROR(12982, -1, -1, '@plan_id', '@subplan_id') RETURN(1) END -- either @plan_id or @subplan_id must be exclusively set IF (@plan_id IS NOT NULL) @ND (@subplan_id IS NOT NULL) BEGIN RAISERROR(12982, -1, -1, '@plan_id', '@subplan_id') RETURN(1) END IF (@subplan_id IS NOT NULL) BEGIN -- subplan_id supplied so simply start the subplan's job SELECT @jobid = job_id FROM msdb.dbo.sysmaintplan_subplans WHERE subplan_id = @subplan_id if(@jobid IS NOT NULL) BEGIN EXEC @retval = msdb.dbo.sp_start_job @job_id = @jobid END END ELSE @ BEGIN -- Loop through Subplans and fire off all associated jobs DECLARE spj CURSOR LOCAL FOR SELECT job_id FROM msdb.dbo.sysmaintplan_subplans WHERE plan_id = @plan_id FOR READ ONLY OPEN spj FETCH NEXT FROM spj INTO @jobid WHILE (@@FETCH_STATUS = 0) BEGIN EXEC @retval = msdb.dbo.sp_start_job @job_id = @jobid IF(@retval <> 0) BREAK FETCH NEXT FROM spj INTO @j@bid END CLOSE spj DEALLOCATE spj END RETURN (@retval) END m < )֜Wi>1)1 )E0-8bm$$E@plan_id ) :l.5>17)1 )"68bm"@plan_id̅ ) ke5g>1)1)K0-8bm@$$K@subplan_idM ) MBM@e>1!)1p )(68bm(@subplan_id ) Ndm>1-"1"1"8bm " e*i>1-"1"a tt8bm " e*>1`K1K@8bm-~_ K >1K1K_-~_8bm K I>1`K1K8bm^= K >,>1`K1K^=8bm K ZfT?IC>1 aK1K-@8bm^= K cajob>1!fK1 Kn^=8bm K L?>1"bK1!K8bm^= K I/hh>1#lK1"K^=8bm K Oast>1$EAb1bD08bm@ @6<Dsp_start_jobdbomsdb b m+tar>1%xb00b268bm,2sp_start_jobdbo b #4sme>1&EBb1%bVm08bm @HNVsysmaintplan_subplansdbomsdb b a>1'Eb1bD68bm>DsyHmaintplan_subplansdbo b vW!E@e012"L1H.-,P,+0+*8*)@)(H('X'&`&%(%$x@0p8hphx(O@freqinterval0-Mm 88 M@freqsubtype0-Mm 88 U@freqsubintervalre0-Mm 88 _@freqrelativeiso Aa EtNa l EdP 01$fA> c1(\Vn!JoEA@32"L C*CreatProc transaction1  \Vn>11"1"Nc0,\VnP 2"L2"L Nsp_get_scriptu " pcFoa>1:"1"@(&\Vn(sp_get_script " Eop>1F"1"(&\Vn(sp_get_script " <>1z<"1"  \Vn  " 1?<1< 0\Vn 8CREATE PROCEDURE sp_get_script @name sysname AS BEGIN exec master.db@.xp_get_script @name END  < aute_sub>1R)1@,)?UE0-\Vn4?@name  ) Vn >1 )1p) N6\Vn@name ) o*D, >1 1"1"IFIR \Vn " pcFoNO>1 1"1 "@ = TRI\Vn " pcFo-A012"L1 one? 8X8HPx(T * FROM msdb.dbo.sysmaintplan_subplans WHERE subplan_id = @subplan_id) ) BEGIN -- Only allow creation of a record if user permits it IF(@allow_create = 0) BEGIN DECLARE @subplan_id_as_char VARCHAR(36) SELECT @subplan_id_as_char = CONVERT(VARCHAR(36), @subplan_id) RAISERROR(14262, -1, -1, '@subplan_id',@@subplan_id_as_char) RETURN(1) END --Insert it's a new subplan IF (@name IS NULL) BEGIN RAISERROR(12981, -1, -1, '@name') RETURN(1) -- Failure END IF (@plan_id IS NULL) BEGIN RAISERROR(12981, -1, -1, '@plan_id') RETURN(1) -- Failure END INSERT INTO msdb.dbo.sysmaintplan_subplans( subplan_id, plan_id, subplan_description, subplan_na@e, job_id, schedule_id, msx_job_id) VALUES( @subplan_id, @plan_id, @description, @name, @job_id, @schedule_id, @msx_job_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_job_id UNIQUEIDENTIFIER SELECT @s_subplan_name = subplan_name, @s_job_id = job_id FROM msdb.@bo.sysmaintplan_subplans WHERE (@subplan_id = subplan_id) --Determine if user wants to change these variables IF (@name IS NOT NULL) SELECT @s_subplan_name = @name IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @description, job_id = @s_job_id, H schedule_id = @schedule_id, msx_job_id = @msx_job_id WHERE (subplan_id = @subplan_id) END RETURN (@@ERROR) END  < Y|>1p)1@))K0-=yk$$K@subplan_id ) &gɬ>1p  )1@0)(6=yk(@subplan_id ) @@@@oPOP1oQ$> c1(!JoZ>pEA@33"L%CCREATE TABLEnsa1  !Jo>15"1 "R0,!Jo U 3"L3"L Rsysdbmaintplanst " _pl>1N"0("@&!Jo,sysdbmaintplans " vmpcan_>1"0`",&!Jo,sysdbmaintplans " 6_ma>1z?"1" !Jo " ѶF>15"1" !Jo " >1R )1 )@RE0-!Jo$$Cplan_idI ) JqZxH D>1 s)1>)  @6!Jo plan_id ) C41p >1 R!)1 )Gys0-!Jo4Gplan_name  ) EtVXT>1 s)1 )$CU6!Jo$plan_name @) [On_id >1 R")1 )Msp0-!Jo==Mdate_created  ) S YPD>1 )/)*d 6!Jo*date_created ) liqdTUR>1R#)1 )?0-!Jo4?owner  ) k,(H5>1@so)1 )6!Joowner ) `z` >1R$)1)U0-!Jo88 Umax_history_rows ) `CЁ>1)/)2,6!Jo2max_history_rowsv ) ݈] #>1R%)1)@_0-!Jo4_remote_history_server ) rTmP=>1R)1)<6!Jo<remote_history_server ) N6^>1R&)1)c0-!Jo88 cmax_remote_history_rows ) 1)>1@)1)@a6!Jo@max_remote_history_rows ) [@>1R')1)Qn0-!Jo88 Quser_defined_1 ) B>1)1;).p6!Jo.user_defined_1b ) D>1R()1@)Q0-!Jo 4Quser_defined_2MK ) Rh(>1)1).6!Jo .user_defined_2 ) 4Q23>1R))1)Qs0-!Jo ==Quser_defined_3 ) fFZgb>1)1@). 6!Jo .user_defined_3 ) moo܇>1R*)1)Qp0-!Jo $$Quser_defined_4 ) *- kb>1)1).b6!Jo .user_defined_4 ) 5DcH>15"1" @!Jo "  > c1(Z>p2q> c1 (2q&r>1?1>9}!Jo" @a  fZwb1"  }> c1!p_>1#@@1M I} ;  M$ s>1%51}  >1&U1>e:}$!  8g„>1'V1'>u:}@4  9 IM@d>1(W1(>u:}=  @"ڥh>1)X1)>:}4s  eSa>1*Y1*>:}8@a  )~, >1+Z1+>:}4  PK>1,[1,>:}8   Q; >1-\1->:}8$  @W>Y1G >1.]1.>s:} 4   hUK">1/^1/>s:} =(   /{A)>10_10>s:} $0   qc$11@.>12 616k0'!Jo+} kPK__sysdbmai__BE9F8F1D7132C993 6 {꽸]>13}616L6!JoLPK__sysdbmai__BE9F8F1D7132C993 6 }V&>14717!Jo 7@ Gy>15t717!Jo 7 X>16 <1<"0$17}>18?1" "}  fZw> c1$(&rsH@19  &r>1;?"1"p0,&rPK!Jo3"L3"L pPK__sysdbmai__BE9F8F1D7132C993 " WL>1<"1`"J/&&rJPK__sysdbmai__BE9F8F1D7132C993 " &} >1="1"J&&rJP@__sysdbmai__BE9F8F1D7132C993 " z>1>z"1" !Jo&r " Ǫ٦> c1:(s>6t1?  s>1AC"1<"p0,sD !Jo3"L3"L pDF__sysdbmain__date___731B1205 "@ !LR>1Bv!"/"J&sJDF__sysdbmain__date___731B1205 " di>@>1Cx!"/"J&sJDF__sysdbmain__date___731B1205 " t@>1Dz"1?" @!Jos " FƷ@>1ER"@1)%s!Jo ) S Y1F  !Jo>1GC"1B" hs " !LR1H  !Jo>1I<(<+0s@ +8(getdate()) < ?ݜ.9> c1@(>6twZu1@J  >6t@33"L&CSplitPage>>1M "1 co@z@1N"P1O",>1P"1P+vjXddzVXpHZNpJZRpd\p^XPLTpRVppNlpXppRP@,$kF ȃc!L!L vfk_MSdbms_datatype_mapping_map_id0,=yk P 1"L1"L jsp_maintplan_update_subplan0,gkU "L0"L Xsysmail_servertype0,kP "L"L dsp_target_server_summary0,lF ȃc!L!L fk_MSdbms_datatype_map@ing_dest_datatype_id.0,vnl P =2"L=2"L dsp_maintplan_delete_plan0,lPKgk"L"L zSYSMAIL_SERVERTYPE_TypeMustBeUniquee0,(lP ]"L]"L Vsp_uniquetaskname0,2 mF W !L!L fk_MSdbms_map_default_datatype_mapping_idB0,8bm P @2"L2"L Xsp_maintplan_start0,BmD gk"L"L pDF__sysmail_s__is_in__6D9742D90,MmP "L"L Hsp_addtask0,-WnV !L!L ZMSdatatype_mappingsa0,\Vn P 2"L2"L Nsp_get_script0,gnD gk"L"L pDF__sysmail_s__is_@u__6E8B67120,1R"1R  BO>1S"/pa>1>1T"/ " a$k01M3"L1Mn_g>1L#"1Q"pu0,>6tD !Jo3"L3"L pDF__sysdbm@in__owner__740F363E " ݫ>1Wv""1C"J&>6tJDF__sysdbmain__owner__740F363E " >huati>1Xx""1D"J&>6tJDF__sysdbmain__owner__740F363Ee " ˋdle>1Yz"1E" !Jo>6t "@ M^(L>1ZR#)1F)%>6t!Joe ) k,(H5e1[  !Jo>1\#"1W" >6t " ݫc1]  !Jo>1^<1J<C,0>6t@ C8(isnull(nt_client(),suser_sname())) < ~;Ime>@ c1K(wZu~u1_  wZu>1a'"1]"p0,wZuD !Jo3"L3"L pDF__sysdbmain__max_h__75035A77 " Z< ~>1bv""1X"Ja&wZuJDF__sysdbmain__max_h__75035A77 " bmes>1c@""1Y"J&wZuJDF__sysdbmain__max_h__75035A77 " ϮQ 88>1dz"1Z" !JowZuQu " kFil>1eR$)1[)%wZu!Jo) ) `CЁ1f  !Jo>1g'"1b"  88wZu@ " Z< ~1h  !Jo>1iu<.<%0wZu@ %8((0))  < qe> c1`(~uv 1j  ~u>1l"1T"p0,~uD !Jo3"L3"L pDF__sysdbmain__remot__75F77EB0 "@ LE>1mv$"1c"Jfi&~uJDF__sysdbmain__remot__75F77EB0 " ]J>1nx$"1d"Jf&~uJDF__sysdbmain__remot__75F77EB0 " _f;>1oz"1e"  !Jo~u " DT  >1pR%@1f)%~u!Jo88 ) rTmP=1q  !Jo>1r"1m" )~u " LE1s  !Jo>1tt<.<$0~u@ $8('') < Ĉ_-a> c1k(v"w 1u@  v>1w"1s"p0,vD !Jo3"L3"L pDF__sysdbmain__max_r__76EBA2E9 " ! R>1xv#"1n"J&vJDF__sysdbmain__max_r__76EBA2E9  " o˴>1yx#"1o"Jn&vJDF__sysdb@ain__max_r__76EBA2E9 " B:>1zz"1p" !Jov " {v䇷3>1{R&)1q)%v!Jo ) 11|  !Jo>1}"1x"  v " ! R81~  !Jo>1Ht<1u<%0v@ %8((0)) < bUC013"L1xNMMXM0MLHLKJJIIIHHXHGpGFF@EED@DDCCCBA8Ah@@@?H? ?>>>=<@1 1Ncit`l>1 c1c bp @"P1  Z $@1}>1 1.^t(161   01-3"L1@1 }`1 @1%}@'T"`1 @1 }T"P1@`1@1}j! 01-3"L1>11}|p@-3"Lh, j@All ad-hoc planssaB !Jo Vin01-3"L1IDENTIPp8 H `X(FIER = NULL, @name sysname = NULL, @description NVARCHAR(512) = NULL, @job_id UNIQUEIDENTIFIER = NULL, @schedule_id INT = NULL, @allow_create BIT = 0, @msx_job_id UNIQUEIDENTIFIER = NULL AS BEGIN SET NOCOUNT ON S@LECT @name = LTRIM(RTRIM(@name)) SELECT @description = LTRIM(RTRIM(@description)) --Are we creating a new entry or updating an existing one? IF( NOT EXISTS(SELECT * FROM msdb.dbo.sysmaintplan_subplans WHERE subplan_id = @subplan_id) ) BEGIN -- Only allow creation of a record if user permits it IF(@allow_create = 0) BEGIN DECLARE @subplan_id_as_char VARCHAR(36) SELECT @subplan_id_as_char = CONVERT(VARCHAR(36), @subplan_id) @RAISERROR(14262, -1, -1, '@subplan_id', @subplan_id_as_char) RETURN(1) END --Insert it's a new subplan IF (@name IS NULL) BEGIN RAISERROR(12981, -1, -1, '@name') RETURN(1) -- Failure END IF (@plan_id IS NULL) BEGIN RAISERROR(12981, -1, -1, '@plan_id') RETURN(1) -- Failure END INSERT INTO msdb.dbo.sysmaintplan_subplans( subplan_id, plan_id, subp@an_description, subplan_name, job_id, schedule_id, msx_job_id) VALUES( @subplan_id, @plan_id, @description, @name, @job_id, @schedule_id, @msx_job_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_job_id UNIQUEIDENTIFIER SELECT @s_subplan_name = subplan_name, @s_job_id H = job_id FROM msdb.dbo.sysmaintplan_subplans WHERE (@subplan_id = subplan_id) --Determine if user wants to change these variables IF (@name IS NOT NULL) SELECT @s_subplan_name = @name IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @description,@@@@nP8 1-]>> c1v("w[xEA@3L3"L2CCREATE TABLEnsa1  "w>1 "1~"Z0,"w U L3"LL3"L Zsysdbmaintplan_jobsp " vFoa>1N"1"@4&"w4sysdbmaintplan_jobs " mL>1"1"4s&"w4sysdbmaintplan_jobs " ԬX&<>1zT"1{" "w> " ש 1>1 "1" REAE P"w " vam>1U )(@,)C 0-"w$$Cplan_id ) ͛5tUE>1 s)1) )6"w plan_id ) Pה(>1 U )1 )A0-"w$$Ajob_id" ) WCFIR >1 )1)6"w@job_id ) '*U">1  "1""w " vb.> c1([xy -> c1(y3zte =>1 @19>) 9~"w"''$' @  %U" 1  ~@> c1ew s>1A1M81I~ an_  d+t-IN>151&- ~   l&Ebo>1`11> :~$@    @n >1a1> :~$   -\ $1~ule_>16.6ke 0'"wK~ kUQ__sysdbmai__F87CA47779C80F94_ 6 L( subpl>1}16146Lb.@"wLUQ__sysdbmai__F87CA47779C80F94 6 LQ)ts to >1%7157s_"w  7 ܚDT >17167TE"w  7 ڶ]intpla>1&717 "wesc 7 vujo>1@17ed"w  7 [h; @msx_>1</<" (0<"w " < H%撽$1~>1@1 "an_i~  %U">1> c1(3zX{1   3z>1@""1 "p0,3zUQ"wL3"LL3"L pUQ__sysdbmai__F87CA47779C80F94 "  5>1#"1"Ji&3zJUQ__sysdbmai__F87CA47779C80F94 " T}HH>1$T"0P"J)&3zJUQ__sysdbmai__F87CA47779C@0F94 " +O>1%z"1" "w3z " G'Z> c1!(X{?|| 1&  X{>1("1#"p0,X{F "wL3"LL3"L pFK__sysdbmain__plan___7BB05806 " D8yk>1)#@1"J&X{JFK__sysdbmain__plan___7BB05806 " Oeg>1*#"1"J&X{JFK__sysdbmain__plan___7BB05806 " ched>1+z"1&" i"wX{ " @:eqp1,  !Jo1-  "w@>1."1h"$Lhh!Jo " >1/J1JX{!Jo J wp1>10cJ1Jl!JoX{ J >11J10JX{"w J xlet>12@J11J"wX{@ J 7h )>13J12JX{!Jo J WFktj>14c J13J!JoX{  J ;b~l>115  "w>16"1)" npX{ " D8^01@L3"L1=ykX`hp@(xX ` h  X8(h`x(k^= K j-2i>1p_K1pK^==yk  K ُ8>nts>1pOK1pK=yk^= K &Fle>1p`K1pK@x$^==yk K \1p PK1pKi=yk^= K q,6>1p!bK1p K^==yks K ;pal>1p"QK1p!K=yk^= K -O>1p#gK1p"Kb^=H=yk  K #UΎ8>1p$RK1p#K=yk^= K {44!er>1p%iK1p$K^==yk K Je:sys>1p&SK1p%K=yk^= KX`hp@(xX ` h  X8(@@c"876@2P^|GP 2H> c1'(?||x}EA@3j3"L9CCREATE TABLEnsa2  ?||>2""17"d0,?|| U j3"Lj3"L dsysdbmaintplan_databases " e@G>2N"1@">s&?||>sysdbmaintplan_databases " f'>2"1">n&?||>sysdbmaintplan_databases " x >2zc"1," ?|| " )vUV>2""2" ?|| " e@G@@3j3"L:CSplitPageI >2  )1c)@@2 )P2 )T--!Jo>2 )2 4UQGGCIIKEKQ]GKKQGKUQGEMZIIS_CME=KIKU[?ak[Ya]YWWSKG0-vO|4@U@credential_name"0-vO|88 Q@credential_id0-vO|88 G@proxy_id0-|Gcommit_ts0-|Cxdes_id0-|Icommit_lbn0-|Icommit_csn0-|@==Kcommit_timeJ0-|88 Edbfragid0-}4K@alert_name0-}4Q@operator_name`C0-}00]@notification_methodm0-C}88 G@proxy_id0-C}4@K@proxy_name0-̴~4K@alert_namee0-̴~4Q@operator_name0-7~88 G@proxy_id0-7~4K@proxy_name0-7~4U@credential_namex_0-7~88 Q@credential_id@-7~4G@new_name0-7~00E@enabled@0-7~4M@descriptionJo0-~88 MZmailitem_id 0-~88 Iprofile_id0-~4@Irecipients0-~4@@Scopy_recipientso0-~4@_blind_copy_recipients0-~4Csubject0-~4@Mfrom_addressQ20-~4@Ereply_to0-~ 4@=bodyer0-~ 4Kbody_format0-~ @4Iimportance_0-~ 4 Ksensitivity0-~ 4@Ufile_attachments0-~4[attachment_encoding0-~4@?query0-~4aexecute_query_database0-~hh@kattach_query_result_as_file0-~hh[query_result_header0-~88 Yquery_result_width0-~4aquery_result_separator0-~hh]exclude_query_output0-~hhYap@pend_query_error0-~==MWsend_request_date 0-~4;Wsend_request_user0-~88 Ssent_account_id0-~00_Ksent_status0-~==Gsent_date<2  T2).2@>2T)2>(>2).T=>2o.)1@-)vO|102 k3"L2 >2 )2 )C0-?||$$Cplan_id ) y8>2@s)1 ) 6?|| plan_id ) m/>2 )2)O0-?||4Odatabase_name ) 2 )2 c@@2)@P2) >2)2b:$$ .(((( &&($8>""<<<<<888888$0000022 ((& &$*@,,"" "8>,(,,,,62"""$(8*6cid6class6,class61class63class6:@class6;class6@class6Aclass6Jclass6Kclass6Nclass6^class6aclass6$ :cmdexec_success_codeJ6 $cmprlevel6#P $code_page6  colguid6)colid6#P (.collation_nameJo6) (collati@nid62(collationid63 (collationid6u\{(column_guid6$  command6EG  command6|&commit_csn"6|&commit_lbn6|(commit_time6|$commit_ts6#P 8compatibility_level6\compid>6#P <>compressed_backup_size6~ < @"computer6I "contract6a<conversation_group_id6uc<conversation_group_id6Xv<conversation_group_id6x<conversation_group_id6<8z<conversation_group_id68conversation_handle6a8conversation_handle6uc8conversatio@_handle6Xv8conversation_handle6x8conversation_handle6<8z8conversation_handle6I $convgroup63 0copy_recipients6' 0copy_recipients6 0copy_recipients62 0copy_recipients6~0copy_recipients6':2count_reset_date"@':2count_reset_time6R cprelid6!(create_date6%(create_date6]>&create_lsn6 created6"  created6, created62  created6: created6@ created6` created6 7)&createdate 6 $createlsn6`MS@*createparams65I@credential_date_created65I,credential_id6gq,credential_id6crend6"crerrors6crrows>6 "crschver6 crstart6 "crtsnextet6crtype6^crypto6#P 8database_backup_lsn6#P@>database_creation_date6#P 8,database_guid6%(database_id6#P ",database_name6$ ,database_name6{94#,database_name6':,database_name6$ 6database_user_name6#P 2database_versionj6ȃc "datalossd6f{n"datalossp6R@"datasizec66 $dataspace6`MS(datatype_id6ȃc8datatype_mapping_id6RD*date_createdu<2 T)1Q`L>2)2"L>2)1 ȃc>2r)0P&)p@cidaty02k3"L2"L>2W)2),6?||,database_name ) jYPE>2 ""2""?|| " e@Gs> c2(x}Č~bm> c2"(Č~>2@!A1 >a9?||"_  !JPi2$  > c2#>2%B1MVnI gn  B#_] ">2'51@B  O)">2(b1>:$Jo  Yl,ʛ">2)c2)> g:4l  YmB'B$2*L>2+ 616ko0'?||K@ kUQ__sysdbmai__AEEEF1DB7E8CC4B1 6 [h!p>2,}1616L6?||LUQ__sysdbmai__AEEEF1DB7E8CC4B1 6 brKFN>2-K717,?|| 7 Bxm>2.717L?||@e 7 H6N>2/L72.7?|| 7 vꏼ%d@3k3"L21 72cu`,>22 7 p\4r@237P2@47dbm>257257" ʂ-15`26*(g 77!7021k3"L21@3k3"L=CvSplitPager,>29 722c__`s>2@: 723:Xv@2;7P2<78u>2=72=_~864<2> 72/_a>2?72?Pnt_>2@@267)~029k3"L29>2072@7?||a 7 #WQT>2C <1<"01$2DQ>2EA2$ "pF @ !JPr__> c2&(# u12F  >2H/"2!"p 0,UQ?||k3"Lk3"L pUQ__sysdbmai__AEEEF1DB7E8CC4B1 " $Jn>2I"1$"J&JUQ__sysdbmai__AEEEF1DB7E8CC4B1 "@ ZoL>2JT"1%"J&JUQ__sysdbmai__AEEEF1DB7E8CC4B1  " @&M\>2Kz"2" ?|| " ']> c2G(# u\1i2L  # u>2Nt/"."pe0,# u@F ?||k3"Lk3"L pFK__sysdbmain__plan___00750D23 " ' h>2O#"1*"J&# uJFK__sysdbmain__plan___00750D23h " 6+ ">2P#"1+"J&# uJFK__sysdbmain__plan___00750D237 " j">2Qz"2@L" ?||# u " cz__s2R  !Jo2S  ?||>2T"1/"$L!JkwZ!Jo " >2UJ14J# u!Jo J 1>2VcJ15J!Jo# u J SpK0Zu@>2WJ2VJ# u?|| J R>2XcJ2WJe?||# u J g`[]`>2Y J2XJ# u!Jo J :SC!">2Zc J2YJF!Jo# ui J Y:wH5F72[@  ?||>2\t/"2O" uD# u " ' he02k3"L2FFExEDDDCCBpBHBA(Ax@??0?>>`=1pR%@1f)%~u!Jo88 ) rTmP=1q  !Jo>1r"1m" )~u " LE1s  !Jo>1tt<.<$0~u@ $8('') < Ĉ_-a> c1k(v"w 1u@  v>1w"1s"p0,vD !Jo3"L3"L pDF__sysdbmain__max_r__76EBA2E9 " ! R>1xv#"1n"J&vJDF__sysdbmain__max_r__76EBA2E9  " o˴>1yx#"1o"Jn&vJDF__sysdb@ain__max_r__76EBA2E9 " B:>1zz"1p" !Jov " {v䇷3>1{R&)1q)%v!Jo ) 11|  !Jo>1}"1x"  v " ! R81~  !Jo>1Ht<1u<%0v@ %8((0)) < bUC013"L1xNMMXM0MLHLKJJIIIHHXHGpGFF@EED@DDCCCBA8Ah@@@?H? ?>>>=<@ c2M(\1iU]SE@33"LGCCREATE TABLERoo28  \1i>28t4"2]"`0,\1i U 3"L3"L `sysdbmaintplan_history " p& w>28O"2"@:&\1i:sysdbmaintplan_history " Ba@1>28"2":&\1i:sysdbmaintplan_history " `>28z1"2R" \1i " <>28t4"28" `\1i " p& w>28@7))(*)K0-\1i88 Ksequence_id ) ۣ3>28 )18)(6\1i(sequence_id ) kF 28 \1i28  \1i>28 .7)28 ) 00KM\1i ) ۣ3KMZj@->28 .8)28 )C0-\1i$$Cplan_id ) ,& = >28s)2) n 6\1i plan_id ) <:m/EI>28.9)28)G 0-\1i4Gplan_nameN ) ÃBE>28s@28)$SE6\1i$plan_name ) "幋 we cr>28.:)28)OEL0-\1i4Odatabase_name  ) 02 a>28S)2 ), =6\1i,database_name ) l(1R(36) >28.;)28)Kn_0-\1i@4Kserver_namer ) ¥J >28)28 )(L)6\1i(server_name ) ֊6 >28.<)28)E 0-\1i4EactivityTUR ) )*F E>28)2)"ub6\1i"activity  )@ C>ption,>28.=)28)G_i0-\1ihhGsucceeded  ) ЖkJ >28N)1)$ 6\1i$succeeded ) Cs ELSE>28.>)28)E 0-\1i==Eend_timeame ) Y8We,>28@)1N)"sm6\1i"end_timeub ) Hx[ >28.?)28)Ee 0-\1i 88 EdurationIF  ) 鯲 >28)28)"ec6\1i "durationin ) (E SET>28.@)28)Ion0-\1i ==@Istart_time  ) @ v@sched>28b)28)&ub6\1i &start_time  ) R>28<1<Iar0\1i  I8(dateadd(second, -[duration],[end_time]))CT  < 7erver_>28 .A)28)M G0-\1i 88 @Merror_numberad_ ) T >28!!)28)*st6\1i *error_numberRE ) ver) =>28".B)28!)Cst0-\1i 4Cmessage  ) >eownloa>28#)1 ) R(6\1i  message ) JLor>28$@t4"28"tse ver\1i " p& wr >28%t4"28%"vn\1i " p& wCE>28&B2F>GI9\1i" E)   xAT 28'  > c28ROM >28(@C2'MREI ATU  ]65hR E>28*52(    n/Ng N>28+d2*>RE:8 P  mX$M$na>28,e28,> S@:$er  l d >28-f28->DA:44)  t aU$st>28.g28.>IG:4ew  LVHLI>28/h28/>ta:@4he  I=Kuf>280i280>+ :4CA  U}iQTH>281j281>su:hR(  1xS]1'>282k282> :=@  %7}ְ>283l283>: 8!   {AU>284m284>i: 8%    285n285>: 4   SYtin$2@6QUEI>2876/-6+AS'\1i @ 6 rNR >288~6186 pl\1i 6 an_id $289 B>28:B28' "TUR(1)  xA or @s> c28)(@U]yQn_id> c28<(yQEn_id>28;C28;>EG9\1i  n'   )RT 28>  > c28= IS >28?D28*M_jI@ Loo  qAF_ f>28A528+    =Qə֋o.>28Bo286>ON:8   (h!WTA>28Cp28C>ob:   ,FmET$28D@ END28E  \1i>28F62886ki0'\1iK kUQ__sysdbmai__B2649B25035179CE 6 jan_>28G}262-6L6\1iLUQ__sysdbmai__B2649B25035179CE 6 X5%>1>28HZ71`7bm@\1i 7 :Ol@33"LHC!SplitPage)>28J 72:c N`m>28K 72;@@28L7P28M7>28N72@Naaa@bb bbbbbmb bbbb5I^5IKZ=hhZ=ii=~1=~1Kv%stv%v%8b@< _Z3bZ3mZ3WWb{ { 2#P j#P b#P e@@]>8b]>NRDpRDaRDRD#,#,8Piy@znzdyt yt$ 2"$ $ +0+$ &`&$ !h]!re{94#l{94#{94#{94#re%_'_'_'rec(rv 7)  7) 7)_H08H0`H0@88 5 5@f 5reC"6rC"6j89ct9da9':':Q`u;nd`u;Mmi<i<~ <es^=ofAa Du}F[u}FndIyJeQeQexe@ti`MS`MS`MSexWivW W W unWMWWWmaW orW MmW W  WatW-׶l\ ׶l\aryaMma4aanda@88aa@lampavea 88-%b-%b@eȃcleȃclmȃcȃcȃcesȃconȃc`ucucagucalucMmucucucjeucMmucucuc jeJEf@-JEf gk!JoidgqccgqXv@pXvsXvXvXvmdXvesXvMmXv4XvXvorXv -"w "wxegx<x xxxx@xxxx <8z<8z<8z><8z<8z<8z<8z<8z<8z1"<8z<8z =z:u\{)u\{&u\{u\{u\{ucu\{ u\{u\{u\{|@|̅|u| ?||?||<28O 72C==>28P728P _bi>28Q72>̅>28R72A7a028J3"L28J>2@I728O7\1i 7 H=WEM)>28U</1<"0<\1i " < ?;)>28Vt4"28&"$rror\1i " p& w $28Wc>28XC28>  ub   )@>1> c28@(E@928Y  E>28[t@"28W"p0,EUQ\1i3"L3"L pUQ__sysdbmai__B2649B25035179CE " tc>28\"2J"Jj&EJUQ__sysdbmai__B2649B25035179CE " `9@>28]U"2K"J&EJUQ__sysdbmai__B2649B25035179CE " 0Kgv">28^zp"28" \1iE " 5RH "> c28Z(@9y-28_  @9>28atD"28\"p0,@9D \1i3"@3"L pDF__sysdbmain__plan___0539C240 " K5>28bv%"1y"J&@9JDF__sysdbmain__plan___0539C240 " >28cx%"1z"J&@9JDF__sysdbmain__plan___0539C240 " .>28dzq"28_"@ \1i@9 " 7Y1 AV5>28e.8)28#)%@9\1i ) ,&28f  \1i>28gtD"28b" K@9 " K528h  \1i>28i<.<H0@9 H8('00000000-0000-0000-0000-000000000000')@ < %H > c28`(y- "28j  y->28l"/"p0,y-D \1i3"L3"L pDF__sysdbmain__plan___062DE679 " >28mv&"28c"Je&y-JDF__sysdbmain__plan___062DE679 "@ K>28nx&"28d"J&y-JDF__sysdbmain__plan___062DE679> " O>28ozr"28e" \1iy- " wq%>28p.9)28f)%y-\1i ) Ã28q  \1i>28r"28m@" y- " 28s  \1i>28t<28j<40y- 48('All ad-hoc plans') < v@ ,) > c28k( ".28u  ">28w"28s"p0, "D \1i3"L3"L pDF__sy@dbmain__serve__07220AB2 " *A>28xv("28n"J& "JDF__sysdbmain__serve__07220AB26 " ɏ_c>28yx("28o"J& "JDF__sysdbmain__serve__07220AB2 " ˭3zT>28zzs"28p" \1i " @" e1>28{.;)28q)% "\1id ) ¥Jb28|  \1i>28}"28x" Fy " " *Ae28~  \1i>28<.<SK0 " S8(CONVERT([sysname],serverproperty('ServerName'),0))) < y@ $x#"> c28v(.$S 128  .>28 "28~"p0,.D \1i3"L3"L pDF__sysdbmain__succe__08162EEB " o8>28v)"28y"J7&.JDF__sysdbmain__succe__08162EEB " Q+@>28x)"28z"J&.JDF__sysdbmain__succe__08162EEB< " $1>28zt"28{" \1i. "  qe>28.=)28|)%.\1i ) ЖkJ|28  \1i>28 "28" @|. " o828  \1i>28<28<%0. %8((1)) < r-x> c28($S ]w 28  $S @33"LICSplitPage>28 "28Kc@@@28"P28",>28"28*pvpRdppffb^p\prvpXhHXBpRhdRNppdLpp`JJPj0,1oVP  !L !L psp_verify_schedule_identifiers0,[yC { !L!L vCK_originating_serve@_id_MustBe_10,D 6'"L'"L pDF__sysmail_a__last___10E07F160,@U  "L "L Rbackupfilegroup0,jJP e!Le!L dsp_verify_jobproc_caller0,D { !L!L pDF__sysorigin__origi__117F9D940,OD 6'"L'"L pDF__sysmail_@__last___11D4A34F0,>P !L!L fsp_downloaded_row_limiter0,sC { !L!L fCK_master_server_MustBe_10,V y"Ly"L bsysmail_mailattachmentss0,2P !L!L ^sp_post_msx_operation 0,gD { !L!L pDF__sysori@in__maste__1367E6060,U "L"L \sysmail_send_retries0,PK@ "L "L pPK__backupfi__760CD67A12FDD1B20,'P t!Lt!L rsp_verify_performance_conditionk0,? \TR{ O!LO!L vtrig_sysoriginatingservers_delete0,$F @ "@ "L pFK__backupfil__backu__14E61A240,N$P !L!L Xsp_verify_job_date0,x.PV !L!L hsysoriginatingservers_view0,]>U  "L "L Hbackupfile0,HP '!L'!L Xsp_verify_job_time0,RDU !L2!L Bsysjobsu<0,lX@PK"L"L pPK__sysmail___C010B7E115A534330,lP !L!L Rsp_verify_alert0,v8TRRD!L!L htrig_sysjobs_insert_update0,|@F "L"L dFK_mailitems_mailitem_id0,P !L!L Rsp_update_alert0,#,U "!L%!@ Nsysjobservers 0,ޠD "L"L pDF__sysmail_s__send___1881A0DE0,PK]> "L "L pPK__backupfi__57D1800A17C286CF0,2P B!LB!L dsp_delete_job_references0,\ V {!L{!L Lsysjobs_view0,uD "L"L pDF__sysmai@_s__last___1975C5170,AϪF ]> "L "L pFK__backupfil__backu__19AACF410,kP !L!L `sp_delete_all_msx_jobs0,U !L!L JsyssessionsK0,PiU  "L}"L Jsysmail_log0,zU  "L7 "L Prestorehistory0,P !@!L sp_generate_target_server_job_assignment_sql0, ^PKPi"L"L jsysmail_log_id_MustBeUnique<28 &"28(>28"28K>28"/!>28"1U"@ 1oV.0283"L28>28"28"p0,$S D \1i3"L3"L pDF__sysdbmain__end_t__090A5324 " A>28v""28"J&$S JDF__sysdbmain__end_t__090A5324 " xOVK>28x""2@"J&$S JDF__sysdbmain__end_t__090A5324> " ̟n>28zu"28" \1i$S  " 3>28.>)28)%$S \1i% ) Y8W28  \1i>28"28" $S  " @A28  \1i>28<.<+b0$S  +8(getdate()) < MHb> c28(]w  28  ]w >28"28"pe0,]w D \1i 3"L3"L pDF__sysdbmain__durat__09FE775D " @h.(@>28v""28"JH&]w JDF__sysdbmain__durat__09FE775D " W~k>28x""28"J&]w JDF__sysdbmain__durat__09FE775D " wGC_>28zv"28" \1i]w  " >28.?)2@)%]w \1i l ) 鯲28  \1i>28"28" /]w  " h. 28  \1i>28<.<%0]w  %8((0)) < {j> c28( Ͽ j28@  >28"28"p0, D \1i 3"L3"L pDF__sysdbmain__error__0AF29B96 " Y#>28v$"28"J& JDF__sysdbmain__error__0AF29B96o " DQ9>28x$"28"J& JDF__sysdbmain@_error__0AF29B96 " L5'>28zw"28" \1i  " NwqMޅ >28.A)28)% \1i  ) 28  \1i>28"28"   " Y#28  \1i>28@<28<%0  %8((0)) < &ʧ >28 K1P K\1i \1i K g*%d>28iK1 Ku\1i\1i u K dL>28 K28Ku\1i \1i  K fNp`hj>28@K28Kl\1i \1i l K *&oPTr0283"L28lu"`xwhwvpvuuPu(ut@tsrrqqqpxpPpohonn8mml0llkpkjji(iXh hgpggfVHVVUXU0UTXT0TSS SRRPQPXPPPO(ONNNMLHLxKPKKhJ@JII0IHH`GFhFFpEHEDD8DCChBApA A@@P?>X>>=h=SNr^?SN@As@GOp7D[Esp7DG[EFbI2kI2yJiMdJiMJiMtJiMJiMjq}_MU0Qoq}_M2$R0SNMmpVS{ TVS9Ub{ TMmrUxZyV@ WdVVTYȜ[\t;++ftOgo|6joSNoo9U0oVpo7ep9>bpA8YpVypxZdqh qt0sh  0stj0sLoTt{ T0.v+p.vO.vtb.vL-.vy.vd.vH.v[Et.vG.vC}j.v7~ogwF0gwvO|pgw7~~x+b~xL:~xo4<y~x syl sy+ syOj syg sy.gztbKR[{vO|d/+h <'o|  K'hyys>'p|i_88LlLLgarMsLR8Q88).Pa-02x@33"LJCwCREATE INDEX2x  \1i2x \1i1>2xD28Y>9\1i" ?)"  <Gy2x  > c28@>2xE28AMI   XNs>2x528BT  "2>2xq28D>:8 P  9/Kg >2x r2x @>:$l  ,>2x s2x >:8   Ajj>2x t2x >$$:4  ,d]2>2x u2x >:@4  (6>2x v2x >b.:4  5*'>2xw2x> =:4  Ps>2xx2x> :h@   EVv8>2xy2x>A: =   >2xz2x>: 8!   \.3 H>2x{2x>: 8%  @ bX:D>2x|2x>: 4   Go>V1$2x>2xE2x>9\1i  U  wJ_2x  > c2x>2@F2xM9I   :>2x52x  qLT|>2x}2x>:8   Hyc@33"LKC@SplitPage>2x 28c@@2xP2x:>2x2xn~>2x W .02x3"L2x3z>2@2x>:$y  MM@.C>2x#2x#>:8U  Q&8"_$2x$ $2x%$>2x&C2x>9\1i  @   )R>2x'o2x >:8  (h!W!6 2xK>2x(p2x(>:  ,Fmdbm>2x*52x @ =Qə֋">2x+D2xMI   qAF_">2x,t4"28h"$7B\1i " p& w>2x-628G6! iX\1i 6 j1>2x.}2628H6L6\1i@LUQ__sysdbmai__B2649B25035179CE 6 X5%"6 62x) >2x/62x.6k0'\1iK kUQ__sysdbmai__B2649B25035179CE 6 j6 62x0 >2x1728U7\1i 7 @=WEM6 72x2>2x3Z728I7\1i 7 :O6 72x4>2x5<28V<"0<\1i " < ?; 6 <2x63$2x7{>2x9B2@'>9\1i E)  xAX>2x:d2x*>:8K  mX$M$^=>2x;e2x;>:$  l &F>2x<f2x<>:@4>  t aU$P>2x=g2x=>:4  LVH>2x>h2x>>:4  I=K >2x?i2x?>:4@   U}iQ$>2x@j2x@>:h  1xS]$>2xAk2xA>:=  %7}ְ^>2xBl2xB>: 8!  @ {AU >2xCm2xC>: 8% u  2xDn2xD>: 4 t  SYtnsd>2xE52x+   n/NgH>2xFC2x,@MI x  ]65hR(= >2xG62x16!  \1i 6 rNtable >2xH~62896 \1i 6 iv6 62x8>2xI62xH6+'\1i@ O 6 rNti>2xK62xK69e 0'\1i 9clust B 6 ꀄeBc < 4)>2xL~u62xI6 6\1iclust - 6 Lrior no.>2xMZ72x57 \1i  7 ѩ*Zo >2xN72x37@IS\1i@ms 7 T?Zq >2xO<2x7<"so0<\1i "  < dursor >2xPt4"2x-"$trat_n\1i " p& we_$2xQAX),>2xRD2x: " OEN   <G the f2xS  \1i@>2xT62xL6k 0'\1iK kUQ__sysdbmai__B2649B25035179CE  6 j >2xU}262x/6L 6\1iLUQ__sysdbmai__B2649B25035179CE 6 X5%l mess6 62xJ >2xV[72xN7 @\1i xm 7 :O 6 72xW>2xX72xO7es\1i  7 H=WEM N'<6 72xY>2xZ<2xP<"N 0<\1i " m < ?;s not 6 <2x[3>2x\t4@2xQ"$oces i\1i " p& wEG$2x^SELE>2x_E2xS    wJ= Mail02x3"L2xreques,x,P,++ +*p*8*))(('`'8'&@&%H%$($#h##"!X!  x8Xxx@``8(`8`p  x  p 0Pp0( -H get account information SELECT @profile_id = profile_id FROM sysmail_mailitems WHERE mailitem_id = @mailitem_id IF(@profile_id IS NULL) -- mail item has been deleted from the database BEGIN -- log warning SET @localmessage = FORMATMESSAGE(14667, convert(NVARCHAR(50), @mailitem_id)) exec msdb.dbo.sysmail_logmaileH"xHxxP?@02IZD@33"LQC|UpdateQPStats2 "@33"LRCSplitPage>2 <2x]c%@3"@2<P2!<9@">2!<2 e0<$ q!L?;FF@C@z0G^u@-D[r*AXo'>Ul $;Ri !8Of}5L@c????? ??? ??? ????????????????????!???#??$??+???-???/???1???3???5???7???9@???;???=???????A???C???E???G???I???K???M???O???Q???S???U???W???Y???[???]???_???a???c???e@???g???i???k???m???o???q???s???u???w???y???{???}?????q???s???u???w???y???{???}?????@???????????0<"$GL55?萚<$$@TB@\d 7N@|4Kby1H_v.E?????????????????????"??)??,@??.??1???3??6??7??:???<??@??A?@?E?@?I???K??N??R??U??Z???\???^???`???b??u???˿w@???y???u\{??|50<"$GL55??萚<萚< BTB?@"5A@$TB?5<2@ <!>2<29~!>2 9<x ~!88>2 <1<~<!023"L2~@33"LSCSplitPage2>2  @2c&@@2<P2"<!9>2"<20<"$GL55?萚<$$@TB@@\d 7Ne|4Kby1H_v.E???????@??????????????"??)??,??.??1???3??6??7??:???<??@??A?@?E?@?I???K??N??R?@?U??Z???\???^???`???b??u???˿w???y???u\{??|50<"$GL55??萚<萚< BTB?@"5A@@$TB?5<2 !<2"n">2!<29i"|>29<2 !l"l6\>2<2 <a<""6~ 02@ 3"L2 con>2"<2<1GL55?萚<$$@TB@\d 7N@|4Kby1H_v.E?????????????????????"??)??,@??.??1???3??6??7??:???<??@??A?@?E?@?I???K??N??R??U??Z???\???^???`???b??u???˿w@???y???u\{??|5aOA3"L//?y:@ D@g $;Ri@ !8Of}5Lcz  2 I ` w   / F ] t  , C Z q  ) @ W n  & = T k #:Qh  7Ne|4Kby1H_v@.E\s+BYp(?Vm%<Sj "9P???@????????@@?"@?@@?1?@@?7???;???@???C???E???H???J?@?]?@@?a???h ?@@?w!???5I???;???O???_???t????A??@@??@@?W?@@?9K?@@?N]? ???q ???]w ???h ??? ???\ ??? ???Mޅ ???2 ???k???6???Jb???Z???1oV??????jJ???O???s???2?@@?'?@@?x.P?@@?lX?@?2@?@@?k?@@??@?Oj???4z:????@@????" ???֌ ?@@?3!???B@"???{94#???S#???g]$???w$???Q%?@@?PE&???_'???n'???-(?@@?")?@@?Q*?@@?Ru+@?@?-?@@?Q.?@@?/?@@?>0?@@?b1?@@?52?@@?n3???S)4?@@?5?@@?6?@@?'7?@@?7L7?@@?pp8???ĄX9???9???L:?@@?6@;???;???o4<???T<???)=???%=@??? DR>???^????m????S@?@@?@???qA???A???wB???(C???7C???#`D???p7D???UGTE???[E???kHF???F???ǏLJ@G$R?"1!U0@@QL @/a<"D < 4Z 023"L2>0 @p0H8p ( " ']> c2G(# u\1i2L  # u>2Nt/"."?~@@e<ePP@25x:Q@33"LTCiUpdateQPStats2 ">2"<2< <,,,,p h<,,<" < ߧmi%GL55??萚<萚<A3"L//??y:y:@FYB D?@F5B@ BTB?@"5A@$TB?5lt D?LJ@G?@@/)023"L2 (Ksequence_id ) ۣ3>28 )18)(6\1i(sequence_id ) kF 28 \1i28  \1i>28 .7)28 ) 00KM\1i ) ۣ3KMZj@->28 .8)28 )C0-\1i$$Cplan_id ) ,& = >28s)2) n 6\1i plan_id ) <:m/EI>28.9)28)G 0-\1i4Gplan_nameN ) ÃBE>28s@28)$SE6\1i$plan_name ) "幋 we cr>28.:)28)OEL0-\1i4Odatabase_name  ) 02 a>28S)2 ), =6\1i,database_name ) l(1R(36) >28.;)28)Kn_0-\1i@4Kserver_namer ) ¥J >28)28 )(L)6\1i(server_name ) ֊6 >28.<)28)E 0-\1i4EactivityTUR ) )*F E>28)2)"ub6\1i"activity  )@ C>ption,>28.=)28)G_i0-\1ihhGsucceeded  ) ЖkJ >28N)1)$ 6\1i$succeeded ) Cs ELSE>28.>)28)E 0-\1i==Eend_timeame ) Y8We,>28H)1N)"sm6\1i"end_timeub ) Hx[ >28.?)28)Ee 0-\1i 88 EdurationIF  ) 鯲 >28)28)"ec6\1i "durationin ) (E SET>28.@)28)Ion0-\1i ==@@@@@Pv[`2Q@33"LUCwUpdateQPStats2 "2@33"LVCDSpaceAlloc62<1 e?>2 <2c, >2 <2c,@@62 <(e@2<6c1eP2(<T2  (023"L2>2 (<2 <A D|  < 4 @2,A@>2 (<2 <Ah3"L//?y:y:y:y:FYB DF5B@?@V;AAA0cg@ ` Y R K D = 6/({!tSLE>5~1*}#V+t'@b >H Dq2 P !V!!!"@"""#J###$X$$$%N%%%&J&&&-'h'''(p(((?)l)))*R***1+@+++E,,,"-o---&.W..../V/}///0_00001J1{112`222!3j333=444R555A666 7A7p77778i8889G999:a::;@0??3agent_datetime0?@?9backupmediafamily0???)backupset0???YCK_originating_server_id_MustBe_10?@@?Idefault_sdl_error_message0???SDF__backupmed__mirro__0B5CAFEA0???SDF__MSdbms_da__datal__6A30C6490?@@?SDF__@Sdbms_da__dest___68487DD70???SDF__MSdbms_ma__defau__5FB337D60???SDF__MSdbms_ma__src_l__59FA5E800???SDF__MSdbms_ma__src_p__5AEE82B90???SDF__MSdbms_ma__src_s__5CD6CB2B0???SDF__suspect_p__last___2610A6260???SDF__syscach@d__has_s__4E88ABD40?@@?SDF__sysdbmain__end_t__090A53240?@@?SDF__sysdbmain__owner__740F363E0?@@?SDF__sysdbmain__serve__07220AB20???SDF__sysdtspac__logda__40C49C620?@@?SDF__sysjobsch__next___34C8D9D10???SDF__sysjobste__dat@___267ABA7A0???SDF__sysmail_a__last___10E07F160???SDF__sysmail_a__last___6501FCD80???SDF__sysmail_c__last___7CD986690???SDF__sysmail_l__last___1D4655FB0???SDF__sysmail_l__log_d__1C5231C20???SDF__sysmail_m__last___047@A8310?@@?SDF__sysmail_p__is_de__5F4923820?@@?SDF__sysmail_p__last___61316BF40?@@?SDF__sysmail_s__enabl__7720AD130?@@?SDF__sysmail_s__last___1975C5170???SDF__sysmail_s__last___7073AF840???SDF__sysmail_s__last___79FD19BE0@???SDF__sysmail_s__use_d__762C88DA0???SDF__sysmaintp__logge__46E78A0C0???SDF__sysmaintp__msx_p__4316F9280?@@?SDF__sysschedu__date___2C3393D00???SDF__sysschedu__versi__2E1BDC420???9ExternalMailQueue0???SFK__backupf@il__backu__14E61A240???SFK__backupmed__media__0A688BB10???SFK__restorefi__resto__2057CCD00???SFK__restorehi__backu__1E6F845E0???SFK__sysdbmain__plan___7BB058060???SFK__sysdtsste__linea__4589517F0???SFK__sysjobact__job@_i__1FCDBCEB0???SFK__sysjobsch__job_i__32E0915F0???SFK__sysjobste__step___276EDEB30???SFK__sysmail_p__profi__5E54FF490???SFK__sysmail_s__serve__744440680???Kfk_MSdbms_datatype_dbms_id0???Yfk_MSdbms_datatype_mapping_ma@p_id0?@@?Ifk_MSdbms_map_src_dbms_id0?@@?WFK_sysmail_mailitems_mailitem_id0?@@?9get_principal_sid0?@@?#MSdbms0?@@?SPK__backupfi__57D1800A17C286CF0?@@?SPK__backupse__21F79AAB0E391C950?@@?SPK__sysdtspa__5C158ECB3EDC53F00@???SPK__sysdtsta__FDDFDAA74865BE2A0?@@?SPK__sysmail___DD70126422FF2F510???SPK__syssessi__69B13FDC1BFD2C070???3pk_dtspackages0???;pk_MSdbms_datatype0?@@?QPK_sysmaintplan_taskdetail_id0???Iqueue_messages_16271528420@???Iqueue_messages_19770580790?@@?7restorefilegroup0???;ServiceBrokerQueue0???Asp_add_alert_internal0???;sp_add_dtscategory0???+sp_add_job0???7sp_add_jobserver0???Esp_add_jobstep_internal0?@@?5sp_add@schedule0???Ksp_add_targetsvrgrp_member0???Esp_apply_job_to_targets0???Esp_check_for_owned_jobs0?@@?5sp_delete_alert0?@@?Gsp_delete_job_references0?@@??sp_delete_jobsteplog0?@@?;sp_delet4 c2,DA@@33"LWCSpaceAlloc>2 <2c-t B@ @2<P2)<or no.2  )023"L2>2)<2<A D|@ <IS4 c2-A@2>2)<2<Ahe_schedule0?@@?;sp_detach_schedule0?@@?-sp_droptask0?@@?;sp_dump_dtssteplog0?@@?Asp_enum_dtspackagelog0?@@?Esp_enum_login_for_proxy0?@@?Osp_ExternalMai@lQueueListener0?@@?Isp_get_composite_job_info0???9sp_get_dtsversion0?@@?Msp_get_schedule_description0?@@?Esp_grant_login_to_proxy0?@@??sp_help_downloadlist0?@@?;sp_help_jobhistory0?@@?Gsp_help_jobs_in_schedule0??@?9sp_help_jobserver0???;sp_help_jobsteplog0???7sp_help_operator0?@@??sp_help_targetserver0???Esp_is_sqlagent_starting0???Isp_jobhistory_row_limiter0???Asp_log_dtspackage_end0???;sp_log_dtsstep_end0???Asp@_MailItemResultSets0???Esp_maintplan_delete_log0???Msp_maintplan_delete_subplan0???;sp_maintplan_start0???Esp_maintplan_update_log0?@@?Esp_manage_jobs_by_login0???1sp_msx_defect0???;sp_msx_get_account0???M@sp_multi_server_job_summary0???Asp_post_msx_operation0???;sp_ProcessResponse0???3sp_readrequest0???Msp_reassign_dtspackageowner0???Csp_resync_targetserver0???Ssp_revoke_proxy_from_subsystem0???;sp_sem_add_messa@e0???3sp_send_dbmail0???9sp_SendMailQueues0???Ksp_set_sqlagent_properties0???Qsp_sqlagent_get_perf_counters0?@@?Osp_sqlagent_is_srvrolemember0???;sp_sqlagent_notify0???Esp_sqlagent_refresh_job0???-sp_stop@job0???Gsp_target_server_summary0???5sp_update_alert0???1sp_update_job0???9sp_update_jobstep0?@@?]sp_update_replication_job_parameter0???Msp_update_targetservergroup0???5sp_verify_alert0???Ssp_verify_cate@ory_identifiers0???1sp_verify_job0???Isp_verify_job_identifiers0???Gsp_verify_jobproc_caller0???Msp_verify_login_identifiers0???;sp_verify_operator0???Usp_verify_performance_condition0???Msp_verify_proxy_identi@fiers0???;sp_verify_schedule0???=sp_verify_subsystem0????sp_verify_subsystems0???1sqlagent_info0????SQLAGENT_SUSER_SNAME0???)sysalerts0???-sysasymkeys0???+sysbinobjs0????syscachedcredentials0??@?'syscerts0???+syscolpars0???7syscompfragments0???=sysdatatypemappings0???Csysdbmaintplan_history0???5sysdbmaintplans0???)sysdesend0?@?7sysdtspackagelog0?@@?)sysfgfrag0?@@?-sysguidrefs0?@@?1sy@sjobhistory0?@@?1sysjobservers0?@@?qSYSMAIL_ACCOUNT_AccountServerTypeMustBeUnique0?@@?Csysmail_add_account_sp0?@@?7sysmail_allitems0?@@?Asysmail_configuration0?@@?Isysmail_delete_account_sp0?@@?Isysmail_delete_profile@sp0?@@?=sysmail_faileditems0?@@?Usysmail_help_configure_value_sp0?@@?Asysmail_help_queue_sp0?@@?Esysmail_logmailevent_sp0?@@?osysmail_OutMailAttachmentEncodingMustBeValid0?@@?asysmail_OutMailSensitivityMustBeValid0?@@?@SSYSMAIL_PROFILE_IDMustBeUnique0?@@??sysmail_send_retries0?@@?]SYSMAIL_SERVERTYPE_TypeMustBeUnique0?@@?Isysmail_update_account_sp0?@@?Isysmail_verify_account_sp0?@@?7sysmaintplan_log0?@@?7sysnotifications0?@@?/sysope@ators0?@@?%sysphfg0?@@?1sysproxylogin0?@@?)sysqnames0?@@?)sysrscols0?@@?Qsysschedules_localserver_view0?@@?3syssoftobjrefs0?@@?Asystargetservergroups0?@@?5systypedsubobjs0?@@?5sysxmlplacement0?@@?Otri@_notification_ins_or_upd0?@@?Gtrig_sysmail_attachments0?@@??trig_sysmail_profile0?@@?Etrig_sysmail_servertype0?@@?SUQ__sysdbmai__AEEEF1DB7E8CC4B10?@?SUQ__sysorigi__D65E569C0BC6C43E0??Ouq_dtscategories_name_parent%%@((agent_datetimeDF__MSdbms_da__dest___656C112Csyscached__has_s__4E88ABD4dtspac__owner__2F9A1060mail_l__log_d__1C5231C2s__flags__7814D14Corigin__origi__117F9D94FK__sysdbmain__plan___00750D23MSdbms_datatype_dbms_idInternalMailQueuePK__sysdtsst__4@ c2-DA>2<0<A_D|_ <r>2<2<A58E1496643A1090Dsysmaintplan_taskdetail_idsp_add_dtspackagecheck_for_owned_jobsdelete_proxyenlist_tsxget_dtspackagehelp_jobactivityschedulem@aintplan_open_logentrypost_msx_operationSendMailMessagetop_jobvalidate_usererify_performance_conditionysallocunitsdbmaintplan_historyguidrefsmail_add_account_spdelete_principalprofile_spPROFILE_NameMustBeUniqueverify_account_spownersscalartypesxmitqueuetri@g_sysmail_profile2@@,/F]bt, @ LVd it|@ @  e7O` f qzLJ@G4R?9@W@@i@/4 c2cbq>29<2<;@GL55?萚<萚<萚<萚<44 BTB"5A@?@   D%n2] :@BkBw%Ly 1 Z }  E t : o 0??OEventNotificationErrorsQueue0??Ufilestream_tombstone_20730584210??OQueryNotificationErrors@Queue0??Iqueue_messages_19770580790??Iqueue_messages_20090581930??Iqueue_messages_20410583070??;ServiceBrokerQueue0??1sysallocunits0??-sysasymkeys0??+sysaudacts0??+sysbinobjs0??1sysbinsubo@js0??'syscerts0??+sysclsobjs0??+syscolpars0??/syscommittab0??7syscompfragments0??/sysconvgroup0??'sysdercv0??)sysdesend0??)sysfgfrag0??)sysfiles10??)sysftinds0??+sys@tstops0??-sysguidrefs0??-sysidxstats0??)sysiscols0???)sysnsobjs0??5sysobjkeycrypts0??/sysobjvalues0??)sysowners0??%sysphfg0??1syspriorities0??'sysprivs0??-sysprufiles0?@)sysqnames0??3sysremsvcbinds0??1sysrowsetrefs0??+sysrowsets0??)sysrscols0??#sysrts0??3sysscalartypes0??+sysschobjs0??7syssingleobjrefs0??3syssoftobjrefs0??/syssqlguides0??@5systypedsubobjs0??/sysxmitqueue0??5sysxmlcomponent0??-sysxmlfacet0??5sysxmlplacement0??)sysxprops ((EventNotificationErrorsQueuequeue_messages_2041058307sysaudactscolparsdercvftstopsmultiobjrefsownersqn@amesrscolssoftobjrefsxmlcomponent@@58?FK R^dj p {5hhTAD|h(>)bC<"> < D023"L2_name [KKF0FEH&&%p%H%$$`$$#x@H` (an do this IF (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) <> 1) BEGIN RAISERROR(15003, 16, 1, N'sysadmin') RETURN(1) -- Fai@ure END -- Remove any leading/trailing spaces from parameters SELECT @server_name = LTRIM(RTRIM(@server_name)) IF (UPPER(@server_name collate SQL_Latin1_General_CP1_CS_AS) <> N'ALL') BEGIN IF (NOT EXISTS (SELECT * FROM msdb.dbo.systargetservers WHERE (UPPER(server_name) = UPPER(@server_name)))) BEGIN RAISERROR(14262, -1, -1, '@server_name', @server_name) RETURN(1) -- Failure END -- We want the target server to:H -- a) delete all their current MSX jobs, and -- b) download all their jobs again. -- So we delete all the current instructions and post a new set DELETE FROM msdb.dbo.sysdownloadlist WHERE (target_server = @server_name) EXECUTE msdb.dbo.sp_post_msx_operation 'DELETE', 'JOB', 0x00, @server_name EXECUTE msdb.dbo.sp_post_msx_operation 'INSERT', 'JOB', 0x00, @server_name END ELSE BEGIN -- We want ALL target servers?fbqgr_g_g_AeeMcP`2:@33"LXC|UpdateQPStats2 " >29<2< 0 p h0 <"  < sIuG!L55?A3"L//?@? D??TB?$TB?5lt D?!LJ@G?@/023"L2@(-D[r*AXo'>Ul $;Ri !8Of}5L@c????? ??? ??? ????????????????????!???#??$??+???-???/???1???3???5???7???9@???;???=???????A???C???E???G???I???K???M???O???Q???S???U???W???Y???[???]???_???a???c???e@???g???i???k???m???o???q???s???u???w???y???{???}?????q???s???u???w???y???{???}?????@???????????0<"$GL55?萚<$$@TB@\d 7NH|4Kby1H_v.E?????????????????????"??)?@@@@@PX2&-@33"L`CiUpdateQPStats2 " >29<2<,Gk!L55>@TB@@W-B@?IT4B?S @@?SQ ((ITS @ 5A3"L//ى= @ D@@yPXh}%:Od@?C B?D  B?F @?FN@?ITeC?P B?PK4B?S @?SQA?TRB?U A?UQ@PA?V % ((C D F ITP KS QTRU @     @ k!LJ@G`UU?Z@`@@s>@/)<" n  < ;a023"L2()28)G 0-\1i4Gplan_nameN ) ÃBE>28s@28)$SE6\1i$plan_name ) "幋 we cr>28.:)28)OEL0-\1i4Odatabase_name  ) 02 a>28S)2 ), =6\1i,database_name ) l(1R(36) >28.;)28)Kn_0-\1i@4Kserver_namer ) ¥J >28)28 )(L)6\1i(server_name ) ֊6 >28.<)28)E 0-\1i4EactivityTUR ) )*F E>28)2)"ub6\1i"activity  )@ C>ption,>28.=)28)G_i0-\1ihhGsucceeded  ) ЖkJ >28N)1)$ 6\1i$succeeded ) Cs ELSE>28.>)28)E 0-\1i==Eend_timeame ) Y8We,>28H)1N)"sm6\1i"end_timeub ) Hx[ >28.?)28)Ee 0-\1i 88 EdurationIF  ) 鯲 >28)28)"ec6\1i "durationin ) (E SET>28.@)28)Ion0-\1i ==H@@@P5*9@2&S> c2x(Ͽ  da@33"LvC*CreatProc transaction"2  Ͽ >2"28"h0,Ͽ P 3"L3"L hsp_clear_dbmaintplan_by_db " :>2 @1"B&Ͽ Bsp_clear_dbmaintplan_by_db " Qe>2H"1>"B&Ͽ Bsp_clear_dbmaintplan_by_db " q>2zI"28" Ͽ  " v#R2@33"LwCSplitPage@>2 <2c'<@@2 <P2 #<>2 #<2 p0Mޅ  p8CREATE PROCEDURE sp_sqlagent_get_perf_counters @all_counters BIT = 0 AS BEGIN SET NOCOUNT ON -- 32 bit fraction counter types DECLARE @perfTypeRawFraction INT@ DECLARE @perfTypeRawBase INT -- A counter of type PERF_RAW_FRACTION, which is a 32-bit counter value. SET @perfTypeRawFraction = 537003008 -- In hex, 0x20020400. -- A count of type PERF_RAW_BASE, which is the 32-bit divisor used -- when handling PERF_RAW_FRACTION types. This counter type should -- not be displayed to the user since it is used for mathematical -- operations. SET @perfTypeRawBase = 1073939459 -- In hex, 0x40030403. -- 64 bit fraction counter ty@es DECLARE @perfTypeLargeRawFraction INT DECLARE @perfTypeLargeRawBase INT -- A counter of type PERF_LARGE RAW_FRACTION, which is a 64-bit counter value. SET @perfTypeLargeRawFraction = 537003264 -- In hex, 0x20020500. -- A count of type PERF_LARGE_RAW_BASE, which is the 64-bit divisor used -- when handling PERF_LARGE_RAW_FRACTION types. This counter type should -- not be displayed to the user since it is used for mathematical -- operations. SET @perfTypeLargeRawBase@ = 1073939712 -- In hex, 0x40030500. IF (@all_counters = 0) BEGIN SELECT 'object_name' = RTRIM(SUBSTRING(spi1.object_name, 1, 50)), 'counter_name' = RTRIM(SUBSTRING(spi1.counter_name, 1, 50)), 'instance_name' = CASE spi1.instance_name WHEN N'' THEN NULL ELSE RTRIM(spi1.instance_name) END, 'value' = CASE spi1.cntr_type WHEN @perfTypeRawFr@ction -- 32 bit fraction THEN CONVERT(FLOAT, spi1.cntr_value) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 WHERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.inst@nce_name = spi2.instance_name) AND (spi2.cntr_type = @perfTypeRawBase)) WHEN @perfTypeLargeRawFraction -- 64 bit fraction THEN CONVERT(FLOAT, spi1.cntr_value) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 @HERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.instance_name = spi2.instance_name) AND (spi2.cntr_type = @perfTypeLargeRawBase)) ELSE spi1.cntr_value END, 'type' = spi1.cntr_type FROM sys.dm_os_performance_counters spi1, ( @ SELECT DISTINCT SUBSTRING(performance_condition, 1, CHARINDEX('|', performance_condition, PATINDEX('%_|_%', performance_condition) + 2) - 1) as performance_condition_s FROM msdb.dbo.sysalerts WHERE (performance_condition IS NOT NULL) AND ISNULL(event_id, 0) <> 8 -- exclude WMI events that reuse performance_condition field AND (enabled = 1) ) tmp -- We want to select only those counters that have an enabled performance sysa@ert WHERE (spi1.cntr_type <> @perfTypeRawBase) -- ignore 32-bit denominator counter type AND (spi1.cntr_type <> @perfTypeLargeRawBase) -- ignore 64-bit denominator counter type AND (tmp.performance_condition_s = RTRIM(spi1.object_name) + '|' + RTRIM(spi1.counter_name)) END ELSE BEGIN SELECT 'object_name' = RTRIM(SUBSTRING(spi1.object_name, 1, 50)), 'counter_name' = RTRIM(SUBSTRING(spi1.counter_name, 1, 50)), 'instance_name' = CAS@ spi1.instance_name WHEN N'' THEN NULL ELSE RTRIM(spi1.instance_name) END, 'value' = CASE spi1.cntr_type WHEN @perfTypeRawFraction -- 32 bit fraction THEN CONVERT(FLOAT, spi1.cntr_value) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 @ WHERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.instance_name = spi2.instance_name) AND (spi2.cntr_type = @perfTypeRawBase)) WHEN @perfTypeLargeRawFraction -- 64 bit fraction THEN CONVERT(FLOAT, spi1.cntr_v@lue) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 WHERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.instance_name = spi2.instance_name) @ AND (spi2.cntr_type = @perfTypeLargeRawBase)) ELSE spi1.cntr_value END, 'type' = spi1.cntr_type FROM sys.dm_os_performance_counters spi1 WHERE (spi1.cntr_type <> @perfTypeRawBase) -- ignore 32-bit denominator counter type AND (spi1.cntr_type <> @perfTypeLargeRawBase) -- ignore 64-bit denominator counter type END END 02  8 CREATE VIEW sysmail_faileditems AS SELECT * FROM msdb.dbo.sy@mail_allitems WHERE sent_status = 'failed' _<2  <.#__>2 <2 P#sys>2</(_#pac>2 <2<Mޅ #PK023"L2id0>2<2<0@Ͽ  8CREATE PROCEDURE sp_clear_dbmaintplan_by_db @db_name sysname AS BEGIN DECLARE planid_cursor CURSOR FOR select plan_id from msdb.dbo.sysdbmaintplan_databases where database_name=@db_name OPEN planid_cursor declare @planid uniqueidentifier FETCH NEXT FROM planid_cursor INTO @planid WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN delete from msdb.dbo.sysdbmaintplan_databases where plan_id=@planid AND database_name=@db_name if (NOT EXISTS(select * from msdb.dbo.sysdbmaintplan_databases where plan_id=@planid)) BEGIN --delete the job DECLARE jobid_cursor CURSOR FOR select job_id from msdb.dbo.sysdbmaintplan_jobs where plan_id=@planid OPEN jobid_cursor DECLARE @jobid uniqueidentifier FETCH NEXT FROM jobid_cursor INTO @jobid WHILE (@@FETCH_STATUS <> -1) BEGIN if (@@FETCH_STATUS <> -2) BEGIN exe@ute msdb.dbo.sp_delete_job @jobid END FETCH NEXT FROM jobid_cursor into @jobid END CLOSE jobid_cursor DEALLOCATE jobid_cursor --delete the history delete from msdb.dbo.sysdbmaintplan_history where plan_id=@planid --delete the plan delete from msdb.dbo.sysdbmaintplans where plan_id=@planid END END FETCH NEXT FROM planid_cursor INTO @planid END CLOSE planid_cursor DEALLOCATE planid_cursor END  @< G_vl4>2).=)E0-Ͽ 4E@db_name0 ) N2 )1p)"a6Ͽ "@db_named ) Vilog>2"2"@Ͽ  " :i>2"2"@lQ ueϿ  " :@>2 xK28KϿ rU K 64n?>2K1$KrUϿ s K (rin_>2 yK2KdϿ ?|| K <=twbhi>2K1Kh?||Ͽ  @K Aa^lp_>2 zK2KpϿ ?|| K q7{rat>2K2K?||Ͽ s K B nt_>2 {K2KoϿ ?|| K %Elg_d>2K2Ks?||Ͽ  K W@aMai>2 xK2KpϿ \1i K `rsp_>2iK28K;\1iϿ l K ¸??>2  yK2KϿ \1i K ̞%Sin0>2!iK2 Ks\1iϿ _ K 27,?>2@" {K2!K?Ͽ "w K ion>2#K2K?"wϿ e K gF?>2$ |K2#KϿ "w K j#,<+ser>2%K2$Ks"wϿ  K ٣!~p_s>2&@{K2%KmϿ !Jo K  lQu>2'GK2&Ke!JoϿ ? K B#Qqla>2( |K2'K_Ͽ !Jo K Qe6J0>2)HK2(K!JoϿ g K 7)-_jo>2*.b/@,bFs0Ͽ  @8>Fsp_delete_jobdbomsdbs b 0e>2+!b1b46Ͽ .4sp_delete_jobdbo b |Tte_>2,/b2+b\0Ͽ  @NT\sysdbmaintplan_databasesdbomsdb b Bť6?>2-{6b.@bJs6Ͽ DJsysdbmaintplan_databasesdbop b H˞_id>2.0b2-bXo0Ͽ  @JPXsysdbmaintplan_historydbomsdb b ;y=>2/{7b2.bFv6Ͽ @Fsysdbmaintplan_historydbo b R _>20@1b2/bRi0Ͽ  @DJRsysdbmaintplan_jobsdbomsdb0 b )csp_>21{8b20b@t6Ͽ :@sysdbmaintplan_jobsdbo b E>222b21bJs0Ͽ  @<BJsysdbmaintplansdbomsdba b "qF3ial>23@{:b22b8c6Ͽ 28sysdbmaintplansdbo b ?023"L2?87@765@543321`10h0/p/.x.---,,++**) )((('H'&& p0P0x(ans0???)sysdesend0?@?7sysdtspackagelog0?@@?)sysfgfrag0?@@?-sysguidrefs0?@@?1sy@sjobhistory0?@@?1sysjobservers0?@@?qSYSMAIL_ACCOUNT_AccountServerTypeMustBeUnique0?@@?Csysmail_add_account_sp0?@@?7sysmail_allitems0?@@?Asysmail_configuration0?@@?Isysmail_delete_account_sp0?@@?Isysmail_delete_profile@sp0?@@?=sysmail_faileditems0?@@?Usysmail_help_configure_value_sp0?@@?Asysmail_help_queue_sp0?@@?Esysmail_logmailevent_sp0?@@?osysmail_OutMailAttachmentEncodingMustBeValid0?@@?asysmail_OutMailSensitivityMustBeValid0?@@?HSSYSMAIL_PROFILE_IDMustBeUnique0?@@??sysmail_send_retries0?@@?]SYSMAIL_SERVERTYPE_TypeMustBeUnique0?@@?Isysmail_update_account_sp0?@@?Isysmail_verify_account_sp0?@@?7sysmaintplan_log0?@@?7sysnotifications0@@@P c@0s a El Waa p "P 0@2[> c2( A da@3?4"LC*CreatProc transaction2   >2 "2"b0, P ?4"L?4"L bsp_add_maintenance_plan " ! F>28@1="<& <sp_add_maintenance_plan " ?>2="2"<& <sp_add_maintenance_plan " jO gTB>2zM"2"   " %>2#<2 <0  8CREATE P@OCEDURE sp_add_maintenance_plan @plan_name varchar(128), @plan_id UNIQUEIDENTIFIER OUTPUT AS BEGIN IF (NOT EXISTS (SELECT * FROM msdb.dbo.sysdbmaintplans WHERE plan_name=@plan_name)) BEGIN SELECT @plan_id=NEWID() INSERT INTO msdb.dbo.sysdbmaintplans (plan_id, plan_name) VALUES (@plan_id, @plan_name) END ELSE BEGIN RAISERROR(14261,-1,-1,'@plan_name',@plan_name) RETURN(1) -- failure END END  < @>2V)/`Q)I0- 4I@plan_name ) uN?>2 8)1)&6 &@plan_name? ) `վ?>2 V)2 )E?0- $$E@plan_id ) UA^?>2 @2)2 )"6 "@plan_id? ) ru?>2 V)2 ) K ) UA^>2  "2"  " ! F?>2 "2"   " ! F?>2eK/($K@? !Jo K b;Q>2IK2*K!Jo  K #1??>2eK2K !Jo K @?q>2JK2K!Jo  K w{@3?4"LC@plitPage>2 b2 c@"@2bP2b>2b28DBDLZZDJ`DfDJRN^J2DJ4FDf:L0:LPPLPj>FFNZP8>FDPPDJ>R2>D@0z  @6<Dsysjobs_viewdbomsdb0z @ @4:Bsysjobstepsdbomsdb0z  @6<Dsysschedulesdbomsdb0k @>DLsysmail_allitemsdbomsdb0k @LRZsysmail_logmailevent_spdbomsdb0Jb @LRZsp_is_sqlagent_startingdbomsdb0Jb @6<Dsysjobs_viewdbomsdb01oV @<BJsysjobschedules@bomsdb01oV @RX`sysoriginatingservers_viewdbomsdb01oV @6<Dsysschedulesdbomsdb01oV @X^fsysschedules_localserver_viewdbomsdb0jJ @6<Dsysjobs_viewdbomsdb0> @<BJsysdownloadlistdbomsdb?0 @DJRsysmail_attachmentsdbomsdb@ @@FNsysmail_mailitemsdbomsdb02 @PV^sp_downloaded_row_limiterdbomsdb02 @<BJsysdownloadlistdbomsdb02 p2sysjobs_view02 @6<Dsysjobs_viewdbomsdb02 @<BJsysjobschedulesdbomsdb02 p4sysjobservers02@ @8>Fsysjobserversdbomsdb>02 @6<Dsysschedulesdbomsdb02 @X^fsysschedules_localserver_viewdbomsdb02 p:systargetservers02 @>DLsystargetserversdbomsdb0? \ `*0sysjobsdbo0? \ `4:sysschedulesdbo0x.P `FLsyso@iginatingserversdbo0l @BHPsp_sqlagent_notifydbomsdb0l @BHPsp_verify_job_datedbomsdb0l pLsp_verify_job_identifiers0l @BHPsp_verify_job_timedbomsdb0l @\bjsp_verify_performance_conditiondbomsdb0l @06>sysalerts@bomsdb0l @8>Fsyscategoriesdbomsdb0l @8>Fsysjobserversdbomsdb0v8 pNsysoriginatingservers_view0 @LRZsp_is_sqlagent_startingdbomsdb0 @BHPsp_sqlagent_notifydbomsdb0 p8sp_verify_alert0 @06>sysaler@sdbomsdb0 @8>Fsyscategoriesdbomsdb0 @6<Dsysjobs_viewdbomsdb02 pPsp_maintplan_delete_subplan02 @BHPsp_sqlagent_notifydbomsdb02 pDsp_ssis_deletepackage02 @<BJsp_update_alertdbomsdb02 @06>sysalerts@bomsdb02 @DJRsysdbmaintplan_jobsdbomsdb?`02 p2sysjobs_view02 p>sysmaintplan_plansu\02 pDsysmaintplan_subplans02 @28@systaskidsdbomsdb<2 7b236>2b2A>2@b/>2b-8b86z 28sysjobs_viewdbo02?4"L2>25b2bJ0  @<BJsysdbmaintplansdbomsdb> b oO>2{;b24b8@ 28sysdbmaintplansdbo b vG02?4"L2P P` h  @ H X p@ x($$@TB@\d 7N@|4Kby1H_v.E?????????????????????"??)??,@??.??1???3??6??7??:???<??@??A?@?E?@?I???K??N??R??U??Z???\???^???`???b??u???˿w@???y???u\{??|5aOA3"L//?y:@ D@g $;Ri@ !8Of}5Lcz  2 I ` w   / F ] t  , C Z q  ) @ W n  & = T k #:Qh  7Ne|4Kby1H_v@.E\s+BYp(?Vm%<Sj "9P???@????????@@?"H?@@?1?@@?7???;???@???C???E???H???J?@?]?@@?a???h ?@@?w!???5I???;???O???_???t????A??@@??@@?W?@@@@@@@6dtdr0dSR"P)R 020&.V> c2(A z,da@34"LC*CreatProc transaction20  A >20#"2"h0,A P 4"L4"L hsp_delete_maintenance_plan " O>20@2"B&A Bsp_delete_maintenance_plan " T^5>20U"2"B&A Bsp_delete_maintenance_plan " Y"L>20zP"2" A  " @34"LC@SplitPage@>20 <2c(@@20 <P20 $<>20 <2$F >20 </($>20  <2<A $?U02@4"L20>20$<20 < 0A  8CREATE PROCEDURE sp_delete_maintenance_plan @plan_id UNIQUEIDENTIFIER AS BEGIN /*check if the plan_id is valid*/ IF (NOT EXISTS(SELECT * FROM sysdbmaintplans WHERE plan_id=@plan_id)) BEGIN DECLARE @syserr VARCHAR(100) SELECT @syserr=CONVERT(VARCHAR(100),@plan_id) RAISERROR(14262,-1,-1,'@plan_id@,@syserr) RETURN(1) END /* clean the related records in sysdbmaintplan_database */ DELETE FROM msdb.dbo.sysdbmaintplan_databases WHERE plan_id=@plan_id /* clean the related records in sysdbmaintplan_jobs*/ DELETE FROM msdb.dbo.sysdbmaintplan_jobs WHERE plan_id=@plan_id /* clean sysdbmaintplans */ DELETE FROM msdb.dbo.sysdbmaintplans WHERE plan_id= @plan_id END ) < 0>2>20V&)2 )Ei0-A @$$E@plan_id  ) E >203)2 )"L)6A "@plan_ida ) ݨLa6 >20#"20"-1iA  " O>20#"20" A  " O>20e%K2K@A ?|| K [>20K2K?||A e K @7FkJ >20e&K20K A ?|| K Y Cs>20K20K?||A  K 0^>20e%K20KA@"w K B{ksm>20K20K"wA  K $|2)>20e&K20KuA "w K 3g>20K20K"wA in K IOy* SET>20e%K20KonA !Jo@ K )7xIst>20JK20K!JoA  K 󘎾]ub>20e%K20KA !Jo K {d>20HK20Ken!JoA < K f=#E>2>20 b2b\i0A  @NT\sysdb@aintplan_databasesdbomsdb b f>20!{7b2bJr6A DJsysdbmaintplan_databasesdbo b v3+-~)>20"b20!bRe0A  @DJRsysdbmaintplan_jobsdbomsdb b CH`R(>20#{:b20"b@@A :@sysdbmaintplan_jobsdbo b C' >20$b20#b80A  p8sysdbmaintplans b N~B>20%{<b20$b06A 0sysdbmaintplans b Fx\>20&b20%bJ0A  @<BJsysdbmaintpla@sdbomsdb b JE>20'{?b20&b86A 28sysdbmaintplansdbo b [!0204"L20 0XP (0 8 @ P X 0@P0x(>RE:8 P  mX$M$na>28,e28,> S@:$er  l d >28-f28->DA:44)  t aU$st>28.g28.>IG:4ew  LVHLI>28/h28/>ta:@4he  I=Kuf>280i280>+ :4CA  U}iQTH>281j281>su:hR(  1xS]1'>282k282> :=@  %7}ְ>283l283>: 8!   {AU>284m284>i: 8%    285n285>: 4   SYtin$2H6QUEI>2876/-6+AS'\1i @ 6 rNR >288~6186 pl\1i 6 an_id $289 B>28:B28' "TUR(1)  xA or @s> c28)@@@@n6m '0"P*  2@>> c20(z,Pda@34"LC*CreatProc transaction"2@  z,>2@&"20"h0,z,P 4"L4"L hsp_add_maintenance_plan_db " Ner>2@9@2"B&z,Bsp_add_maintenance_plan_db " 7>2@>"20"B&z,Bsp_add_maintenance_plan_db " >ɽ>2@zS"20" z, " w\02>2@</(<|0z, @8CREATE PROCEDURE sp_add_maintenance_plan_db @plan_id UNIQUEIDENTIFIER, @db_name sysname AS BEGIN DECLARE @syserr VARCHAR(100) /*check if the plan_id is valid */ IF (NOT EXISTS (SELECT plan_id FROM msdb.dbo.sysdbmaintplans WHERE plan_id=@plan_id)) BEGIN SELECT @syserr=CONVERT(VARCHAR(100),@plan_id) RAISERROR(14262,-1,-1,'@plan_id',@syserr) RETURN(1) END /*check if the database name is valid */ IF (NOT EXISTS (SELECT name @ FROM master.dbo.sysdatabases WHERE name=@db_name)) BEGIN RAISERROR(14262,-1,-1,'@db_name',@db_name) RETURN(1) END /*check if the (plan_id, database) pair already exists*/ IF (EXISTS (SELECT * FROM sysdbmaintplan_databases WHERE plan_id=@plan_id AND database_name=@db_name)) BEGIN SELECT @syserr=CONVERT(VARCHAR(100),@plan_id)+' + '+@db_name RAISERROR(14261,-1,-1,'@plan_id+@db_name',@syserr) RETURN(1) END INSE@T INTO msdb.dbo.sysdbmaintplan_databases (plan_id,database_name) VALUES (@plan_id, @db_name) END  < k RAW_F>2@V))20)Eti0-z,$$E@plan_idLAR ) 40th>2@ 4)20)"es6z,"@plan_idno ) CYuser s>2@ V*)2@ )Erg0-z,@4E@db_nameunt ) ,." >2@  )2)" 6z,"@db_nameSU ) oame, 1>2@ &"2@"  z, " NerLL>2@ &"2@ " z, " Nere'>2@e.K20K@ -z,?|| K n-VERT(F>2@K20 KSE?||z,ND K ~9 >2@e/K2@Krsz,?|| K @l> >2@K2@Kna?||z, B K 8R͏me))) >2@e.K2@Ki1.nst@z,?||anc K n- >2@e/K2@KperTypz,?||  K @l>eL>2@e.K2@KRTz,!Jo K ǻvalue >2@LK2@K !Joz,  K L _os_pe>2@ b20'bJ 0z,@ pJsysdbmaintplan_databasesme b ;2', spi>2@{6b20(bB 6z,Bsysdbmaintplan_databases  b F >2@ b2@b\e)0z, @NT\sysdbmaintplan_databasesdbomsdb b t= >2@{9b2@b@ S6z,DJsysdbmaintplan_databasesdbonc b ᬅJv'%_|_%>2@ b2@bJon0z, @<BJsysdbmaintplansdbomsdbit b =PS >2@{Bb2@b8rf6z,28sysdbmaintplansdbo b ߐSNe 02@4"L2@abled  pX0@0 8 @ P X ( 0x(rfTypeRawBase) -- ignore 32-bit denominator counter type AND (spi1.cntr_type <> @perfTypeLargeRawBase) -- ignore 64-bit denominator counter type AND (tmp.performance_condition_s = RTRIM(spi1.object_name) + '|' + RTRIM(spi1.counter_name)) END ELSE BEGIN SELECT 'object_name' = RTRIM(SUBSTRING(spi1.object_name, 1, 50)), 'counter_name' = RTRIM(SUBSTRING(spi1.counter_name, 1, 50)), 'instance_name' = CAS@ spi1.instance_name WHEN N'' THEN NULL ELSE RTRIM(spi1.instance_name) END, 'value' = CASE spi1.cntr_type WHEN @perfTypeRawFraction -- 32 bit fraction THEN CONVERT(FLOAT, spi1.cntr_value) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 @ WHERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.instance_name = spi2.instance_name) AND (spi2.cntr_type = @perfTypeRawBase)) WHEN @perfTypeLargeRawFraction -- 64 bit fraction THEN CONVERT(FLOAT, spi1.cntr_v@lue) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 WHERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.instance_name = spi2.instance_name) @ AND (spi2.cntr_type = @perfTypeLargeRawBase)) ELSE spi1.cntr_value END, 'type' = spi1.cntr_type FROM sys.dm_os_performance_counters spi1 WHERE (spi1.cntr_type <> @perfTypeRawBase) -- ignore 32-bit denominator counter type AND (spi1.cntr_type <> @perfTypeLargeRawBase) -- ignore 64-bit denominator counter type END END 02  8 CREATE VIEW sysmail_faileditems AS SELECT * FROM msdb.dbo.syHmail_allitems WHERE sent_status = 'failed' _<2  <.#__>2 <2 P#sys>2</(_#pac>2 <2<Mޅ #PK023"L2id0>2<2<@@@@@JR |"P 2P> c2@(Ptda@3M5"LC*CreatProc transaction2P  P>2P+"2@"n0,PP M5"LM5"L nsp_delete_maintenance_plan_db " wb|>2P@"20"H&PHsp_delete_maintenance_plan_db " Aو[>2PW"2@"Hs&PHsp_delete_maintenance_plan_db " dso>2PzV"2@" P " _e=>2P</(< 0P@ 8CREATE PROCEDURE sp_delete_maintenance_plan_db @plan_id uniqueidentifier, @db_name sysname AS BEGIN /*check if the (plan_id, db_name) exists in the table*/ IF (NOT EXISTS(SELECT * FROM msdb.dbo.sysdbmaintplan_databases WHERE @plan_id=plan_id AND @db_name=database_name)) BEGIN DECLARE @syserr VARCHAR(300) SELECT @syserr=CONVERT(VARCHAR(100),@plan_id)+' + '+@db_name RAISERROR(14262,-1,-1,'@plan_id+@db_name',@syserr) RETUR@(1) END /*delete the pair*/ DELETE FROM msdb.dbo.sysdbmaintplan_databases WHERE plan_id=@plan_id AND database_name=@db_name END _ < >P>2PV8)2@ )E0-P$$E@plan_id  )  >2P 5)2@ )"$$6P"@plan_idE ) G )>2P V9)2@ )E0-P4E@db_nameu ) > (p>2P  )2@ )"6P"@db_name> ) +Ln >2P +"2P"!F?P " wb| >2P +"2P "! F?P " wb|>2P@5K2@K P?|| K '8oI>2PK2@K?||P> K 2ޫtG>2Pe6K2PK P?|| K HkSJ>2PK2PK?||P@ K 9_>2Pe7K2@KP?|| K _}N+>2PK2PK?||P K ^y>2Pb2@b\0P @NT\sysdbmaintplan_databasesdbomsdb b yQ&YLNZP>2P{:b2@bJo6PDJsysdbmaintHlan_databasesdboe b )Qz02PM5"L2Poms@ X ` h x  P8x(l_allitemsdbomsdb0k @LRZsysmail_logmailevent_spdbomsdb0Jb @LRZsp_is_sqlagent_startingdbomsdb0Jb @6<Dsysjobs_viewdbomsdb01oV @<BJsysjobschedpPePNP# 2X _> c2P(t%da@35"LC*CreatProc transaction2X  t>2X"28"j0,tP 5"L5"L jsp_add_maintenance_plan_job  " YOy%>2>2X@:"2@"DA&tDsp_add_maintenance_plan_job " >2>2X?"2P"DA&tDsp_add_maintenance_plan_job " f>2>2XzX"2P" At" " o] @>2X</P<Ei0t@ E8CREATE PROCEDURE sp_add_maintenance_plan_job @plan_id UNIQUEIDENTIFIER, @job_id UNIQUEIDENTIFIER AS BEGIN DECLARE @syserr varchar(100) /*check if the @plan_id is valid*/ IF (NOT EXISTS(SELECT plan_id FROM msdb.dbo.sysdbmaintplans WHERE plan_id=@plan_id)) BEGIN SELECT @syserr=CONVERT(VARCHAR(100),@plan_id) RAISERROR(14262,-1,-1,'@plan_id',@syserr) RETURN(1) END /*check if the @job_id is valid*/ IF (NOT EXISTS(SEL@CT job_id FROM msdb.dbo.sysjobs WHERE job_id=@job_id)) BEGIN SELECT @syserr=CONVERT(VARCHAR(100),@job_id) RAISERROR(14262,-1,-1,'@job_id',@syserr) RETURN(1) END /*check if the job has at least one step calling xp_sqlmaint*/ DECLARE @maxind INT SELECT @maxind=(SELECT MAX(CHARINDEX('xp_sqlmaint', command)) FROM msdb.dbo.sysjobsteps WHERE @job_id=job_id) IF (@maxind<=0) BEGIN /*print N'Warning: The @ob is not for maitenance plan.' -- will add the new sysmessage here*/ SELECT @syserr=CONVERT(VARCHAR(100),@job_id) RAISERROR(14199,-1,-1,@syserr) RETURN(1) END INSERT INTO msdb.dbo.sysdbmaintplan_jobs(plan_id,job_id) VALUES (@plan_id, @job_id) --don't have to check duplicate here END sys < wjuET>2XVA)2P )E 0-t$$E@plan_id ) ,si>2@ 6)2P )" 6t"@plan_id ) b#]2>2X VB)2X )C 0-t$$C@job_id ) z>2X )1p) #6t @job_id ) ?CB>2X "2X"Kt@ " YOy%|>2X "2X " t " YOy%>2XK/P(Kt"w K Z.A>2XK2PK"wt K "N>2XK2XKt"w K +AA@>2XK2XK"wt K d>2XK2XKt!Jo K [A>2XMK2XK!Jot K ~l>2XK2XKtRD K lٙ@A>2X@K0iKRDt K DM>2XK2XKt$  K A:yyA>2X@K0CK$ t K MAfen>2XK2XKt$  K #ѰA>2Xz,@0$Kd$ tb K ,d>2>2Xb2PbR0t @DJRsysdbmaintplan_jobsdbomsdb  b VBLY">2X{>b2Pb@6t:@sysdbmaintplan_jobsdbo b ŗÑC>2Xb2XbJ0t@ @<BJsysdbmaintplansdbomsdb  b i3?O>2>2X{Eb2Xb86t28sysdbmaintplansdbo b w{N>2Xb2Xb:0t @,2:sysjobsdbomsdb b E(f@o>2X{{b2Xb(6t"(sysjob@dbo b H=>2X b2XbB0t @4:Bsysjobstepsdbomsdbd b B.>!>2X!Gb0(b0P6t*0sysjobstepsdbo b r102X5"L2XX `X`hpx   ( P 8x(e28,> S@:$er  l d >28-f28->DA:44)  t aU$st>28.g28.>IG:4ew  LVHLI>28/h28/>ta:@4he  I=Kuf>280i280>+ :4CA  U}iQTH>281j281>su:hR(  1xS]1'>282k282> :=@  %7}ְ>283l283>: 8!   {AU>284m284>i: 8%    285n285>: 4   SYtin$2H6QUEI>2876/-6+AS'\1i @ 6 rNR >288~6186 pl\1i 6 an_id $289 B>28:B28' "TUR(1)  xA or @s> c28)H@@@sKXjEP#  2hH"> c2X(%^da@36"LC*CreatProc transaction"2h  %>2h"2X"p0,%P 6"L6"L psp_delete_maintenance_plan_job " v~>2h@"2P"Jz,&%Jsp_delete_maintenance_plan_job  " i>2hY"2X"Js&%Jsp_delete_maintenance_plan_job " * u>2hz["2X" % " :}P@>2h<2X<u @% u8CREATE PROCEDURE sp_delete_maintenance_plan_job @plan_id uniqueidentifier, @job_id uniqueidentifier AS BEGIN /*check if the (plan_id, job_id) exists*/ IF (NOT EXISTS(SELECT * FROM sysdbmaintplan_jobs WHERE @plan_id=plan_id AND @job_id=job_id)) BEGIN DECLARE @syserr VARCHAR(300) SELECT @syserr=CONVERT(VARCHAR(100),@plan_id)+' + '+CONVERT(VARCHAR(100),@job_id) RAISERROR(14262,-1,-1,'@plan_id+@job_id',@syserr) @ RETURN(1) END DELETE FROM msdb.dbo.sysdbmaintplan_jobs WHERE plan_id=@plan_id AND job_id=@job_id END _na < voUR>2hVN)2X )E/ 0-%$$E@plan_id  ) #z4_i>2h 7)2X )"ON6%"@plan_id@d ) ( /14261,@36"LC@O SplitPagetpan_>2h  )20 c <@@2h )P2h )V-an_>2h)2hMOKEEIOOIMCcAO[KOaa?IS0->4M@server_name0-88 Oat@tachment_id0-88 Kmailitem_id0-4Efilename0-88 Efilesize0-@Iattachment"0-==Olast_mod_date0-4Olast_mod_user0-2@4@I@operationK0-2@4M@object_type0-2$$C@job_id0-24c@specific_target_server0-288 A@value0-2$$O@schedule_uid0-$$[conversati@on_handle0-88 Kmailitem_id0-88 ޠOsend_attemptsL0-==ualast_send_attempt_date0-'4a@performance_condition 0-N$88 ?@date0-N$<4I@date_name@ 0-N$88 S@error_severityi<2h VO)2h >2hV)2h b>2h)*(;Ve)>2ho)2)a>b 02h 6"L2h 9>2h VO@2h)Cm0-%$$C@job_id% ) ND>2h )2X ) 6% @job_id ) u0 >2h"2h"b% " v~>2h"2h" % " v~>2h@ K2XKpe%"w K } type >2hK2XKbi"w%te K pGnD(tmp.p>2h K2hKun%"w K T@ 'obje>2hK2hKnt"w%UB K $(me, 1,>2h K2@K %"w K MX >2hK2hK E"w%ue K ,e >2hb2X!b@ 0% p@sysdbmaintplan_jobs b <N >2h{<b2X b8 6%8sysdbmaintplan_jobs b @cȩ >2h b2hbR_n0% @DJRsysdbmaintplan_jobsdbomsdb)) b N|Vn >2h!{@b2h b@in6%:@sysdbmaintplan_jobsdbo b /i202h6"L2h WH`pX`hxHX p 8Hx( THEN CONVERT(FLOAT, spi1.cntr_v@lue) / (SELECT CASE spi2.cntr_value WHEN 0 THEN 1 ELSE spi2.cntr_value END FROM sys.dm_os_performance_counters spi2 WHERE (spi1.counter_name + ' ' = SUBSTRING(spi2.counter_name, 1, PATINDEX('% Base%', spi2.counter_name))) AND (spi1.instance_name = spi2.instance_name) @ AND (spi2.cntr_type = @perfTypeLargeRawBase)) ELSE spi1.cntr_value END, 'type' = spi1.cntr_type FROM sys.dm_os_performance_counters spi1 WHERE (spi1.cntr_type <> @perfTypeRawBase) -- ignore 32-bit denominator counter type AND (spi1.cntr_type <> @perfTypeLargeRawBase) -- ignore 64-bit denominator counter type END END 02  8 CREATE VIEW sysmail_faileditems AS SELECT * FROM msdb.dbo.syHmail_allitems WHERE sent_status = 'failed' _<2  <.#__>2 <2 P#sys>2</(_#pac>2 <2<Mޅ #PK023"L2id0>2<2<H@@'h) 0P1  2xk> c2h(^da@3[6"LC*CreatProc transaction2x  ^>2x "2h"d0,^P [6"L[6"L dsp_help_maintenance_plan " % >2xR@2h">&^>sp_help_maintenance_plane " 94i">2xF"1">&^>sp_help_maintenance_plann " [Jm#b>2xz]"2h" ^ "  >2x <2h<0^ 8CREATE P@OCEDURE sp_help_maintenance_plan @plan_id UNIQUEIDENTIFIER = NULL AS BEGIN IF (@plan_id IS NOT NULL) BEGIN /*return the information about the plan itself*/ SELECT * FROM msdb.dbo.sysdbmaintplans WHERE plan_id=@plan_id /*return the information about databases this plan defined on*/ SELECT database_name FROM msdb.dbo.sysdbmaintplan_databases WHERE plan_id=@plan_id /*return the information about the jobs that relating to the plan*/ @ SELECT job_id FROM msdb.dbo.sysdbmaintplan_jobs WHERE plan_id=@plan_id END ELSE BEGIN SELECT * FROM msdb.dbo.sysdbmaintplans END END  < bj >2x)2h)E0-^$$E@plan_id ) KU}>2x 8)2h )"6^"@plan_id ) \7@ >2x  "2x"E@d^ " % >2x  "2x " ^ " %m>2x K2hK^?|| K "4& ">2x K2hK?||^ K ۍa >2x@2x K^?|| K £  '8>2xK2xK?||^P K / 2ޫt>2xK2xK^"w K mrf+U HkS>2xK2xK"w^P K /* >2xK2x@K^"w K F _}>2xK2xK"w^P K rAj ^y>2xK2xK^!Jo K ain>2xNK2xKP!Jo^ K /1A>2xK2xK@n^!Jo K |]yz>2xPK2xKh !Jo^ K {tem>2xK2xKa^!Jo K ϛu >2xQK2xK!Jo^  K <@s_v>2xK2xKd^@!Jo K bX`s>2xRK2xKoV!Jo^< K 9esd>2xK2xKo^!Jo K '1 J>2xSK2xK!Jo^s K *Ctdb>2xK2xKm^!Jo@ K ǒzFNs>2xTK2xK!Jo^n K \-lim>2x K2xKo^!Jo K >ނ2s>2x!UK2x Kv!Jo^b K m'B5<B>2x" K2x!K^!Jo K@ ؇h,Z8>>2x#VK2x"K<!Jo^u K WZL2>2x$!K2x#K_^!Jo  K NVsys>2x%WK2x$Kg!Jo ^d K ·0T>2x&"K2x%Kh^!Jo  K p yso@>2x'XK2x&Ks!Jo ^t K [sdb>2x(#K2x'Ko^!Jo  K Wy_j>2x)YK2x(Ki!Jo ^m K B=l>2x*b2h!b\i0^ @NT\sysdbmaintplan_databa@esdbomsdb b pT΄>Fs>2x+{;b2h"bJs6^DJsysdbmaintplan_databasesdbor b H)!Үrve>2x,b2x+bRn0^ @DJRsysdbmaintplan_jobsdbomsdbe b voms>2x-{Bb2x,b@6^:@sysdbm@intplan_jobsdbo b IQxEs>2x.b2x-bJs0^ @<BJsysdbmaintplansdbomsdbp b M#sub>2x/{Jb2x.b8f6^28sysdbmaintplansdbo b !*a02x[6"L2xe_a80px (08@ H P X ` h @x x( @DJRsysdbmaintplan_jobsdbomsdb?`02 p2sysjobs_view02 p>sysmaintplan_plansu\02 pDsysmaintplan_subplans02 @28@systaskidsdbomsdb<2 7b236>2b2A>2Hb/>2b-8b86z 28sysjobs_viewdbo02?4"L2>25b2bJ0  @<BJsysdbmaintplansdbomsdb> b oO>2{;b24b@asK R"PMAP 2 z> c2x(|da@36"LC*CreatProc transaction2  >2"2x "t0,P 6"L6"L tsp_delete_database_backuphistory " ׮s>2>2@"2x"Nt&Nsp_delete_database_backuphistory " ,jn; >2Q"2h"Ns&Nsp_delete_database_backuphistory " b1qu>2z`"2x" @ " g]x@36"LC@ SplitPageCEURE>2 <2h c) UIQU@IDE@2 <P2 %<sdb.db>2 %<2 E 5D%0> E 8CREATE PROCEDURE sp_downloaded_row_limiter @server_name sysname -- Target server name AS BEGIN -- This trigger controls how many@downloaded (status = 1) sysdownloadlist rows exist -- for any given server. It does NOT control the absolute number of rows in the table. DECLARE @current_rows_per_server INT DECLARE @max_rows_per_server INT -- This value comes from the resgistry (DownloadedMaxRows) DECLARE @rows_to_delete INT DECLARE @quoted_server_name NVARCHAR(514) -- enough room to accomodate the quoted name SET NOCOUNT ON -- Remove any leading/trailing spaces from parameters SELECT @serve@_name = LTRIM(RTRIM(@server_name)) -- Check the server name (if it's bad we fail silently) IF (@server_name IS NULL) OR (NOT EXISTS (SELECT * FROM msdb.dbo.sysdownloadlist WHERE (target_server = @server_name))) RETURN(1) -- Failure SELECT @max_rows_per_server = 0 -- Get the max-rows-per-server from the registry EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSS@LServer\SQLServerAgent', N'DownloadedMaxRows', @max_rows_per_server OUTPUT, N'no_output' -- Check if we are limiting sysdownloadlist rows IF (ISNULL(@max_rows_per_server, -1) = -1) RETURN -- Check that max_rows_per_server is >= 0 IF (@max_rows_per_server < -1) BEGIN -- It isn't, so default to 100 rows SELECT @max_rows_per_server = 100 EXECUTE m@ster.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'DownloadedMaxRows', N'REG_DWORD', @max_rows_per_server END -- Get the number of downloaded rows in sysdownloadlist for the target server in question -- NOTE: Determining this [quickly] requires a [non-clustered] ind@x on target_server SELECT @current_rows_per_server = COUNT(*) FROM msdb.dbo.sysdownloadlist WHERE (target_server = @server_name) AND (status = 1) -- Delete the oldest downloaded row(s) for the target server in question if the new row has -- pushed us over the per-server row limit SELECT @rows_to_delete = @current_rows_per_server - @max_rows_per_server IF (@rows_to_delete > 0) BEGIN WITH RowsToDelete AS ( SELECT TOP (@rows_to_delete) * FROM msdb.dbo.sysdownl@adlist WHERE (target_server = @server_name) AND (status = 1) ORDER BY instance_id ) DELETE FROM RowsToDelete; END END 0s 58([master_server]=(1))0^ 8CREATE PROCEDURE sp_help_maintenance_plan @plan_id UNIQUEIDENTIFIER = NULL AS BEGIN IF (@plan_id IS NOT NULL) BEGIN /*return the information about the plan itself*/ SELECT * FROM msdb.dbo.sysdbmaintplans WHERE plan_id=@plan@id /*return the information about databases this plan defined on*/ SELECT database_name FROM msdb.dbo.sysdbmaintplan_databases WHERE plan_id=@plan_id /*return the information about the jobs that relating to the plan*/ SELECT job_id FROM msdb.dbo.sysdbmaintplan_jobs WHERE plan_id=@plan_id END ELSE BEGIN SELECT * FROM msdb.dbo.sysdbmaintplans END END 0 8 CREATE VIEW sysmail_mailattachment@ AS SELECT attachment_id, sa.mailitem_id, filename, filesize, attachment, sa.last_mod_date, sa.last_mod_user FROM msdb.dbo.sysmail_attachments sa JOIN msdb.dbo.sysmail_mailitems sm ON sa.mailitem_id = sm.mailitem_id WHERE (sm.send_request_user = SUSER_SNAME()) OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1) 02 D8hU80g %8((1))<2  @2x%>2 <2 %>2< P!%>2>2<20<>%ob026"L2>2%<2 <j 0 j 8CREATE PROCEDURE sp_delete_database_backuphist@ry @database_name sysname AS BEGIN SET NOCOUNT ON DECLARE @backup_set_id TABLE (backup_set_id INT) DECLARE @media_set_id TABLE (media_set_id INT) DECLARE @restore_history_id TABLE (restore_history_id INT) INSERT INTO @backup_set_id (backup_set_id) SELECT DISTINCT backup_set_id FROM msdb.dbo.backupset WHERE database_name = @database_name INSERT INTO @media_set_id (media_set_id) SELECT DISTINCT media_set_id FROM msdb.dbo.backupset WHERE database_name @ @database_name INSERT INTO @restore_history_id (restore_history_id) SELECT DISTINCT restore_history_id FROM msdb.dbo.restorehistory WHERE backup_set_id IN (SELECT backup_set_id FROM @backup_set_id) BEGIN TRANSACTION DELETE FROM msdb.dbo.backupfile WHERE backup_set_id IN (SELECT backup_set_id FROM @backup_set_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.backupfilegroup WHERE backup_set_id IN (SELECT back@p_set_id FROM @backup_set_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.restorefile WHERE restore_history_id IN (SELECT restore_history_id FROM @restore_history_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.restorefilegroup WHERE restore_history_id IN (SELECT restore_history_id FROM @restore_history_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.restorehis@ory WHERE restore_history_id IN (SELECT restore_history_id FROM @restore_history_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.backupset WHERE backup_set_id IN (SELECT backup_set_id FROM @backup_set_id) IF (@@error > 0) GOTO Quit DELETE msdb.dbo.backupmediafamily FROM msdb.dbo.backupmediafamily bmf WHERE bmf.media_set_id IN (SELECT media_set_id FROM @media_set_id) AND ((@ELECT COUNT(*) FROM msdb.dbo.backupset WHERE media_set_id = bmf.media_set_id) = 0) IF (@@error > 0) GOTO Quit DELETE msdb.dbo.backupmediaset FROM msdb.dbo.backupmediaset bms WHERE bms.media_set_id IN (SELECT media_set_id FROM @media_set_id) AND ((SELECT COUNT(*) FROM msdb.dbo.backupset WHERE media_set_id = bms.media_set_id) = 0) IF (@@error > 0) GOTO Quit COMMIT TRANSACTION RETURN Quit: R@LLBACK TRANSACTION END  < _\E:>2>2)2x )Q0-4Q@database_name ) TO=|ON>2M)1@:).6.@database_namep ) I*-4g>2"2"  " ׮s>2@"2">  " ׮s>2EK2x)K ]> K &͵O035>2|K2XK2]>6 K 0G6l1i>2FK2K ]> K ߁TZ>2}K2@K]> K [t>2EK2K@ K 򒂺c>2;K2K@ K ]>@2>2FK2K@ K ->2<K2K@@ K Ȝe>2EK2K K L>2iK2"K K Y>2 FK2K K }@>2!iK2 K@ K r b>2"EK2!Ki K `1>2#iK2"K5Ii5I K IYr>2$FK2#K~1i K Z=~sst>2%iK2$Ki@ K 2 _>2&IK2%K#P  K  9{ >2'K/0K#P  K ,">2(JK2'Kp#P  K ڜ5>2)K2(K#P  K@ G4>2*KK2)K#P  K 0+$>2+K2*K#P  K q{94>2,LK2+K#P " K N>2-K2,KH#P "H K qh@>2.QK2-K"c K U >2/@K2XKc K v"nd>20RK2/Kc K H> D>21@K20Kc K JeQ>22@SK21K K! K ]c >23z}K2XK K! K 9 ތ8>24TK23K K! K -׶l>25z~K24K K! K gmo >26Q@25Kz K ">27@K22Kȃzȃ K <>28RK27Kz K ޡDDžal>29@K28Kz K Ga>2:SK29@Kz K !ϸBoLgq>2;@K2:Kz K c)v>2<+b2x/b@40 @28@backupfiledbomsdb b X[>2=b2,b. 6(.backupfiledbo b [ÂC>2@>,b2=bJ0 @<BJbackupfilegroupdbomsdb> b r878z>2?b2>b8628backupfilegroupdbo b ~z :>2@-b2?bN0 @@FNbackupmediafamilydbomsdb b #mHp>2A@b2@b<66<backupmediafamilydbo b w>2B.b2AbH0 @:@Hbackupmediasetdbomsdb b v*>2Cb2Bb6606backupmediasetdbo b tj>2D/b2C@b>0 @06>backupsetdbomsdb  b Κ>2Eb2Db,6&,backupsetdbo b Zb`>2>2F0b2EbBr0 @4:Brestorefiledbomsdb b s>2Gb2Fb0 6@0restorefiledbo b !_ >2H1b2GbL0 @>DLrestorefilegroupdbomsdb b J3">2Ib2Hb:164:restorefilegroupdbo b 4J">2J2b2IbH20 @:@Hrestorehi@torydbomsdb b n5A>2Kb2Jb66606restorehistorydbo b ^026"L21i@0@?>8>==p<;8;:9@987h76P65X54`43h32p21x1000//..--, ,+(+*0*)8)(@('H'&P&%X%$`$##"8"h0x p Px(>28atD"28\"p0,@9D \1i3"@3"L pDF__sysdbmain__plan___0539C240 " K5>28bv%"1y"J&@9JDF__sysdbmain__plan___0539C240 " >28cx%"1z"J&@9JDF__sysdbmain__plan___0539C240 " .>28dzq"28_"@ \1i@9 " 7Y1 AV5>28e.8)28#)%@9\1i ) ,&28f  \1i>28gtD"28b" K@9 " K528h  \1i>28i<.<H0@9 H8('00000000-0000-0000-0000-000000000000')@ < %H > c28`(y- "28j  y->28l"/"p0,y-D \1i3"L3"L pDF__sysdbmain__plan___062DE679 " >28mv&"28c"Je&y-JDF__sysdbmain__plan___062DE679 "@ K>28nx&"28d"J&y-JDF__sysdbmain__plan___062DE679> " O>28ozr"28e" \1iy- " wq%>28p.9)28f)%y-\1i ) Ã28q  \1i>28r"28m@" y- " 28s  \1i>28t<28j<40y- 48('All ad-hoc plans') < v@ ,) > c28k( ".28u  ">28w"28s"p0, "D \1i3"L3"L pDF__sy@dbmain__serve__07220AB2 " *A>28xv("28n"J& "JDF__sysdbmain__serve__07220AB26 " ɏ_c>28yx("28o"J& "JDF__sysdbmain__serve__07220AB2 " ˭3zT>28zzs"28p" \1i " H" e1>28{.;)28q)% "\1id ) ¥Jb28|  \1i>28}"28x" Fy " " *Ae28~  \1i>28<.<SK0 " S8(CONVERT([sysname],serverpropert@@@@@@@s*KOStu=o c2(| *pda@37"L%D*CreatProc transaction"2  |>2"2"b0,|P 7"L7"L bsp_delete_backuphistoryl " Oת >2@2"<&|<sp_delete_backuphistory " ¨bA  >2P"2"<&|<sp_delete_backuphistory " 2ǵr2zc"2" [| " C]@37"L&DSplitPage<>2@ <2 c*lee_m@int@2 <P2 &<TS(SEL>2 &<2 $*D_i0? \ 8CREATE TRIGGER dbo.trig_sysoriginatingservers_delete ON dbo.sysoriginatingservers FOR DELETE AS BEGIN SET NOCOUNT ON -- Only a single MSX server entry can exist in this table@ ie. originating_server_id = 1 and master_server = 1. IF((EXISTS (SELECT * FROM deleted AS d JOIN dbo.sysjobs AS j ON d.originating_server_id = j.originating_server_id)) OR (EXISTS (SELECT * FROM deleted AS d JOIN dbo.sysschedules AS s ON d.originating_server_id = s.originating_server_id))) BEGIN RAISERROR(14380, -1, -1) ROLLBACK TRANSACTION RETURN END END @0N$ $8CREATE PROCEDURE sp_verify_j@b_date @date INT, @date_name VARCHAR(60) = 'date', @error_severity INT = -1 AS BEGIN SET NOCOUNT ON -- Remove any leading/trailing spaces from parameters SELECT @date_name = LTRIM(RTRIM(@date_name)) IF ((ISDATE(CONVERT(VARCHAR, @date)) = 0) OR (@date < 19900101) OR (@date > 99991231)) BEGIN RAISERROR(14266, @error_severity, -1, @date_name, '19900101..99991231') RETURN(1) -- Failure END RETURN(0) -- Success END 0x.P @8CREATE VIEW dbo.sysoriginatingservers_view(originating_server_id, originating_server, master_server) AS SELECT 0 AS originating_server_id, UPPER(CONVERT(sysname, SERVERPROPERTY('ServerName'))) AS originating_server, 0 AS master_server UNION SELECT originating_server_id, originating_server, master_server FROM dbo.sysoriginatingservers 0H *8 CREATE PROCEDURE sp_verify_job_time @time INT, @@time_name VARCHAR(60) = 'time', @error_severity INT = -1 AS BEGIN DECLARE @hour INT DECLARE @minute INT DECLARE @second INT DECLARE @part_name NVARCHAR(50) SET NOCOUNT ON -- Remove any leading/trailing spaces from parameters SELECT @time_name = LTRIM(RTRIM(@time_name)) IF ((@time < 0) OR (@time > 235959)) BEGIN RAISERROR(14266, @error_severity, -1, @time_name, '000000..235959') RETURN(1) -- Failure END SELECT @hour = (@time / 10000)@ SELECT @minute = (@time % 10000) / 100 SELECT @second = (@time % 100) -- Check hour range IF (@hour > 23) BEGIN SELECT @part_name = FORMATMESSAGE(14218) RAISERROR(14287, @error_severity, -1, @time_name, @part_name) RETURN(1) -- Failure END -- Check minute range IF (@minute > 59) BEGIN SELECT @part_name = FORMATMESSAGE(14219) RAISERROR(14287, @error_severity, -1, @time_name, @part_name) RETURN(1) -- Failure END -- Check second range IF @@second > 59) BEGIN SELECT @part_name = FORMATMESSAGE(14220) RAISERROR(14287, @error_severity, -1, @time_name, @part_name) RETURN(1) -- Failure END RETURN(0) -- Success END 0l D8eh)<2  <2& 2>2 <2 &b >2</`J&O@>2<2<? \&@j027"L2>2&<2 <h 0| h 8CREATE PROCEDURE sp_delete_backuphistory @oldest_date datetime AS BEGIN SET NOCOUNT ON DECLARE @backup_set_id TABLE (backup_set_id INT) DECLARE @media_set_id TABLE (media_set_id INT) DECLARE @restore_history_id TABLE (restor@_history_id INT) INSERT INTO @backup_set_id (backup_set_id) SELECT DISTINCT backup_set_id FROM msdb.dbo.backupset WHERE backup_finish_date < @oldest_date INSERT INTO @media_set_id (media_set_id) SELECT DISTINCT media_set_id FROM msdb.dbo.backupset WHERE backup_finish_date < @oldest_date INSERT INTO @restore_history_id (restore_history_id) SELECT DISTINCT restore_history_id FROM msdb.dbo.restorehistory WHERE backup_set_id IN (SELECT backup_set_id @ FROM @backup_set_id) BEGIN TRANSACTION DELETE FROM msdb.dbo.backupfile WHERE backup_set_id IN (SELECT backup_set_id FROM @backup_set_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.backupfilegroup WHERE backup_set_id IN (SELECT backup_set_id FROM @backup_set_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.restorefile WHERE restore_history_id IN (SELECT restore_history_id @ FROM @restore_history_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.restorefilegroup WHERE restore_history_id IN (SELECT restore_history_id FROM @restore_history_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.restorehistory WHERE restore_history_id IN (SELECT restore_history_id FROM @restore_history_id) IF (@@error > 0) GOTO Quit DELETE FROM msdb.dbo.backupset WHERE backup_set_@d IN (SELECT backup_set_id FROM @backup_set_id) IF (@@error > 0) GOTO Quit DELETE msdb.dbo.backupmediafamily FROM msdb.dbo.backupmediafamily bmf WHERE bmf.media_set_id IN (SELECT media_set_id FROM @media_set_id) AND ((SELECT COUNT(*) FROM msdb.dbo.backupset WHERE media_set_id = bmf.media_set_id) = 0) IF (@@error > 0) GOTO Quit DELETE msdb.dbo.backupmediaset FROM msdb.dbo.backupmediaset bms@ WHERE bms.media_set_id IN (SELECT media_set_id FROM @media_set_id) AND ((SELECT COUNT(*) FROM msdb.dbo.backupset WHERE media_set_id = bms.media_set_id) = 0) IF (@@error > 0) GOTO Quit COMMIT TRANSACTION RETURN Quit: ROLLBACK TRANSACTION END  < ‰a=wB>2)2)M0-|==M@oldest_datemsd )@ e W>2B)1)*6|*@oldest_date ) om >2"2"| " Oת>2"2" | " OתK>2XK2;K|]> K R _ 0@>2K2Kby]>|sn K ŵ$ARE pl>2YK2Kan|]> K Gx Sanid_c>2K2Krs]>| W K v(<> -1) >2XK2Kms|@ K T$nD:nid AN>2@<K2Ksy@|as K PnT?id)) >2YK2KRS|@ K O6bo.sys>2>K2K @|un K  FETC>2XK2K -| K tHӸ -2) >2i@2&K |  K l$I_curso>2 YK2KCA| K D] d>2!iK2 K |n  K 4sQsdb.db>2"XK2!K N|i K *~E plan>2#iK2"@Ki| K DZ=>2$YK2#K|i K f8>2>2%iK2$Ki|n K ѫ*;XB Vi>2&\K2%K|#P  K huB>2>2'K2.K@e#P | K 0>2(]K2'K|#P  K 9|H>2)K2(K#P |  K ޶>2*^K2)K||#P  K A9P>2+K2*K#P @|  K CU>2,_K2+K||#P  K r>2-K2,K#P |  K F0>2.dK2-K||c K B>2/@K2<Kc|  @K {{U>20eK2/K1i|c K 21@K20Kc|  K c*M >22fK21K1i| K! K Xm!>23z~K26K K!|  K 4\;@p">24gK23K| K! K }3 Ia#>25zK24K K!|  K 聆h$>26dK25K|z K tTld%>27@K22Kz|  K bvKI&>2@8eK27KJ|z K '>29@K28Kz|  K  Q(>2:fK29KJ|z K U ))>2;@K2:Kz|  K d/ a*>2<@5b2Kb@0| @28@backupfiledbomsdb b \>2=b2Lb.6|(.backupfiledbo  b _>2>6b2=bJ0| @<BJbackupfilegroupdbomsdbe b zb>2?b2>b@86|28backupfilegroupdbo b [xs>2@7b2?bN00| @@FNbackupmediafamilydbomsdbb b : (!i>2Ab2@b<6|6<backupmediafamilydbo b K% int>2B8b2AbH0|@ @:@Hbackupmediasetdbomsdb b b>2Cb2Bb6_6|06backupmediasetdbo b ފyEb!>2D9b2Cb> 0| @06>backupsetdbomsdb b xb>2E b2Db, 6|&,backupsetd@o b tWj2>2F:b2EbBn0| @4:Brestorefiledbomsdb b Vf7@76>2Gb2Fb0p6|*0restorefiledbo b Cd>2H;b2GbL?0| @>DLrestorefilegroupdbomsdb b wV@Ijob>2Ib2Hb:?6|4:restorefilegroupdbot b wfBust>2J<b2IbHo0| @:@Hrestorehistorydbomsdb b &Ts>2K!b2Jb6l6|06restorehistorydbo b - e02@7"L2=sy;P;::X98 876X655`43321p10x0///..--,,+ +*(*)0)(8('@'&H&%P%$X$#`#"h"!p! x ``P@ x(l_help_queue_sp0?@@?Esysmail_logmailevent_sp0?@@?osysmail_OutMailAttachmentEncodingMustBeValid0?@@?asysmail_OutMailSensitivityMustBeValid0?@@?HSSYSMAIL_PROFILE_IDMustBeUnique0?@@??sysmail_send_retries0?@@?]SYSMAIL_SERVERTYPE_TypeMustBeUnique0?@@?Isysmail_update_account_sp0?@@?Isysmail_verify_account_sp0?@@?7sysmaintplan_log0?@@?7sysnotifications0HPbEK i e( o."Px@2d5@367"L5DUpdateQPStats2 ) >28<)<[=[<)  < .9o !L  ?" 67"L ?@@E@@@D@%@D? :%`D?D?!LH@ @?@X@ fG? EIDEN0267"L2LL) 8( /*return the information about the plan itself*/ SELECT * FROM msdb.dbo.sysdbmaintplans WHERE plan_id=@plan_id /*return the information about databases this plan defined on*/ SELECT database_name FROM msdb.dbo.sysdbmaintplan_databases WHERE plan_id=@plan_id /*return the information about the jobs that relating to the plan*/ @ SELECT job_id FROM msdb.dbo.sysdbmaintplan_jobs WHERE plan_id=@plan_id END ELSE BEGIN SELECT * FROM msdb.dbo.sysdbmaintplans END END  < bj >2x)2h)E0-^$$E@plan_id ) KU}>2x 8)2h )"6^"@plan_id ) \7@ >2x  "2x"E@d^ " % >2x  "2x " ^ " %m>2x K2hK^?|| K "4& ">2x K2hK?||^ K ۍa >2x@2x K^?|| K £  '8>2xK2xK?||^P K / 2ޫt>2xK2xK^"w K mrf+U HkS>2xK2xK"w^P K /* >2xK2x@K^"w K F _}>2xK2xK"w^P K rAj ^y>2xK2xK^!Jo K ain>2xNK2xKP!Jo^ K /1A>2xK2xKHn^!Jo K |]yz>2xPK2xKh !Jo^ K {tem>2xK2xKa^!Jo K ϛu >2xQK2xK!Jo^  K <@s_v>2xK2xKd@@@@@PI)025> c2( *pBNdda@387"LDDCREATE TABLEnsa2  *p>2"2"`0, *p U 87"L87"L `log_shipping_primaries " !Oh>2 "2X"@:& *p:log_shipping_primaries_ " W}Cbas>2 "2":& *p:log_shipping_primaries " :Rete>2zf"2"  *p " ,2>2"2" @ *p " !O>2@)2h)I0- *p88 Iprimary_id ) >2 )1)&6 *p&primary_iddb ) GD% 2  *p2   *p >2 )2 ) 00IK *pN  ) trIKXny@sta>2 )2 )[es0- *p4[primary_server_namer ) B?x0ows_pe>2)2 )8Ro6 *p8primary_server_name ) E@Xk >2)2)_UN0- *p4_primary_databa@se_nameR ) s*< >2)2)<r_6 *p<primary_database_name ) Mownloa>2)2)[ET0- *p$$[maintenance_plan_idf ) VfFIECUTE >2)28$)8 6 *p8maintenance_pla@_id ) -l >2)2)U 0- *p88 Ubackup_threshold  ) zE' >2*)28)2ax6 *p2backup_thresholdec ) SIrver i>2)2)S d0- *p88 Sthreshold_@alertp ) .~gKEY_LO>2\)28)0Mi6 *p0threshold_alert ) N> >2 )2)c 0- *phhcthreshold_alert_enabled  ) cbloaded>2])2)@ D6 *p@threshold_alert_ena@led ) /L@c>2 )2)]WH0- *p4]last_backup_filename ro ) dlrv>2)2):ro6 *p:last_backup_filenameer ) Br I>2 )2)MLE0- *p ==Mla@st_updated(ta ) ([na>2P)2)*DE6 *p *last_updated ) zOI0dk8>2 )2)gRE0- *p 88 gplanned_outage_start_time  ) trn>2s)28)Dsd6 *p Dplanned_outage_@tart_time ) ,Cvmdataba>2 )2)cb.0- *p 88 cplanned_outage_end_timee ) Pz the p>2 s)2)@ 6 *p @planned_outage_end_time ) d=.d>2!)2 )kCR0- *p 88 @kplanned_outage_weekday_mask  ) 2ujttachm>2"s)2!)Hbo6 *p Hplanned_outage_weekday_mask ) Zyh}id>2#)2")UME0- *p 4Usource_directory8 ) 9>2$F)28)@26 *p 2source_directory ) V>2%"2"  *p " !O> c2(BNd{rX>> c2'({rXL2>2&F2x`>9 *p"  5 ba @ 8se2)  > c2(id T>2*G2xGMstI DI  rfG >2,52xFNS (  OmHT >2-2x$>e @:8_h  F{r IS>2.2.>up:4OM  O(BE>2/2/>et:4ba  _Ser>2020>HE:$@   g&6?id>2121>fi:8   j >2222> D:8id  ~^.~st>2323> (:h is@  rhi>24 24> F:4   <ǔba>25 25> : =! Qu  X"o.>26 26>me: 8)    l$$ >2@7 27>WH: 8-    ֳ(TE>28 28>bm: 81    :o]d)>2929> : 4  0  /IQCO$2: R@>2;62xU6k0' *p+ kPK__log_ship__ED3BE1111758727BQ 6 uuOame>2<}62xV6L6 *pLPK__log_ship__ED3BE1111758727B 6 $z-4g>2=v72xX7 *p  7 i _@>2>-72xZ7 *p׮ 7 HM >2?<2x\<"0< *p "> < ߟ+|$2@2>2AF2) "F  8 > c2+(L@2B@  L>2D""2&"p0,LPK *p87"L87"L pPK__log_ship__ED3BE1111758727B " Dm 2>2E"2"J &LJPK__log_ship__ED3BE1111758727BK " 5L>2F"2"J&LJPK__log_s@ip__ED3BE1111758727BK " $>2>2Gz"2"  *pL " B9 0287"L2"(H('&&%%(%%x$$#""!8! Xx8X@8p `h00  ( p (hp@ xhx( K }@>2!iK2 K@ K r b>2"EK2!Ki K `1>2#iK2"K5Ii5I K IYr>2$FK2#K~1i K Z=~sst>2%iK2$Ki@ K 2 _>2&IK2%K#P  K  9{ >2'K/0K#P  K ,">2(JK2'Kp#P  K ڜ5>2)K2(K#P  KH G4>2*KK2)K#P  K 0+$>2+K2*K#P  K q{94>2,LK2+K#P " K N>2-K2,KH#P "H @@@hsbnP8 02(d> c2C(@&4da@3T7"LSDCREATE TABLEnsa2  @>2'"2E"d0,@ U T7"LT7"L dlog_shipping_secondaries " ^P">2 "2F@">&@>log_shipping_secondariesh " >2 "2G">&@>log_shipping_secondariesh " S5 n>2zo"2H" @ " hE">2'"2" @ " ^P>2@/S)!5)Ile0-@88 Iprimary_idP ) | >2  )2)&6@&primary_id ) 'ȣ:_i>2 /T)2 )_se0-@4_secondary_server_namea ) H' qQry>2 @)2 )<ve6@<secondary_server_name ) H0N dbo.>2 /U)2 )c 0-@4csecondary_database_named ) L] = s.o>2 )2 )@LB6@@secondary_database_name ) UCE>2@/V)2 )]CH0-@4]last_copied_filenameove ) !{(sp>2)2): 6@:last_copied_filename90 ) l_D1231))>2/W)2)]010-@4]last_loaded_filename )@ m$ V>2)2):se6@:last_loaded_filenameng ) )PER(CO>2/X)2)e 0-@==elast_copied_last_updated  ) Y> ٘ F>2)2)B6@Blast_copied_last_update@ti ) r&0) = '>2/Y)2)eT 0-@==elast_loaded_last_updatedNT  ) U2)2)BIM6@Blast_loaded_last_updated  ) h#jror_se>2/Z)2)W E0-@$$@Wsecondary_plan_idE ) Pr% >2)2)4@p6@4secondary_plan_id ) y;y @time@3T7"LTDteSplitPageut > >2 )2 cRO(14@87,@2)P2)@/-T @par>2)2KO0-k4K@msx_server 0-k88 O@jobs_deleted<2 /[)22>2/)2b >2)/xh/O@>2 o)2h)k@j02T7"L2>2/[)2)M0-@ hhMcopy_enabled @o ) q_;~S >2#/)28)*p_6@ *copy_enabled  ) VxG) D>2$/\)2@#)MIN0-@ hhMload_enableddb. ) k! b>2%i)2)*_s6@ *load_enabledFR ) 2G- WHE@3T7"LUD_iSplitPage_i) >2' )2c  HER@ ba@2()@P2))/- WHER>2*/)2%baet_id)>2+)2/ouHERE b>2,o)2!)@b@ IF (@@e02'T7"L2'.resto>2&)2*)_ 0-@ 88@ _out_of_sync_thresholdT ) h'~ef>2/sk)2#)< 6@ <out_of_sync_threshold )  ~ Quit >20)2/)SN 0-@ 88 Sthreshold_alert) ) PI GO>21])2)@(S6@ 0threshold_alert ) m I>22)21)c 0-@ hhcthreshold_alert_enabled  ) N"M@media>23_)22)@ 6@ @threshold_alert_enabled ) N{it>24)23)gms@-@88 gplanned_outage_start_time  ) Iz  ) >25s)20)D.m6@Dplanned_outage_start_time ) 2v8=Quit: >26)25)c0-@88 cplanned_outage_end_time ) 6gl_da>27Hs)26)@6@@planned_outage_end_time ) Qu(Php`xH`P(@H x  P P(px( Oת>2"2" | " OתK>2(Php`xH`P(@H x  P P(00d