cxR0-,zz|~*.88FVVVVVVVfffpzRhMwQ!@ @dVF~S\MSDBLogcc{rXUmsdb Z?. 4a_lM|a]20q_lM|a]2cUw {*NSscc@{rXUmsdb Z?. 4a_lM|a]20q_lM|a]2cUw {*NSscc{rXUmsdb Z?. 4a_lM|a]20q_lM|a]2cUw {*NSscc{rXUmsdb Z?0 4a_lM|a]20q_lM|a]2cUw {*NSscc@{rXUmsdb Z?0 4a_lM|a]20q_lM|a]2cUw {*NSs Z?h' 4a_lM|a]20q_lM|a]2cUw {*NSscc{rXUmsdb Z?) 4a_lM|a]20q_lM|a]2cUw {*NSscc@{rXUmsdb Z?) 4a_lM|a]20q_lM|a]2cUw {*NSscc{rXUmsdb Z?) 4a_lM|a]20q_lM|a]2cUw {*NSscc{rXUmsdb Z?. 4a_lM|a]20q_lM|a]2cUw {*NSsdVF~S\MSDBLogM|a]2cUw {*NSs `? RP2005-10-14 02:04:09.52 spid5s Starting up database 'msdb'. #KP ?0`>(J;"c& >(L5-=>(L@>("L@?L@?L @?L @?L/@? L @? L ? L @? L @? L @?L @?L @?L @?L @?L@?L@?L@?L@?L @?L@?L @?L@?L@?L@?L@?L@?L@?L@? L@?!L@?"LJIH(HXGFEDDHCxBA@@8?h>=<;(;X:9877H6x543382h1080@P?8k?J;"?c@@@@@@@&?@A0' 3:J;"FileSize>?@' UL>@L @ L 0@?@' %P?@J;"h@@@@@@@R?Hm0?@' J;"?@ |:@@@@@@@" ?P3i `?};"c' ?L5-=?L@?#L@?PL@?PL @?PL @?PL0@?PL @?P L @?P L @?P L @?P L @?P L @?PL @PL @?PL @?PL@?PL@?PL@?PL@?PL @?PL@?PL @?PL@?PL@?PL@?PL@?PL@?PL@?PL@?PL@?P L@?P!L| <l,\L| < l ,\L|H@? ?`!VF?P};"?Pca~?hS`?P};"c' ?pv?h};"?hc @ L 0@?@' %P?@J;"h?xpX0)  ~>"StartupDB>?x)  c=$@db?@?x) %?x>">?x)  c=$@dR?+>0?x) >"?x |:>">?x)  c=$@d~?!La`?h_"c) c=$@d?!?_"?c @d?QX0+  a"StartupDB>?+  c?x$@db?*@?+ -%?b">?+  c?x$@dR?+d>0?+ b"? |:b">?+  c?x$@d l?rk0, 3Q""CREATE STATISTICS?, ?,  Z3>?, 6<6a0'Z3 a_WA_Sys_00000003_07F6335A 6 ]>?, ~ 6=@6B6Z3B_WA_Sys_0000003_07F6335A 6 ;e=>?, <= <"0?, qV7=@7Z3 7 ^qW>?, <?< ?, 6?6   Z3 6 ]0?, "?la$40|0 l?1'0- 3""CREATE STATISTICS?- ?-  [y>?- 6? 6a0'[y a_WA_Sys_00000002_108B795B 6 `U(>?- ~6?6B6[yB_WA_Sys_0000002_108B795B 6 mz>?- <?<"0<[y " < > _>?- qr7?7[y 7 abr>?- <?< <[y < > _>?- 6?6   [y 6 `U(0?- "?la$40|0T?0. 3"UpdateQPStatsTC?.  ^KK*>?. .<?<  "$ "1 C=@A@2I`w/F]t?????????????????? ?? ?? ?? ????????????????b??c<^KK* <  ~0?. "?ukt" ?p>`?"c. ?P65-=?P6@?P"6f@?6f@?6f@?6@?6h@ ?6@ ? 6@ ? 6f@ ? 6 f@ ? 6 h@? 6 ?75-=7@?7@?7@?7@?7@?7@?7@?7?<5-=?<&?<1-1=@?<@ ?<@!?<@"?<@#?<S@$?<S?65-=0?6| <l,\L| < l ,\L|? ?H?"?ca65-=?P6@?P"6f@?6f@?6f@?6@?6h@ ?6@ ? 6@ ? 6f@ ? 6 f@ ? 6 h@? 6 ?75-=7@?7@?7@?7@?7~?@M*`?"c. 65-=?P6@?P"6f@?6f@?6f@?6@?6h@ ?6@ ? 6@ ? 6f@ ? 6 f@ ? 6 h@? 6 ?75-=7@?7@?7@?7@?7?@Y?"?c65-=?P6@?P"6f@?6f@?6f@?6@?6h@ ?6@ ? 6@ ? 6f@ ? 6 f@ ? 6 h@? 6 ?75-=7@?7@?7@?7@?7?2X00  p"StartupDB>?0  c?$@db?@?0 Q%?p">?0  c?$@dR?+>0?0 p"? |:p">?0  c?$@d~?!P`?"c0 c?$@d?$V?"?ca@d@-P6P2005-10-14 01:54:05.24 spid51 Starting up database 'msdb'. @5(!a<?,@5,@5,@@5(!ȭCȳ@Hy B6@5a< B6,@5,@5,@5(! `Cȳ@ =Hy D6@5aP<C6,@5,@5,@5(!ȮCȳ@E64PODzHy `F6@5a@<E6,@5,@5,`@5(!Cȳ@Hy 0H6@5a<G6,@5,@5,@5(!`0Cȳ@rtI64Hy J6@5a<`I6,@5,@5,@5(!  Cȳ@ 8?DK64TBPOBHy K6@5`aP<0K6,@5НC,@5,@5(!7#M6N6Cȳ@kpDM64BHAp5Hy M6@5a@<M6,@5C,@5,@5(!7#N6N6Cȳ@N647#B0@@AstHy pO6@5a@<N6,@50C,Pz-9*703 GRANT*Y0- ,-%b- ,-%b>-e,-%b SL G  kE0--f<dExternalMailQueueListener " o1҄>,B",0"@Fs&o*Y0Fsp_ExternalMailQueueListener " fkP>,E",0"Ft&o*Y0Fsp_ExternalMailQueueListener " dcJ>,z",h" o*Y0 " p30?>, <,h p DUE sD_Ge ltD@,<@P, l< >, l<, <A i >, l<, <Ah-- Processes messages from the external mail queue -- CREATE PROCEDURE sp_ExternalMailQueueListener AS BEGIN DECLARE @idoc INT, @mailitem_id INT, @sent_status INT, @s@nt_account_id INT, @rc INT, @processId INT, @sent_date DATETIME, @localmessage NVARCHAR(max), @conv_handle uniqueidentifier, @message_type_name NVARCHAR(256), @xml_message_body VARCHAR(max), @LogMessage NVARCHAR(max) -- Table to store message information. DECLARE @msgs TABLE ( [conversation_handle] uniqueidentifier, [message_type_name] nv@rchar(256), [message_body] varbinary(max) ) --RECEIVE messages from the exernal queue. --MailItem status messages are sent from the external sql mail process along with other SSB notifications and errors ;RECEIVE conversation_handle, message_type_name, message_body FROM InternalMailQueue INTO @msgs -- Check if there was some error in reading from queue SET @rc = @@ERROR IF (@rc <> 0) BEGIN --Log error and continue. Don't want to block the@following messages on the queue SET @localmessage = FORMATMESSAGE(@@ERROR) exec msdb.dbo.sysmail_logmailevent_sp @event_type=3, @description=@localmessage GOTO ErrorHandler; END ----------------------------------- --Process sendmail status messages SELECT @conv_handle = conversation_handle, @message_type_name = message_type_name, @xml_message_body = CAST(message_body AS VARCHAR(MAX)) FROM @msgs WHERE [me@sage_type_name] = N'{//www.microsoft.com/databasemail/messages}SendMailStatus' IF(@message_type_name IS NOT NULL) BEGIN -- --Expecting the xml body to be n the following form: -- -- -- -- -- -- -- -- -- -- -- -- -- Get the handle to the xml document EXEC @rc = sp_xml_preparedocument @idoc OUTPUT, @xmH@@@@@@Pz-Ɵ03 GRANTNM1- ,fc- ,fc>-e-fc SL G  |e0--f<dsysmail_activate" " i8>, 7",h"4&@NM14sp_sysmail_activate " ɏ>, =",h"4s&NM14sp_sysmail_activate " ]B>,z"," NM1 " bD€>,<,<W0NM1@ W8-- sp_sysmail_activate : Starts the DatabaseMail process if it isn't already run@ing -- CREATE PROCEDURE sp_sysmail_activate AS BEGIN DECLARE @mailDbName sysname DECLARE @mailDbId INT DECLARE @mailEngineLifeMin INT DECLARE @loggingLevel nvarchar(256) DECLARE @loggingLevelInt int DECLARE @parameter_value nvarchar(256) DECLARE @localmessage nvarchar(max) DECLARE @rc INT EXEC @rc = msdb.dbo.sysmail_help_configure_value_sp @parameter_name = N'DatabaseMailExeMinimumLifeTime', @par@meter_value = @parameter_value OUTPUT IF(@rc <> 0) RETURN (1) --ConvertToInt will return the default if @parameter_value is null or config value can't be converted --Setting max exe lifetime is 1 week (604800 secs). Can't see a reason for it to ever run longer that this SET @mailEngineLifeMin = dbo.ConvertToInt(@parameter_value, 604800, 600) --Try and get the optional logging level for the DatabaseMail process EXEC msdb.dbo.sysmail_help_configure_value_sp @pa@ameter_name = N'LoggingLevel', @parameter_value = @loggingLevel OUTPUT --Convert logging level into string value for passing into XP SET @loggingLevelInt = dbo.ConvertToInt(@loggingLevel, 3, 2) IF @loggingLevelInt = 1 SET @loggingLevel = 'Normal' ELSE IF @loggingLevelInt = 3 SET @loggingLevel = 'Verbose' ELSE -- default SET @loggingLevel = 'Extended' SET @mailDbName = DB_NAME() SET @mailDbId@ = DB_ID() EXEC @rc = master..xp_sysmail_activate @mailDbId, @mailDbName, @mailEngineLifeMin, @loggingLevel IF(@rc <> 0) BEGIN SET @localmessage = FORMATMESSAGE(14637) exec msdb.dbo.sysmail_logmailevent_sp @event_type=3, @description=@localmessage END ELSE BEGIN SET @localmessage = FORMATMESSAGE(14638) exec msdb.dbo.sysmail_logmailevent_sp @event_type=0, @description=@localmessage END RETURN @rc END  < }I @>, ","-syadmNM1 " i8ul>,  NK,KRoNM1UF K b`bno>,  WK,H+K(IUFNM1MB K 1)>,  OK, KD NM1 " K `6du>, KHKsc "NM1ul K o-we>,  NK, KIFNM1W K +w+IN>,iK,hHK WNM1th K S 0,n,l_e @P ` p HHhD -- to determine if the schedule ID is for local jobs or MSX jobs. -- Note, an MSX job can'tH@@@@@@Pz- E03 GRANTta-  , d-  , d>- e- d SL GeM  e0- - f<d]%1& 1DatabaseMailUserRole   @_>,_%(6 (  7"yJ  6?Us>,a$J,hJ3  J <\S>,c J,hJ3  J =_J,  ,  >, W @%@@R0#2 RDatabaseMailUserRole @ ;4>, Y@% @2Se&2 2DatabaseMailUserRoleE  @ &_of>, a$J,J 2  J ;춴nnt>, c5J,JCH 2  J@ D/ ,   0,,rm8 |px = NULL, @importance VARCHAR(6) = 'NORMAL', @sensitivity VARCHAR(12) = 'NORMAL', @file_attachments NVARCHAR(MAX) = NULL, @query NVARCHAR(MAX) = NULL, @execute_query_database sysname = NULL, @attach_query_result_as_file BIT = 0, @query_attachment_filena@e NVARCHAR(260) = NULL, @query_result_header BIT = 1, @query_result_width INT = 256, @query_result_separator CHAR(1) = ' ', @exclude_query_output BIT = 0, @append_query_error BIT = 0, @query_no_truncate BIT = 0, @mailitem_id INT = NULL OUTPUT WITH EXECUTE AS 'dbo' AS BEGIN SET NOCOUNT ON -- And make sure ARITHABORT is on. This is the defau@t for yukon DB's SET ARITHABORT ON --Declare variables used by the procedure internally DECLARE @profile_id INT, @temp_table_uid uniqueidentifier, @sendmailxml VARCHAR(max), @CR_str NVARCHAR(2), @localmessage NVARCHAR(255), @QueryResultsExist INT, @AttachmentsExist INT, @RetErrorMsg NVARCHAR(4000), --Impose a limit on the error message length to avoid me@ory abuse @rc INT, @procName sysname, @trancountSave INT, @tranStartedBool INT, @is_sysadmin BIT, @send_request_user sysname, @database_user_id INT -- Initialize SELECT @rc = 0, @QueryResultsExist = 0, @AttachmentsExist = 0, @temp_table_uid = NEWID(), @procName = OBJECT_NAME(@@PROCID),H @tranStartedBool = 0, @trancountSave = @@TRANCOUNT EXECUTE AS CALLER SELECT @is_sysadmin = IS_SRVROLEMEMBER('sysadmin'), @send_request_user = SUSER_SNAME(), @database_user_id = USER_ID() REVERT --Check if SSB is enabled in this database IF (ISNULL(DATABASEPROPERTYEX(DB_NAME(), N'IsBrokerEnabled'), 0) <> 1) BEGIN RAISERROR(14650, 16, 1) RETURN 1 END --Report error if the<H@@@@@@Pz-(03 GRANT*Y0-( ,e-( ,e>-(e- e SL G  670-(-(f<dExternalMailQueueListener " o1҄>,B",0"@Fs&o*Y0Fsp_ExternalMailQueueListener " fkP>,E",0"Ft&o*Y0Fsp_ExternalMailQueueListener " dcJ>,z",h" o*Y0 " p30?>, <,h p DUE sD_Ge ltD@,<@P, l< >, l<, <A i >, l<, <Ah-- Processes messages from the external mail queue -- CREATE PROCEDURE sp_ExternalMailQueueListener AS BEGIN DECLARE @idoc INT, @mailitem_id INT, @sent_status INT, @s@nt_account_id INT, @rc INT, @processId INT, @sent_date DATETIME, @localmessage NVARCHAR(max), @conv_handle uniqueidentifier, @message_type_name NVARCHAR(256), @xml_message_body VARCHAR(max), @LogMessage NVARCHAR(max) -- Table to store message information. DECLARE @msgs TABLE ( [conversation_handle] uniqueidentifier, [message_type_name] nv@rchar(256), [message_body] varbinary(max) ) --RECEIVE messages from the exernal queue. --MailItem status messages are sent from the external sql mail process along with other SSB notifications and errors ;RECEIVE conversation_handle, message_type_name, message_body FROM InternalMailQueue INTO @msgs -- Check if there was some error in reading from queue SET @rc = @@ERROR IF (@rc <> 0) BEGIN --Log error and continue. Don't want to block the@following messages on the queue SET @localmessage = FORMATMESSAGE(@@ERROR) exec msdb.dbo.sysmail_logmailevent_sp @event_type=3, @description=@localmessage GOTO ErrorHandler; END ----------------------------------- --Process sendmail status messages SELECT @conv_handle = conversation_handle, @message_type_name = message_type_name, @xml_message_body = CAST(message_body AS VARCHAR(MAX)) FROM @msgs WHERE [me@sage_type_name] = N'{//www.microsoft.com/databasemail/messages}SendMailStatus' IF(@message_type_name IS NOT NULL) BEGIN -- --Expecting the xml body to be n the following form: -- -- -- -- -- -- -- -- -- -- -- -- -- Get the handle to the xml document EXEC @rc = sp_xml_preparedocument @idoc OUTPUT, @xmH@@@@@@Pz-0~\03 GRANTNM1-0 ,.ֺj-0 ,.ֺj>-0e-(.ֺj SL G  0-0-0f<dsysmail_activate" " i8>, 7",h"4&@NM14sp_sysmail_activate " ɏ>, =",h"4s&NM14sp_sysmail_activate " ]B>,z"," NM1 " bD€>,<,<W0NM1@ W8-- sp_sysmail_activate : Starts the DatabaseMail process if it isn't already run@ing -- CREATE PROCEDURE sp_sysmail_activate AS BEGIN DECLARE @mailDbName sysname DECLARE @mailDbId INT DECLARE @mailEngineLifeMin INT DECLARE @loggingLevel nvarchar(256) DECLARE @loggingLevelInt int DECLARE @parameter_value nvarchar(256) DECLARE @localmessage nvarchar(max) DECLARE @rc INT EXEC @rc = msdb.dbo.sysmail_help_configure_value_sp @parameter_name = N'DatabaseMailExeMinimumLifeTime', @par@meter_value = @parameter_value OUTPUT IF(@rc <> 0) RETURN (1) --ConvertToInt will return the default if @parameter_value is null or config value can't be converted --Setting max exe lifetime is 1 week (604800 secs). Can't see a reason for it to ever run longer that this SET @mailEngineLifeMin = dbo.ConvertToInt(@parameter_value, 604800, 600) --Try and get the optional logging level for the DatabaseMail process EXEC msdb.dbo.sysmail_help_configure_value_sp @pa@ameter_name = N'LoggingLevel', @parameter_value = @loggingLevel OUTPUT --Convert logging level into string value for passing into XP SET @loggingLevelInt = dbo.ConvertToInt(@loggingLevel, 3, 2) IF @loggingLevelInt = 1 SET @loggingLevel = 'Normal' ELSE IF @loggingLevelInt = 3 SET @loggingLevel = 'Verbose' ELSE -- default SET @loggingLevel = 'Extended' SET @mailDbName = DB_NAME() SET @mailDbId@ = DB_ID() EXEC @rc = master..xp_sysmail_activate @mailDbId, @mailDbName, @mailEngineLifeMin, @loggingLevel IF(@rc <> 0) BEGIN SET @localmessage = FORMATMESSAGE(14637) exec msdb.dbo.sysmail_logmailevent_sp @event_type=3, @description=@localmessage END ELSE BEGIN SET @localmessage = FORMATMESSAGE(14638) exec msdb.dbo.sysmail_logmailevent_sp @event_type=0, @description=@localmessage END RETURN @rc END  < }I @>, ","-syadmNM1 " i8ul>,  NK,KRoNM1UF K b`bno>,  WK,H+K(IUFNM1MB K 1)>,  OK, KD NM1 " K `6du>, KHKsc "NM1ul K o-we>,  NK, KIFNM1W K +w+IN>,iK,hHK WNM1th K S 0,n,l_e @P ` p HHhD -- to determine if the schedule ID is for local jobs or MSX jobs. -- Note, an MSX job can'tH@@@@@@Pz-8ȏ03 GRANTta-8 ,d8u-8 ,d8u>-8e-0d8u SL GeM  0-8-8f<d]%1& 1DatabaseMailUserRole   @_>,_%(6 (  7"yJ  6?Us>,a$J,hJ3  J <\S>,c J,hJ3  J =_J,  ,  >, W @%@@R0#2 RDatabaseMailUserRole @ ;4>, Y@% @2Se&2 2DatabaseMailUserRoleE  @ &_of>, a$J,J 2  J ;춴nnt>, c5J,JCH 2  J@ D/ ,   0,,rm8 |px = NULL, @importance VARCHAR(6) = 'NORMAL', @sensitivity VARCHAR(12) = 'NORMAL', @file_attachments NVARCHAR(MAX) = NULL, @query NVARCHAR(MAX) = NULL, @execute_query_database sysname = NULL, @attach_query_result_as_file BIT = 0, @query_attachment_filena@e NVARCHAR(260) = NULL, @query_result_header BIT = 1, @query_result_width INT = 256, @query_result_separator CHAR(1) = ' ', @exclude_query_output BIT = 0, @append_query_error BIT = 0, @query_no_truncate BIT = 0, @mailitem_id INT = NULL OUTPUT WITH EXECUTE AS 'dbo' AS BEGIN SET NOCOUNT ON -- And make sure ARITHABORT is on. This is the defau@t for yukon DB's SET ARITHABORT ON --Declare variables used by the procedure internally DECLARE @profile_id INT, @temp_table_uid uniqueidentifier, @sendmailxml VARCHAR(max), @CR_str NVARCHAR(2), @localmessage NVARCHAR(255), @QueryResultsExist INT, @AttachmentsExist INT, @RetErrorMsg NVARCHAR(4000), --Impose a limit on the error message length to avoid me@ory abuse @rc INT, @procName sysname, @trancountSave INT, @tranStartedBool INT, @is_sysadmin BIT, @send_request_user sysname, @database_user_id INT -- Initialize SELECT @rc = 0, @QueryResultsExist = 0, @AttachmentsExist = 0, @temp_table_uid = NEWID(), @procName = OBJECT_NAME(@@PROCID),H @tranStartedBool = 0, @trancountSave = @@TRANCOUNT EXECUTE AS CALLER SELECT @is_sysadmin = IS_SRVROLEMEMBER('sysadmin'), @send_request_user = SUSER_SNAME(), @database_user_id = USER_ID() REVERT --Check if SSB is enabled in this database IF (ISNULL(DATABASEPROPERTYEX(DB_NAME(), N'IsBrokerEnabled'), 0) <> 1) BEGIN RAISERROR(14650, 16, 1) RETURN 1 END --Report error if the<H@@@@@@P-@9Y03CREATE MSGTYPE-@ >-@0 :0'N  {//www.microsoft.com/databasemail/messages}SendMailt : Q!ƈe>-@$ :t&t{//www.mi@rosoft.com/databasemail/messages}SendMail : -@aJ, Jt5 J 5@u>-@c"J, J5 J 6H`-@ 0-@-@ \ltD_Ge ltD@,<@P, l< >, l<, <A i >, l<, <Ah-- Processes messages from the external mail queue -- CREATE PROCEDURE sp_ExternalMailQueueListener AS BEGIN DECLARE @idoc INT, @mailitem_id INT, @sent_status INT, @s@nt_account_id INT, @rc INT, @processId INT, @sent_date DATETIME, @localmessage NVARCHAR(max), @conv_handle uniqueidentifier, @message_type_name NVARCHAR(256), @xml_message_body VARCHAR(max), @LogMessage NVARCHAR(max) -- Table to store message information. DECLARE @msgs TABLE ( [conversation_handle] uniqueidentifier, [message_type_name] nv@rchar(256), [message_body] varbinary(max) ) --RECEIVE messages from the exernal queue. --MailItem status messages are sent from the external sql mail process along with other SSB notifications and errors ;RECEIVE conversation_handle, message_type_name, message_body FROM InternalMailQueue INTO @msgs -- Check if there was some error in reading from queue SET @rc = @@ERROR IF (@rc <> 0) BEGIN --Log error and continue. Don't want to block the@following messages on the queue SET @localmessage = FORMATMESSAGE(@@ERROR) exec msdb.dbo.sysmail_logmailevent_sp @event_type=3, @description=@localmessage GOTO ErrorHandler; END ----------------------------------- --Process sendmail status messages SELECT @conv_handle = conversation_handle, @message_type_name = message_type_name, @xml_message_body = CAST(message_body AS VARCHAR(MAX)) FROM @msgs WHERE [me@sage_type_name] = N'{//www.microsoft.com/databasemail/messages}SendMailStatus' IF(@message_type_name IS NOT NULL) BEGIN -- --Expecting the xml body to be n the following form: -- -- -- -- -- -- -- -- -- -- -- -- -- Get the handle to the xml document EXEC @rc = sp_xml_preparedocument @idoc OUTPUT, @xmH@@@@@cP-HS03CREATE MSGTYPE-H >-H0-@:0'N  {//www.microsoft.com/databasemail/messages}SendMailStatusa : 4Fz0">-H$-@:&{//@ww.microsoft.com/databasemail/messages}SendMailStatus : M ,>-HaJ-@J"5 J 6P;>-Hc#J-@J5 J 7H-H 0-H-H e ttcess if it isn't already run@ing -- CREATE PROCEDURE sp_sysmail_activate AS BEGIN DECLARE @mailDbName sysname DECLARE @mailDbId INT DECLARE @mailEngineLifeMin INT DECLARE @loggingLevel nvarchar(256) DECLARE @loggingLevelInt int DECLARE @parameter_value nvarchar(256) DECLARE @localmessage nvarchar(max) DECLARE @rc INT EXEC @rc = msdb.dbo.sysmail_help_configure_value_sp @parameter_name = N'DatabaseMailExeMinimumLifeTime', @par@meter_value = @parameter_value OUTPUT IF(@rc <> 0) RETURN (1) --ConvertToInt will return the default if @parameter_value is null or config value can't be converted --Setting max exe lifetime is 1 week (604800 secs). Can't see a reason for it to ever run longer that this SET @mailEngineLifeMin = dbo.ConvertToInt(@parameter_value, 604800, 600) --Try and get the optional logging level for the DatabaseMail process EXEC msdb.dbo.sysmail_help_configure_value_sp @pa@ameter_name = N'LoggingLevel', @parameter_value = @loggingLevel OUTPUT --Convert logging level into string value for passing into XP SET @loggingLevelInt = dbo.ConvertToInt(@loggingLevel, 3, 2) IF @loggingLevelInt = 1 SET @loggingLevel = 'Normal' ELSE IF @loggingLevelInt = 3 SET @loggingLevel = 'Verbose' ELSE -- default SET @loggingLevel = 'Extended' SET @mailDbName = DB_NAME() SET @mailDbId@ = DB_ID() EXEC @rc = master..xp_sysmail_activate @mailDbId, @mailDbName, @mailEngineLifeMin, @loggingLevel IF(@rc <> 0) BEGIN SET @localmessage = FORMATMESSAGE(14637) exec msdb.dbo.sysmail_logmailevent_sp @event_type=3, @description=@localmessage END ELSE BEGIN SET @localmessage = FORMATMESSAGE(14638) exec msdb.dbo.sysmail_logmailevent_sp @event_type=0, @description=@localmessage END RETURN @rc END  < }I @>, ","-syadmNM1 " i8ul>,  NK,KRoNM1UF K b`bno>,  WK,H+K(IUFNM1MB K 1)>,  OK, KD NM1 " K `6du>, KHKsc "NM1ul K o-we>,  NK, KIFNM1W K +w+IN>,iK,hHK WNM1th K S 0,n,l_e @P ` p HHhD -- to determine if the schedule ID is for local jobs or MSX jobs. -- Note, an MSX job can'tH@@@@@wP -P{;YP031CREATE CONTRACT-P >-P0-H:0' //www.microsoft.com/databasemail/contracts/SendMail/v1.0 : [f>-P$-H:~&~//w@w.microsoft.com/databasemail/contracts/SendMail/v1.0yJ : 7 >-PaJ-HJ6 J 6í >-Pc*J-HJ6  J 7V$v -P >-PghK+ !K@ K C 0>-PihK,Ke@ K C 0>-P giK-PK K ʣ@>-P iiK-P K K 0-P-PHf txCH 2  J@ D/ ,   0,,rm8 |px = NULL, @importance VARCHAR(6) = 'NORMAL', @sensitivity VARCHAR(12) = 'NORMAL', @file_attachments NVARCHAR(MAX) = NULL, @query NVARCHAR(MAX) = NULL, @execute_query_database sysname = NULL, @attach_query_result_as_file BIT = 0, @query_attachment_filena@e NVARCHAR(260) = NULL, @query_result_header BIT = 1, @query_result_width INT = 256, @query_result_separator CHAR(1) = ' ', @exclude_query_output BIT = 0, @append_query_error BIT = 0, @query_no_truncate BIT = 0, @mailitem_id INT = NULL OUTPUT WITH EXECUTE AS 'dbo' AS BEGIN SET NOCOUNT ON -- And make sure ARITHABORT is on. This is the defau@t for yukon DB's SET ARITHABORT ON --Declare variables used by the procedure internally DECLARE @profile_id INT, @temp_table_uid uniqueidentifier, @sendmailxml VARCHAR(max), @CR_str NVARCHAR(2), @localmessage NVARCHAR(255), @QueryResultsExist INT, @AttachmentsExist INT, @RetErrorMsg NVARCHAR(4000), --Impose a limit on the error message length to avoid me@ory abuse @rc INT, @procName sysname, @trancountSave INT, @tranStartedBool INT, @is_sysadmin BIT, @send_request_user sysname, @database_user_id INT -- Initialize SELECT @rc = 0, @QueryResultsExist = 0, @AttachmentsExist = 0, @temp_table_uid = NEWID(), @procName = OBJECT_NAME(@@PROCID),H @tranStartedBool = 0, @trancountSave = @@TRANCOUNT EXECUTE AS CALLER SELECT @is_sysadmin = IS_SRVROLEMEMBER('sysadmin'), @send_request_user = SUSER_SNAME(), @database_user_id = USER_ID() REVERT --Check if SSB is enabled in this database IF (ISNULL(DATABASEPROPERTYEX(DB_NAME(), N'IsBrokerEnabled'), 0) <> 1) BEGIN RAISERROR(14650, 16, 1) RETURN 1 END --Report error if the<H@@@@wPlep-XHT> c,(rA253033CREATE QUEUE-X  rA2>-X ", "Vr0,rA2SQ VInternalMailQueue  " D>>-X0"*"0&rA20Interna@MailQueue " bAa>-X0"*"0&rA20InternalMailQueue " b>-Xz"," rA2 " Fw<>-X<* <h0 rA2 h4[dbo].[sp_ExternalMailQueueListener] < n>-X@aJ-PJrA2 J ]R>-X cJ-PJrA2  J j<>-X  "-X"rA2 " Dp_xtenalailueu> c-X(53S)4-X   53>-X a@-X J (53rA2 J  >-XcJ-X JRCrA2(53 @ J 绎qu>-X"-X "des0,53ITrA2 dqueue_messages_843150049 " ͚CL>-X)"+@ ">er&53>queue_messa@es_843150049ag " }na>-X","> -&53>queue_messages_843150049pr " ? S>-Xz"-X" _trA253me " yal-X  rA2-X  rA2>-X"-X" r a d c53 " ͚he@-X  rA2>-X))r)Asm0-5300Astatus  ) ,n; >-X)*)se653statusLE ) cϔdl-X  rA2>-X)-X)E 0-5300Epriority@sag ) |w.>-X3)*`)"_t653"priority  ) akpe-X  rA2>-X)-X)O 0-53Oqueuing_ordere ) ght>-X_)-X),ml653,queuing_order ) :@> -X  rA2 -X 53ess-X! 53>-X")-X)00OQ53  ) g-0OQj:1Pro-X#  rA2>-X$)-X#)_XE0-53$$_conversation_group_id  )@ Y >-X%p)*)<co653<conversation_group_id ) W Lo-X&  rA2>-X')-X%)[ F0-53$$[conversation_handleo ) ums>-X(t)-X&)8ge6538conversation_@andle ) /fN` s-X)  rA2>-X*)-X()cm_0-53cmessage_sequence_numberi ) U >-X+b)*`)@ 653@message_sequence_number ) [% (-X,  rA2>-X-)-@+)I 0-53$$Imessage_idAcc ) !0s|KtA>-X._)-X,)&Da653&message_id86 ) )Ca-X/  rA2>-X0 )-X.)Sai0-5388 Smessage_type_idx ) "fcc >-X1@g)-X/)0g 6530message_type_id ) gxiqu-X2  rA2>-X3!)-X1)I_h0-53 88 Iservice_id.sy ) #@e>-X4B)*()&SE653 &service_idse ) 6(P-X5  rA2>@X6")-X4)[2,0-53 88 [service_contract_idt ) $50>-X7>)-X5)8 653 8service_contract_id ) 6gag-X8  rA2>-X9#)-X7)I 0-53 Ivalida@tionacc ) %̪D >-X:o)-X)& 653 &validatione  ) Cex_et-X;  rA2>-X<$)-X:)Otu0-53 88 Onext_fragmentt ) &1} >-X=s%))),ai653 ,next_fragment )@ Ls -X>  rA2>-X?%)-X=)O@l0-53 88 Ofragment_sizea ) 'T$am>-X@j)*),en653 ,fragment_size ) :5 -XA  rA2>-XB&)-X@)S_s0-53@Sfragment_bitmapi ) (-XCg)-XA)0--6530fragment_bitmap ) ame-XD  rA2>-XE')-XC)[me0-53@[binary_message_bodyE ) )[Ȏ N>-XF0)-X))@8IF6538binary_message_body ) AM >-XG"-X"age_cu53 " ͚ -XH  p>-XI*>) %pX0d0p e_t   > N*!> P-XK@> R-XL> S-XM> U-XN> X-XO> \-XP> `-XQ> d-XR> e-XS@> j-XT> k-XU> l-XV> n-XW> o-XX> q-XY> s-XZ> u-X[@> y-X\6 ,>-XJ-X]*>'p53  ><-XB>-X_a*I Ep   K>@Xa*6p  :R><-X`>-Xbb-XaI Ep   b>-Xd-Xbp  {H>-Xey@C *2 -)p 0l  >-Xf*3%"pUF  >-XgyD -Xf -)p $   3] >-Xh-Xg%"p> @ a>-XiyE -Xh -K)p $  V:]>-Xj-Xi%>"p  ex>-XkyF -Xj -)p %")(  a$>-Xl-Xk%@"pe_  V:]j>-XmyG -Xl -t)p 0-  exl>-Xn-Xm%t"p  3] c>-XoyH -Xn -)p ._b  dhjY0@3lSplitPaged->-Xq -X^+@@-XrP-Xs">-Xt-Xtj%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%@%%%%%%%%%%%%%%%%%%%%%%%"bam"b"ce"cU"cte"c"c"dA"d"d-"d"d@,"d"d,"d"e"eld"f88"f@n"f"fS"f"g"g"g@M"g"gU"h-"h"h-"h"h"hew"h"hed"h "h  "@h "ial"i"iay"i"isu"j "jc"j@er"j@"j@cu"j "j@@Y"j"j "j da"j @"j st"j @"jct"j"jW"j-"j"jt"j@"jid"j"j-"j"jid"j"jd"k"k"k"kme"k@"k@et"k"l-"l"l"len"m"men"m"m@E"m"mss"m "m@ri"m "n-"n@"nre"o "o_o"o/"o"o@ti"o"ppo"p"@pst"p/"p<-Xu g-Xogh>-Xv-Xvct>-XwB%`[ab0-Xq-Xqv>-Xph-Xu%"p@rr  dhj>-XzyI -Xp -e)p $6  o>-X{i-Xz%"p  >-X|yJ -X{ -)p 8 F-  W4>-X}j-X|@%-"p  Wy>-X~yK -X} -i)p 8 J   2 2>-Xk-X~%e"p   2 2>-XyL -X -4)p 8 N se  u >-X@l-X%/"p   u m>-XyM -X -m)p R   >-Xm-X%"p   >-XyN -X -)p 8 T@   *0>-Xn-X%"p   *$$>-XyO -X -d)p 8 X   eMi>-Xo-X%i"p }  eMi>-XyP -X @-)p \ce  ܯa>-Xp-X%"p  ܯc>-XyQ -X -)p  `>-Xq-X%e"p@  `>@<-Xc_y>-Xc-XdI>Ep N   F>-X-Xep  r8W$-Xpa>-X6*@N6Y0'53 p Yq@ueue_clustered_index 6 vCW>-Xn6*96: 653:queue_clustered_index 6 y>-Xqy7*()753 7 xH>-Xqy7-X753 7 P>-Xqy@-X7>53 7 m>-Xqy7-X753 7 J YK>-X$<).<"0<53`" < W.>-X"-XH"$53 " ͚$-Xp1>-@-XJ p53p  @K-X  q>-X-X)K%qH/5/5q   dΤ-K>-X-X_*'q53K  dΤ-><-X@>-Xd-XIKEq   2>-X-Xq  SB>-XyR -X -)q 0  }K>-Xr-X%"@q   }>>-XyS -X -)q 0:   6 >-Xs-X% "q   6 >-XyT -X - )q   hQt>-X@t-X%"q  hQt>-XyU -X -)q $   i/>-Xu-X%"q  i/ >-XyV -X -en)q $> @  >-Xv-X%"q  >-XyW -X -)q 8 ++  Z>-Xw-X%"q  Z$-Xqa>-X6-@6Y0'53 q Yqueue_secondary_index 6 E>-Xr6-X6:653:queue_secondary_indexQ 6  >-Xq}7-X7K53 Q 7 "5l >-Xq}7-X753@ 7 !~>-Xq}7-X753K 7 >-Xq}7-X7Q53 7 "[>-Xq}7-X7Q532 7 Gc>-Xq}7-X753@> 7  >-X%<-X<"K0<53 " < X>-X"-X"$mN53 " ͚D$-Xqe>-X-X q53q  dΤ-0-X-Xd >cHc$cb@ba0a`0`_0_^]],]\\[ZlZYTYX$$%"N?  p i@>$ $ -y)N06ct  e>$$%t"N@uc  d>$ $ -l)N47ab  ')c>$$%i"Nin  ')_>$ $ -i)N49ra  Bߕ{i>$$@%t"Nts  Bߕ{i>$ $ -o)N0;du  Br>$$%e"Ner  Bg>$ $ -l)Nl <pt  @^i>$$%r"N en  ^e>$ $ -m)Nl Ido  p/KLr>$$%r"N xe  p/KLu>$ $ -)NHl V_  H>$$%"N   H>  $>  $>  $>  $>H@@@@0XX7%--XhggJlPLPp-"> c-X (S)45033CREATE QUEUE-  S)4>-"-X"Vr0,S)4SQ VExternalMailQueuet " S >-"-X"0&S)40Externa@MailQueue " ^a>-"-X"0:&S)40ExternalMailQueue " ^>-z"-X" >S)4 " TQ>-<-X<VH0 S)4 V4[dbo].[sp_sysmail_activate] < _y띠>-a@-XJacS)4 J i >- cJ-XJLAS)4va J j(E >- "-"S)4 " S@r IN EXE> c-(56-   5>- aJ- @Jte(5S)4 J }1)>-cJ- JnuS)4(5 c J %4 ->-"- "dfo0,5ITS)4 dqueue_messages_875150163 " R>V >-*"-X"> &5>queue_messages_8751@0163me "  >-"-X">gg&5>queue_messages_875150163ue " ]ʒ >-z"-" F S)45ve " 柞lo-  S)4-  S)4>-"-"  5 " R>V -@  S)4>-F)-XF)ALi0-500Astatusoca ) 9GE>-)-X;)@d65statusEN ) oxV -  S)4>-G)-)E @0-500Epriority )@ j>-4)-X)"NM65"priority ) KԸN-  S)4>-H)-)O0-5Oqueuing_order ) $>-a)-),NM65,queuing_order ) wbs-@  S)4 - 5 -! 5>-"H)-)00OQ5 ) $OQj -#  S)4>-$I)-#)_ 0-5$$_conversation_group_ido ) u@@>@%r)-XG)<) 65<conversation_group_id ) !Or -&  S)4>-'J)-%)[ -0-5$$[conversation_handled ) Ӯ D>-(w)-&)8se658conversation_handle @) STOT-)  S)4>-*K)-()c 0-5cmessage_sequence_numberd ) =|rc>-+d)-X2)@de65@message_sequence_number ) FZ -,  S)4>--L)-+)@Id 0-5$$Imessage_id  ) Xf >-.`)-,)&he65&message_idsx ) yGER-/  S)4>-0M)-.)S 0-588 Smessage_type_id ) v>-1j)-@/)0650message_type_id ) kep-2  S)4>-3N)-1)I0-5 88 Iservice_id ) kK>-4D)-X8)& 65 &service_idh_ ) X /T,-5  S)4>-6@O)-4)[_h0-5 88 [service_contract_id  ) Y >-7?)-5)8ab65 8service_contract_id ) cBE-8  S)4>-9P)-7)Iit0-5 Ivalidation  @) T,>-:q)-)& 65 &validation  ) rxϝT,-;  S)4>-<Q)-:)Oue0-5 88 Onext_fragmentg ) Y|ar>-=s&)-X>),ry65 ,next_fragment ) %Q3|fo@->  S)4>-?R)-=)Ole0-5 88 Ofragment_sizel ) <}-C>-@l)-XD),fi65 ,fragment_size ) [1'9 I-A  S)4>-BS)-@)She0-5@Sfragment_bitmap  ) ) >-Ch)-A)0at650fragment_bitmap ) CPu -D  S)4>-ET)-C)[ 0-5@[binary_message_body  ) Ntn >-F1)-))86@8binary_message_body ) s- >-G"-"erae a5 " R>Vbe-H  r>-I-X), %rX0d0r --  ʼ0 t>-J-X* c'r5   ʼ0 >@<-CONERT>-Ke-XI Er T(i  n7SE>-M-XC r  -[ ><-LilDNam>-Nf-MIdb@Er t_f  >-P-Nt r  rq@s>-QyX -X - )r 0t,   "Jec>-Rx-X%= "rh   "J >-@yY -R -c )r $  >-Ty-S%"r  Ҕ>-UyZ -T -)r $>  kCY>-Vz-U%"r@h_  (|)>-Wy[ -V -)r %"h  Ҕ)>-Xy-W%"r  kCY>-Yy\ -X -)r 0-  (|>-Zy-Y@%l"r>  >-[y] -Z -)r .  Yn>-\}-[%KK"rKK  Yn>-]y^ -\ - )r $6  <}!s>@^~-]%"r  <}!>-_y_ -^ ->)r 8 F)  jmB->-`-_%o?"r  jmB>-ay` -` -rv)r 8 @J    6>-b-a%"r    6>-cya -b -)r 8 N   K$>-d-c%"r bu  K$ >-eyb -d @-)r R )  >-f-e%p."r   >-gyc -f -))r 8 T t  = Ӭ>-h-g%"r   = m>@iyd -h -)r 8 X   Xe>-j-i%"r   Xhh>-kye -j -e)r \  2)>-l-k%u"r@>  2)>-myf -l -)r  U>-n-m%"r@  U4><-O>-og-PI Er@   |z>-q-Qr  e1$-rra>-s6-X6Y0'5 r Yqueue_clustered_index 6 y4>-to6-X6:65:queue_clus@ered_index 6 .t>-uq7-X7 5 7 ~>-vq7-v7p5> 7 9'>-wq7-w75or 7 \@4>-xq7-x75@t 7  >-y'<-X<")0<5`" < \~e>-z"-H"$5 " R>V$-{re>-|-J r5r  ʼ0-}  s>-~@-})%sH/5/5s @  ool`)>--K*'s5  ool`e><-pe>-h-qIEs )  Lg>@-rs  +e>-yg -n -)s 0  Ib>--o%"s  I>-yh - -)s 0@K  0=>--%"s>  0=>-yi - -)s   U>--%>"s  U>-yj - -@)s $   V+>--%"s  V+K>-yk - -)s $  >--%"s  >-@yl - - )s 8 ++  gq_K>--%l"s  gq_$-sa>-6-t6Y0'5 s Yqueue_secondary_index 6 -B>-@t6-u6:>65:queue_secondary_index 6 * pRY>-q7-y75  7 >-q7-75 7 M >-q7-7K5 7 c @>-q7-75 7 &>-q7-75K 7 G#>-q7-75 7 Q/1>-(<-z<"0<5 "> < [@`>-"-{"$ K5 " R>V$-se>-- s5s  ool`0--d KJtJJIIHHGGFE(EE|DCdCBLBA4A@@??t>=P==x<;;H;$;:0:909808766<65D54,43321t10\0/D/.,.--,+l+*T*)<)($(' '&%l%$d$#l#"H"!p! L @d@(th@<h$t<|<h< h d <  X 0 $L\\(,hcYI  K ,A>+IK+HKcYI K +2>+JZK+IKcYI  K + j>+KK+JKHcYI  K *WO%>>+LK+LK%cYI K )B7>+MWK+KKcYI  K )<@7>>+NK+MK%cYI K (%F>+OVK+NK-t--S5-5JlP 4P-m:031CREATE SERVICE- >-0-P:U0' UInternalMailServiceom : 1ri>-$-P:4[&4InternalMailService : (n>-@aJ-JmrA2 J .>-cJ-JrA2 J }){>-aJ-J7 J 7s>-c0J-J7 J 8- >-@ ghK-P K K zM>- ihK-P K K zM0--tXhXtP K K 0-P-PHf txCH 2  J@ D/ ,   0,,rm8 |px = NULL, @importance VARCHAR(6) = 'NORMAL', @sensitivity VARCHAR(12) = 'NORMAL', @file_attachments NVARCHAR(MAX) = NULL, @query NVARCHAR(MAX) = NULL, @execute_query_database sysname = NULL, @attach_query_result_as_file BIT = 0, @query_attachment_filena@e NVARCHAR(260) = NULL, @query_result_header BIT = 1, @query_result_width INT = 256, @query_result_separator CHAR(1) = ' ', @exclude_query_output BIT = 0, @append_query_error BIT = 0, @query_no_truncate BIT = 0, @mailitem_id INT = NULL OUTPUT WITH EXECUTE AS 'dbo' AS BEGIN SET NOCOUNT ON -- And make sure ARITHABORT is on. This is the defau@t for yukon DB's SET ARITHABORT ON --Declare variables used by the procedure internally DECLARE @profile_id INT, @temp_table_uid uniqueidentifier, @sendmailxml VARCHAR(max), @CR_str NVARCHAR(2), @localmessage NVARCHAR(255), @QueryResultsExist INT, @AttachmentsExist INT, @RetErrorMsg NVARCHAR(4000), --Impose a limit on the error message length to avoid me@ory abuse @rc INT, @procName sysname, @trancountSave INT, @tranStartedBool INT, @is_sysadmin BIT, @send_request_user sysname, @database_user_id INT -- Initialize SELECT @rc = 0, @QueryResultsExist = 0, @AttachmentsExist = 0, @temp_table_uid = NEWID(), @procName = OBJECT_NAME(@@PROCID),H @tranStartedBool = 0, @trancountSave = @@TRANCOUNT EXECUTE AS CALLER SELECT @is_sysadmin = IS_SRVROLEMEMBER('sysadmin'), @send_request_user = SUSER_SNAME(), @database_user_id = USER_ID() REVERT --Check if SSB is enabled in this database IF (ISNULL(DATABASEPROPERTYEX(DB_NAME(), N'IsBrokerEnabled'), 0) <> 1) BEGIN RAISERROR(14650, 16, 1) RETURN 1 END --Report error if the<H@@@@P 4-.v03aCREATE SERVICE- >-0-:U>0' UExternalMailServiceSQ : TJ>-$-:4>&4ExternalMailService : U}>#r>-@aJ-JS)4 J T>-cJ-JS)4 J iI:>-aJ-JFw7 J 80>-c1J-Js7l J 9MJs- >-@ gkK- KrA K X>- iiK- KJ K Ё0--tXhXtrA2 " Dp_xtenalailueu> c-X(53S)4-X   53>-X a@-X J (53rA2 J  >-XcJ-X JRCrA2(53 @ J 绎qu>-X"-X "des0,53ITrA2 dqueue_messages_843150049 " ͚CL>-X)"+@ ">er&53>queue_messa@es_843150049ag " }na>-X","> -&53>queue_messages_843150049pr " ? S>-Xz"-X" _trA253me " yal-X  rA2-X  rA2>-X"-X" r a d c53 " ͚he@-X  rA2>-X))r)Asm0-5300Astatus  ) ,n; >-X)*)se653statusLE ) cϔdl-X  rA2>-X)-X)E 0-5300Epriority@sag ) |w.>-X3)*`)"_t653"priority  ) akpe-X  rA2>-X)-X)O 0-53Oqueuing_ordere ) ght>-X_)-X),ml653,queuing_order ) :H> -X  rA2 -X 53ess-X! 53>-X")-X)00OQ53  ) g-0OQj:1Pro-X#  rA2>-X$)-X#)_XE0-53$$_conversation_group_id  @@@@@P&  -*> c- (6'703S*CreatProc transaction-  6>-"-"bQ0,6P SS bsp_maintplan_delete_log " e *>- ","<@M&6<sp_maintplan_delete_log " ]O>- ","<e&6<sp_maintplan_delete_log " I>-z"-" 6 " Ƈ 03aSoSplitPagemi>- <-Xr@@@- <P- <>- <- %0|6@ 8CREATE PROCEDURE sp_write_sysjobstep_log @job_id UNIQUEIDENTIFIER, @step_id INT, @log_text NVARCHAR(MAX), @append_to_last INT = 0 AS BEGIN DECLARE @step_uid UNIQUEIDENTIFIER DECLARE @log_already_exists int SET @log_already_exists @ 0 SET @step_uid = ( SELECT step_uid FROM msdb.dbo.sysjobsteps WHERE (job_id = @job_id) AND (step_id = @step_id) ) IF(EXISTS(SELECT * FROM msdb.dbo.sysjobstepslogs WHERE step_uid = @step_uid )) BEGIN SET @log_already_exists = 1 END --Need create log if "overwrite is selected or log does not exists. IF (@append_to_last = 0) OR (@log_already_exists = 0) BEGIN -- flag is overwrite --if ovrerwrite and log exists, d@lete it IF (@append_to_last = 0 AND @log_already_exists = 1) BEGIN -- remove pervious logs entires EXEC sp_delete_jobsteplog @job_id, NULL, @step_id, NULL END INSERT INTO msdb.dbo.sysjobstepslogs ( log, log_size, step_uid ) VALUES ( @log_text, DATALENGTH(@log_text), @step_uid ) END ELSE BEGIN DECLARE @log_id INT --Selecting TOP is@just a safety net - there is only one log entry row per step. SET @log_id = ( SELECT TOP 1 log_id FROM msdb.dbo.sysjobstepslogs WHERE (step_uid = @step_uid) ORDER BY log_id DESC ) UPDATE msdb.dbo.sysjobstepslogs SET log .WRITE(@log_text,NULL,0), log_size = DATALENGTH(log) + DATALENGTH(@log_text) , date_modified = getdate() WHERE log_id = @log_id END RETURN(@@error) -- 0 means success END 0(2;7 %8((0)@ <-  <)`)>- <- Ը>-<)v>-+6<,H<|60-S->-<-<06@ 8CREATE PROCEDURE sp_maintplan_de@ete_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 all logs older than X da@e --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.sy@maintplan_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 4 < A">-@))E0-6$$E@plan_idXf ) W|=>-),h)"m66"@plan_id  ) I#Ӌ>-)-)K0-6$$K@subplan_idS ) /e>-8),h)(@6(@subplan_id ) r4e>-)-)M 0-6==M@oldest_time ) ܴ>-),$)*k66*@oldest_time ) ,f >-"-"6 " e *>-@ K,K_h6j8 K zX[>-/K,Kj86 K zk* )>- K-K_6 5 K H`>-/K-K 56- K rT,>- K-K@T,6 5 K f)>-0K-K 56 K -R/ >- K-K6 5 K ϱ>- 0K-K 56& K [>-! K- K6@ 5 K è >-"0K-!Kle 56 K o>-# K-"K6 5 K ->-$0K-#K1' 56 K Z0-S-EI)(8HXh|@ x D @  @`Hhagment_bitmap  ) ) >-Ch)-A)0at650fragment_bitmap ) CPu -D  S)4>-ET)-C)[ 0-5@[binary_message_body  ) Ntn >-F1)-))X6)stl) e=P,  -y> c-('77L703*CreatProc transaction-  '7>-!"-"jm0,'7P  jsp_maintplan_delete_subplan " ki>- "-"@D&'7Dsp_maintplan_delete_subplan " H.>- "-"D&'7Dsp_maintplan_delete_subplan " 4/E>-z"-" s'7 " ʑ0>-<- <0'7@ 8CREATE PROCEDURE sp_maintplan_de@ete_subplan @subplan_id UNIQUEIDENTIFIER AS BEGIN DECLARE @retval INT DECLARE @job UNIQUEIDENTIFIER DECLARE @schedule INT 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 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 BEGIN TRAN --Is there an Agent Job/Schedule associated with this subplan? SELECT @job = 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 msdb.dbo.sysmaintplan_subplans WHERE (subplan_id = @subplan_i@) --delete the job associated with this subplan IF (@job IS NOT NULL) BEGIN --Delete Job EXEC @retval = msdb.dbo.sp_delete_job @job_id = @job, @delete_unused_schedule = 1 IF (@retval <> 0) BEGIN ROLLBACK TRAN RETURN @retval END END COMMIT TRAN RETURN (0) END m < d >- )-)KUN0-'7$$K@subpl@an_idn ) R+,OR>- 9)-)(DE6'7(@subplan_id ) H(7 >- !"-"  @C'7 " k >-  K-$Klt'7&m1 K %!(? >- !K-%Ke &m1'7th K@ %7N >-  K- K s'7&m1 K )ȶJtr>-"K- K &m1'7r  K ) M @>- K-K '76 K  >-6K-KNE6'7  K _OB>-@ K-Kco'7&m1 K $FR >-!K-K &m1'7ue K ${),>- K-Kec'7A K I:LL>-yK-KN A'714 K ºTU0--al@Xh x  $ x x hhsysmail_start_sp changes the receive status of the SSB queue IF NOT EXISTS (SELECT * FROM sys.service_queues WHERE name = N'ExternalMailQueue' AND is_receive_enabled = 1) BEGIN RAISERROR(14641, 16, 1) RETURN 1 END -- Get the relevant profile_id -- IF (@profile_name IS NULL) BEGIN -- Use the global or users default if profile name is not supplied SELECT TOP (1) @profile_id = pp.profile_id @ FROM msdb.dbo.sysmail_principalprofile as pp WHERE (pp.is_default = 1) AND (dbo.get_principal_id(pp.principal_sid) = @database_user_id OR pp.principal_sid = 0x00) ORDER BY dbo.get_principal_id(pp.principal_sid) DESC --Was a profile found IF(@profile_id IS NULL) BEGIN RAISERROR(14636, 16, 1) RETURN 1 END END ELSE BEGIN --Get primary account if profile name is supplied EXEC @rc = m@db.dbo.sysmail_verify_profile_sp @profile_id = NULL, @profile_name = @profile_name, @allow_both_nulls = 0, @allow_id_name_mismatch = 0, @profileid = @profile_id OUTPUT IF (@rc <> 0) RETURN @rc --Make sure this user has access to the specified profile. --sysadmins can send on any profiles IF ( @is_sysadmin <> 1) BEGIN --Not a sysa@min so check users access to profile iF NOT EXISTS(SELECT * FROM msdb.dbo.sysmail_principalprofile WHERE ((profile_id = @profile_id) AND (dbo.get_principal_id(principal_sid) = @database_user_id OR principal_sid = 0x00))) BEGIN RAISERROR(14607, -1, -1, 'profile') RETURN 1 END END END --Attach results must be specified IF @attach@query_result_as_file IS NULL BEGIN RAISERROR(14618, 16, 1, 'attach_query_result_as_file') RETURN 2 END --No output must be specified IF @exclude_query_output IS NULL BEGIN RAISERROR(14618, 16, 1, 'exclude_query_output') RETURN 3 END --No header must be specified IF @query_result_header IS NULL BEGIN RAISERROR(14618, 16, 1, 'query_result_header') RETURN 4 END -- Check if query_result_separator is spe@ifed IF @query_result_separator IS NULL OR DATALENGTH(@query_result_separator) = 0 BEGIN RAISERROR(14618, 16, 1, 'query_result_separator') RETURN 5 END --Echo error must be specified IF @append_query_error IS NULL BEGIN RAISERROR(14618, 16, 1, 'append_query_error') RETURN 6 END --@body_format can be TEXT (default) or HTML IF (@body_format IS NULL) BEGIN SET @body_format = 'TEXT' END ELSE BEGIN @ SET @body_format = UPPER(@body_format) IF @body_format NOT IN ('TEXT', 'HTML') BEGIN RAISERROR(14626, 16, 1, @body_format) RETURN 13 END END --Importance must be specified IF @importance IS NULL BEGIN RAISERROR(14618, 16, 1, 'importance') RETURN 15 END SET @importance = UPPER(@importance) --Importance must be one of the predefined values IF @importance NOT IN ('LOW', 'NORMAL', 'HIGH') BEGINH RAISERROR(14622, 16, 1, @importance) RETURN 16 END --Sensitivity must be specified IF @sensitivity IS NULL BEGIN RAISERROR(14618, 16, 1, 'sensitivity') RETURN 17 END SET @sensitivity = UPPER(@sensitivity) --Sensitivity must be one of predefined values IF @sensitivity NOT IN ('NORMAL', 'PERSONAL', 'PRIVATE', 'CONFIDENTIAL') BEGIN RAISERROR(14623, 16, 1, @sensitivity) RETURN 18 END -@@@@@@@d-lPV  -|G@> c-(7L7pp803*CreatProc transaction-  7L7>-%"- "hQ0,7L7P  hsp_maintplan_open_logentry " 7g8)M>- "-"@&7L7Bsp_maintplan_open_logentry " cѐT>- "-"B&7L7Bsp_maintplan_open_logentry " cMi>-z"-"  7L7> " 8ef>-<-<J07L7@ 8CREATE PROCEDURE sp_maintplan_open_l@gentry @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, plan_id, subplan_id, start_time) VALUES(@task_detail_id, @plan_id, @subplan_id, @start_time) RETURN (@@ERROR) END  < 9j>-)- )E0-7L7$$E@plan_id ) 9Es>- )-)"e67L7"@plan_id  ) I#>>- )- )K0-7L7$$@K@subplan_id  ) :v>- :)- )(q67L7(@subplan_id ) ۈ >- )- )K0-7L7==K@start_time  ) ;zt>- )- )(67L7(@start_time ) he@>-)- )S0-7L7$$S@task_detail_id ) <w) >-d)-)067L70@task_detail_id ) H( >-)-)7L7 ) <w) >-%"-"@ )7L7 " 7g8)>- K-K7L7 5 K E*ki>-7K-K 57L7 K E(>- K-K 7L7 5 K DS_>-6K-Kg 57L7) K@ Dzb>- K-K7L7 5 K C4L>-5K-KQ 57L7  K C.-0>- K-K 7L7 5 K B^>-4K-K 57L7r K Bp0-@-IFx   , D x Dltdh53<conversation_group_id ) W Lo-X&  rA2>-X')-X%)[ F0-53$$[conversation_handleo ) ums>-X(t)-X&)8ge6538conversation_@andle ) /fN` s-X)  rA2>-X*)-X()cm_0-53cmessage_sequence_numberi ) U >-X+b)*`)@ 653@message_sequence_number ) [% (-X,  rA2>-X-)-@+)I 0-53$$Imessage_idAcc ) !0s|KtA>-X._)-X,)&Da653&message_id86 ) )Ca-X/  rA2>-X0 )-X.)Sai0-5388 Smessage_type_idx ) "fcc >-X1@g)-X/)0g 6530message_type_id ) gxiqu-X2  rA2>-X3!)-X1)I_h0-53 88 Iservice_id.sy ) #@e>-X4B)*()&SE653 &service_idse ) 6(P-X5  rA2>@X6")-X4)[2,0-53 88 [service_contract_idt ) $50>-X7>)-X5)8 653 8service_contract_id ) 6gag-X8  rA2>-X9#)-X7)I 0-53 Ivalida@tionacc ) %̪D >-X:o)-X)& 653 &validatione  ) Cex_et-X;  rA2>-X<$)-X:)Otu0-53 88 Onext_fragmentt ) &1} >-X=s%))),ai653 ,next_fragment )@ Ls -X>  rA2>-X?%)-X=)O@l0-53 88 Ofragment_sizea ) 'T$am>-X@j)*),en653 ,fragment_size ) :5 -XA  rA2>-XB&)-X@)S_s0-53HSfragment_bitmapi ) (-XCg)-XA)0--6530fragment_bitmap ) ame-XD  rA2>-XE')-XC)[me0-53@[binary_message_bodyE ) )[Ȏ N>-XF0)-X@@@@@@@@oBP ->> c-(pp8903{*CreatProc transaction-  pp8>-)"-"jQ0,pp8P {{ jsp_maintplan_close_logentry" " pӎ >- "-"@D&pp8Dsp_maintplan_close_logentry " :h>- "-"Ds&pp8Dsp_maintplan_close_logentry " ;t>-z"-" pp8 " ql>-<-<z0pp8@ z8CREATE PROCEDURE sp_maintplan_cl@se_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 VARCHAR(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 at < ri s>-))-)Sal0-pp8$$S@task_detail_ida ) @bdit>- e)-)0N 6pp80@task_detail_id ) ?Pte>- *)- )G m0-pp8==G@end_time, ) sv >- r),H")$@l6pp8$@end_time ) Lh >- +)- )@Ife0-pp800I@succeededECT ) tqb.>- N)- )& B6pp8&@succeeded.s ) SET>-)"-"TH(og)pp8 " pӎ >-(K!kK pp8 5 K {VZs2;>-@5K-K 5pp8 K {k/)>-(K-Kpp8 5 K bp>-<K-K< 5pp8 K Ɵ]0>-(K-Kpp8 5 K b>-<K-KH  5pp8UN K *LL0-{-TI 8 H X h p @ Tx hhLL 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 all logs older tr=oP>&0-e> c-(9:03*CreatProc transaction-  9>--"-"bm0,9P  bsp_maintplan_update_logp " &' >- "-"<@&9<sp_maintplan_update_log "  ">- "-"<&9<sp_maintplan_update_log " nn>-z"-" 9 " $>-< X <r09@ r8CREATE PROCEDURE sp_maintplan_update_log --Updates @he 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, --Required @succeeded TINYINT, --Required @start_time DATETIME, --Required @end_t@me 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(@Line4)) 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  < ǣ>-7)- )S0-9$$S@task_detail_id ) ӯQ>- g)-)0690@task_detail_id ) H9!>- 8)- )A0-94A@Line1@  ) |C>- e)*p )m69@Line1ȶ ) S6b>- 9)- )Ar 0-94A@Line2 ) v>- f)- )69@Line2 ) NE>-:)- )@0-94A@Line3 ) #qfF>-g)-)69@Line3K ) . >-;)-)A'0-94A@Line4 ) D>-h)-)069@Line4 ) @7*h>-<)-)Ave0-94A@Line5rvi ) Dx N>-i)-)SE69@Line5UR ) | G>-=)-)M 0-94M@server_namepli ) !t (>-w)@h<)*lp69*@server_name = ) Vdb>->)-)Ial0-900I@succeededC  ) w,il>-O)- )&IS69&@succeeded 1 ) p >-?)-)Ksu0-9 ==@K@start_time  )  >-)-)(lo69 (@start_time ) Jssm>-@)-)G 0-9 ==G@end_timeu ) Tsp>-s)- )$ 69 $@end_time ) nAa >@A)-)OEL0-9 88 O@error_number  ) 3> (>-z)-),et69 ,@error_number ) s-B)-)Qro0-9 4Q@error_messagetta ) ţci>-@z)-).AI69 .@error_messageil ) i >- C)-)Eut0-9 4E@commandtpu ) Ely >-!m),h:)"r 69 "@commandOR ) 4e{re>-"-"-"epaato9@ " &'es>-#(K-KBE9j8  K k$_se>-$@K-Kiej8 9qu K k X B>-%(K-$KUR9j8  K jA\fa>-&@K-%Kdyj8 9  K jd4EG>-@'(K-&Kor9j8  K i4 >-(@K-'KNDj8 9-I K i@if>-)(K-(K, 9j8  K ḧy S>-*@K-)K tj8 9es K h%OT>-+(K-@*K1,9j8  K gsc=kSe>-,@K-+K j8 98, K gtc >--(K-,K) 9j8 K fue>-.@K--KDEj89  K f/7, >-/(K-.K@9j8 K e@ry>-0@K-/Kuej89le K ejEND>-1(K-0K <9j8 K d%s^3qu>-2@K-1Ktaj89  K d/IS>-3(K-2KR(9j8 @K c!su>-4@K-3K Nj89t) K c.su>-5(K-4Kt 9j8 K bW (>-6@K-5Kopj89LL K bb2 >-7(K-6K 9j8 K a_r>-@@K-7K j89 K aF>-9(K-8K9j8 K `r<>-:@K-9Kj89 K `z)>-;(K-:K<9j8 K _Kd_>-<@K-@K14j89pi K _, 0--FID H&%X%$h$#x##""!$! 4 DTdt$|8xHh,d @  x 4 `Xh 0) AND @attach_query_result_as_file = 1) BEGIN RAISERROR(14625, 16, 1) RETURN 21 END -- -- Execute Query if query is specified IF ((@query IS NOT NULL) AND (LEN(@query) > 0)) BEGIN EXECUTE AS CALLER @ EXEC @rc = sp_RunMailQuery @query = @query, @attach_results = @attach_query_result_as_file, @query_attachment_filename = @query_attachment_filename, @no_output = @exclude_query_output, @query_result_header = @query_result_header, @separator = @query_result_separator, @echo_error = @append_query_error, @ @dbuse = @execute_query_database, @width = @query_result_width, @temp_table_uid = @temp_table_uid, @query_no_truncate = @query_no_truncate -- This error indicates that query results size was over the configured MaxFileSize. -- Note, an error has already beed raised in this case IF(@rc = 101) GOTO ErrorHandler; REVERT -- Always check th@ transfer tables for data. They may also contain error messages -- Only one of the tables receives data in the call to sp_RunMailQuery IF(@attach_query_result_as_file = 1) BEGIN IF EXISTS(SELECT * FROM sysmail_attachments_transfer WHERE uid = @temp_table_uid) SET @AttachmentsExist = 1 END ELSE BEGIN IF EXISTS(SELECT * FROM sysmail_query_transfer WHERE uid = @temp_table_uid AND uid IS NOT NULL) HET @QueryResultsExist = 1 END -- Exit if there was an error and caller doesn't want the error appended to the mail IF (@rc <> 0 AND @append_query_error = 0) BEGIN --Error msg with be in either the attachment table or the query table --depending on the setting of @attach_query_result_as_file IF(@attach_query_result_as_file = 1) BEGIN --Copy query results from the attachments@@@@;8-,A itP) 00-|nm> c-(:;0 3?*CreatProc transaction-   :>- 1"-#"jQ0,:P ?? jsp_maintplan_update_subplan  " ӽx>>-  "-"@D&:Dsp_maintplan_update_subplan " I>>-  "-"D&:Dsp_maintplan_update_subplan " >>- z"-" :  " _Â>>- < < 0:@ 8CREATE PROCEDURE sp_maintplan_up@ate_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 AS BEGIN SET NOCOUNT ON SELECT @name = LTRIM(RTRIM(@name)) SELECT @description = LTRIM(RTRIM(@description)) --Are we creating a new entry or updating a@ 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_name, job_id, schedule_id) VALUES( @subplan_id, @ @plan_id, @description, @name, @job_id, @schedule_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_subplan_description NVARCHAR(512) DECLARE @s_job_id UNIQUEIDENTIFIER DECLARE @s_schedule_id INT SELECT @s_subplan_name = subplan_name, @s_subplan_description = subplan_description, @s_job_id = job_id, @s_s@hedule_id = schedule_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 (@description IS NOT NULL) SELECT @s_subplan_description = @description IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id IF (@schedule_id IS NOT NULL) SELECT @s_schedule_id = @schedule_id @ --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @s_subplan_description, job_id = @s_job_id, schedule_id = @s_schedule_id WHERE (subplan_id = @subplan_id) END RETURN (@@ERROR) END   < AI>>-  ))])K0-:$$K@sub@plan_id ) _c>-  =)-)(e6:(@subplan_id ) ,p>-   )- )E0-:$$E@plan_id ) qr>-  )- )"6:"@plan_id ) fKX>-   )@ )? s0-:4?@name ) V>-  ?),h>)6:@name ) z=i>-  )- )M0-:4M@descriptionu ) 5T >- C)- )*6:@@description ) 7o>-  )-)C 0-:$$C@job_id ) P=>- )-) 6: @job_id ) Ubە>- )-)M0-:88 M@schedule_id ) @!g>- K)-)*e6:*@schedule_id ) .E >- )-)O0-:hhO@allow_create_ ) F4F >- mK)-"),6:,@allow_create ) f>- 1"-@"": " ӽx>- (K-<K_:&m1 K 1>>- #K-=K5&m1:r K %c>- (K-K:&m1 K 8bc)>- %K-KI&m1@:n K >$>- (K-K:&m1 K fq)>- %K-K&m1: K #>- (K-Kt:&m1 K k>- $K-K &m1:_ K )@>- (K-K:&m1 K ȼT>-  $K-Kt&m1:) K .Sz>-! (K- K :&m1 K ߯ >-" $K-!K&m1: K A>-# (@-"K_bit:&m1  K 1>-$ (K-$Kfa:&m1p K 8bcme>-% (K-%K:&m1 K fq>-& (K-&KyE :&m1> K ȼT>-' (@-'K_e:&m1  K ߯>0- ?-TI` ``l| 0@DX4|X(|x hh  p>-XI*>) %pX0d0p e_t   > N*!> P-XK@> R-XL> S-XM> U-XN> X-XO> \-XP> `-XQ> d-XR> e-XS@> j-XT> k-XU> l-XV> n-XW> o-XX> q-XY> s-XZ> u-X[@> y-X\6 ,>-XJ-X]*>'p53  ><-XB>-X_a*I Ep   K>@Xa*6p  :R><-X`>-Xbb-XaI Ep   b>-Xd-Xbp  {H>-Xey@C *2 -)p 0l  >-Xf*3%"pUF  >-XgyD -Xf -)p $   3] >-Xh-Xg%"p> @ a>-XiyE -Xh -K)p $  V:]>-Xj-Xi%>"p  ex>-XkyF -Xj -)p %")(  a$>-Xl-Xk%H"pe_  V:]j>-XmyG -Xl -t)p 0-  exl>-Xn-Xm%t"p  3] c>-XoyH -Xn -)p ._b  d@@@@@@@KK*- c ndP` 0-0}> c-(;T<0 3*CreatProc transaction-0   ;>-0 5"-"dQ0,;P  dsp_maintplan_delete_plan " \ >-0  "-">@&;>sp_maintplan_delete_plano " >-0  "-">&;>sp_maintplan_delete_plan_ " t">-0 z"-" ; " b">-0 <-<0;@ 8CREATE PROCEDURE sp_maintplan_delete_plan @@lan_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 RN( < OLE >-0 #)-)E@s0-;$$E@plan_id (@ ) oU<>-0  )- )"6;"@plan_id ) ay~>-0  5"-0"@; " \>-0  (IK-(Kd;&m1 K E e>-0  'K-#K&m1; K E=X~,>-0  (IK-0 K;&m1 K B;_>-0 $K-0 K&m1;@ K BJ>-0 (KK-0K);'7 K +>-0 GK-0Ke'7;  K |l"0-0 -0RE  ( 8Dh\hpӎ >-(K!kK pp8 5 K {VZs2;>-@5K-K 5pp8 K {k/)>-(K-Kpp8 5 K bp>-<K-K< 5pp8 K Ɵ]0>-(K-Kpp8 5 K b>-<K-KH  5pp8UN K *LL0-{-TI 8 H X h p @ Tx hhLL 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 all logs older tH@ c-0(T<%=0 3*CreatProc transaction-8   T<>-8 "*"Xm0,T<P  Xsp_maintplan_start " T$>-8  "-0"2&T@<2sp_maintplan_start_ " Q. >-8  "-0"2"&T<2sp_maintplan_startp " <l>-8 z"-0" T< " U -0 3aSplitPage<6-8 <,[ P>-8   <- @ >-8   <-8 ARHAR@2566-8   <,x [ @-8  <6c,#[P-8  <01eq>-8 <-8+t_0~ < +8(getdate())d<-8@  0<)->-8 0<-81LL @>-8 1< 0 OC>-8 +;<-<TR~ <0-8 -8@L0 3aRTSplitPage ISER>-8  <-8  @ l@ne1@-8 <P-8 <0ro>-8 0<-8 UE>-8 <-80in >-8 +;<-8<imT<0-8 -8a, >-8 <-8@< 0T<@ 8CREATE PROCEDURE sp_maintplan_start @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) AND (@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 @jobid END CLOSE spj DEALLOCATE spj END RETURN (@retval) END  < V=>-8 ()-0 )E 0-T<$$E@plan_id ) V>-8 )-0 )")6T<"@plan_id ) @>-8  ))-8)K =0-T<$$K@subplan_id ) W->-8! >)- )( 6T<(@subplan_id ) 9.*>-8" "-8" )T< " T$>-8# (^K-0K==T<@&m1 K t>-8$ +K-0K&m1T< K >-8% (^K-8$KT<&m1 K {hf >-8& %K-8%Ku&m1T<T K {г>-8' (`K-8&K@T<4wK K @}Џ>-8( K-8'K 4wKT< K Sm* `e>-8) (_K-8(KT<&m1 K ~1Q>-8* *K-8)K&m1T< K ~I )0-8 -8TIl|(< D Hh40,x(DDh@z)-).AI69 .@error_messageil ) i >- C)-)Eut0-9 4E@commandtpu ) Ely >-!m),h:)"r 69 "@commandOR ) 4e{re>-"-"-"epaato9@ " &'es>-#(K-KBE9j8  K k$_se>-$@K-Kiej8 9qu K k X B>-%(K-$KUR9j8  K jA\fa>-&@K-%Kdyj8 9  K jd4EG>-@'(K-&Kor9j8  K i4 >-(@K-'KNDj8 9-I K i@if>-)(K-(K, 9j8  K ḧy S>-*@K-)K tj8 9es K h%OT>-+(K-H*K1,9j8  K gsc=kSe>-,@K-+K j8 98, K gtc >--(K-,K) 9j8 K fue>-.@K--KDEj89  K f/7, >-/(K-.K@@@@S P  -H] W> c-8(%=I>03g*CreatProc transaction-H  %=>-H"-8#"NQ0,%=P gg Nsp_get_scriptu " d{ha>-HM","(&%=(s@_get_script " ˜a>-HR"-"(&%=(sp_get_script " q'>-Hz"-8" %=> " f>-H<)<0%=@ 8CREATE PROCEDURE sp_get_script @name sysname AS BEGIN exec master.dbo.xp_get_script @name END  <@ B:R >-H.)-8!)?FI0-%=4?@name  ) s%HA>-H B)-) 6%=@name ) al>-H "-H" SLEC%= " d{h 0-Hg-H ,$0h new entry or updating a@ 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_name, job_id, schedule_id) VALUES( @subplan_id, @ @plan_id, @description, @name, @job_id, @schedule_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_subplan_description NVARCHAR(512) DECLARE @s_job_id UNIQUEIDENTIFIER DECLARE @s_schedule_id INT SELECT @s_subplan_name = subplan_name, @s_subplan_description = subplan_description, @s_job_id = job_id, @s_s@hedule_id = schedule_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 (@description IS NOT NULL) SELECT @s_subplan_description = @description IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id IF (@schedule_id IS NOT NULL) SELECT @s_schedule_id = @schedule_id H --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @s_subplan_description, job_id = @s_job_id, schedule_id = @s_schedule_id WHERE (subplan_id = @subplan_id) END RETURN (@@ERROR) END   < AI>>-  ))])K0-:$$K@@@@@pPIP-P> c-H(I>m?03aCREATE TABLEn-P  I>>-P "-H "R"0,I> U  Rsysdbmaintplansi " t>-P ",x",&I>,sysdbmain@plans " \ap>-P",x",&I>,sysdbmaintplans " \+8>-Pz"-H" tI> " (>-P "-P" ">I> " >-P4)-H )CEA0-I>$$@Cplan_idI ) NO>-P ))-)  6I> plan_id ) Z"Ons>-P 5)-P )G F0-I>4Gplan_nameO ) "8 s>-P *)-P )$BE6I>$plan_name ) su>-P 6)@P )M N0-I>==Mdate_created(@r ) GÄQ<>-P )*`)*6I>*date_created ) 54E>-P7)-P )?0-I>4?owner ) S)>-P)-P )@I>owner ) ꏎ_>-P8)-P)U0-I>88 Umax_history_rows' ) t>-PN)-2)26I>2max_history_rows ) WLz*m>-P9)-P)_0-I>4_re@mote_history_server ) u3Zf>-P|)-P)<6I><remote_history_server ) sζe>-P:)-P)c0-I>88 cmax_remote_history_rows ) T>-PO)-P)@>6I>@max@remote_history_rows ) ds>-P;)-P)Q0-I>88 Quser_defined_1 ) FD<>-Ph)-;).6I>.user_defined_1 ) sˤ>-P<)-P)Q0-I> 4Q@user_defined_2UN ) ##9>LL>-Pi)-P). 6I> .user_defined_2@p ) D* m>-P=)-P)QUL0-I> ==Quser_defined_3_id ) ͌, >-Pj)-P). 6I> .user_defined_3ld )@ ce>-P>)-P)Q 40-I> $$Quser_defined_4ts  ) 0 a>-Pk)-P).ll6I> .user_defined_4  ) +: >-P "-P"@ol estI> "  > c-P(@m?8@-P  m?>-P! "-P"n 0,m?PKI> nPK__sysdbmaintplans__3F9B6DFF)  " bdn_>-P"?"-"H @&m?HPK__sysdbmaintplans__3F9B6DFF " |g )>-P#?"-"H&m?@PK__sysdbmaintplans__3F9B6DFF " |>-P$z"-P" I>m? " <-P%  t> N-> P-P'> R-P(> S-P)> @U-P*> X-P+> \-P,> `-P-> d-P.> e-P/> j-P0> k-P1> @l-P2> n-P3> o-P4> q-P5> s-P6> u-P7> y-P86 -8>-P&@-P9)%t @t   _i}>-P;-* 'tI>  _i}><->-P<i-IEt   >-P>@-t  R,c>-P?ym - -)t $  RT>-P@-%"t  RT>-PAyn -P@ -()t 4@ @ Ig>-PB-PA%"t  I>-PCyo -PB -)t =  ,]T>-PD-PC%"tod  ,]TN>-PEyp -PD -st)t@ 4g  >-PF-PE%"t  >-PGyq -PF -)t 8   6q-->-PH-PG%"t  6q>-PIyr@-PH -)t 4  jc>-PJ-PI%"t   jc>>-PKys -PJ -)t 8 >  { ?>-PL-PK%"t @ { ?r>-PMyt -PL -)t8 $  -\>-PN-PM%"t   -\)>-POyu -PN ->)t 4   Hz;">-PP-PO%@"t    Hz;)>-PQyv -PP ->)t =(   U)">-PR-PQ%"t    U))>-PSyw -PR ->)t $0   ò">-PT@-PS%"t    ò)$-PUta>-PV6-6i0'I> t iPK__sysdbmaintplans__3F9B6DFF 6 X3U>-PW]6-6J6I>JPK__sysdbmaintplans__3F9B6DFF 6@ Aw2>-PXq7-7I>] 7 O>-PY.<-<" 0 " < E >-PZ "-P""$I> " $-P[te>-P\-P; tI>t@  _i}-P]  m?-P^  I>-P_  I>>-P`6-PW6   8+ I> 6 X3U -Pa  I>>-Pb "-P[" m? " bd> c-P (8@qA-Pc@  8@>-Pe"-Pc"p0,8@D I> pDF__sysdbmain__date___408F9238 " 8'Yt >-Pfv!"+8"J &8@JDF__sysdbmain__date___408F9238 " ϊr>-Pgx!"+8"J&8@JDF__sysdbma@n__date___408F9238 "  >-Phz"-P%" I>8@ " *dr>-Pi6)-P)%8@I> ) GÄQ-Pj  I>>-Pk"-Pf" 8@ " 8'Yt-Pl  I>0@dSplitPage >-Pn <-P: @ @-Po<P-Pp<56>>-Pq5<!6r>-Pr6<)a5>-Ps+B<-8<@8@0-Pn-Pna>-Pm<-Pq<+08@ +8(getdate()) < 99w> c-Pd(qAwB-Pv  qA>-Px"-Pl"p0,qAD I> pDF__sysdbmain__owner__4183@671 " q6ߞ>-Pyv""-Pg"J&qAJDF__sysdbmain__owner__4183B671 " :\!V>-Pzx""-Ph"J&qAJDF__sysdbmain__owner__4183B671u " :%^x>-P{z"-Pi" I>qA " 8 f>-P|@7)-Pj)%qAI> ) S-P}  I>>-P~"-Py" qA " q6ߞ-P  I>>-P6<-Ps<C70qA C8(isnull(nt_client(),suser_sname()))  < r> c-Pw(@wBkC-P  wB>-P"-P"p0,wBD I> pDF__sysdbmain__max_h__4277DAAA " ߄>-Pv""-Pz"J>&wBJDF__sysdbmain__max_h__4277DAAA " )lݧ >-Px""-P{"J&@BJDF__sysdbmain__max_h__4277DAAA " )fx>-Pz"-P|" I>wB " ql?s>-P8)-P})%wBI> ) t-P  I>>-P"-P" wB " ߄-P  I>@>-P6<-P<%0wB %8((0))+ < 9ݶ> c-P(kC#`D-P  kC>-P"-P"p0,kCD I> pDF__sysdbmain__remot__436BFEE3 " 2>-Pv$"-P"@J &kCJDF__sysdbmain__remot__436BFEE3 " Bԫ>-Px$"-P"J&kCJDF__sysdbmain__remot__436BFEE3 " B6 >-Pz"-P" I>kC " w>-P9)-P)%kCI>  ) @u3Zf)-P  I>>-P"-P" kC " 2-P  I>>-P6<-P<$0kC $8('') < => c-P(#`DUGTE-P  #`D>-P!"-P"@0,#`DD I> pDF__sysdbmain__max_r__4460231C " S3>-Pv#"-P"J&#`DJDF__sysdbmain__max_r__4460231Ca " ^m>-Px#"-P"J&#`DJDF__sysdbmain__max_r__4460231C  " %xc>>-P@"-P" I>#`D: " hmQd>-P:)-P)%#`DI>7 ) T-P  I>>-P!"-P" #`D " S3-P  I>>-P4<)K<%0#`D %8((0))c @< (i0-P-P1HGdGFFTFE>>>=h=@=<\<;;4: :9988\87x76 6P5(54P443l33224211L1$10@0/..--4- -,p,H, ,+++* *`)(p('X'&@&%(%$$#"p"!X! @ (hDlh(h(h(h(h(T4 P |8 @ @ 4X0$h(<-z<"0<5 "> < [@`>-"-{"$ K5 " R>V$-se>-- s5s  ool`0--d KJtJJIIHHGGFE(EE|DCdCBLBA4A@@??t>=P==x<;;H;$;:0:909808766<65D54,43321t10\0/D/.,.--,+l+*T*)<)($(' '&%l%$d$#l#"H"!p! L @d@(th@<h$t<|<h< h d <  X 0 $L\\(,hcYI  K ,A>+IK+HKcYI K +2>+JZK+IKcYI  K + j>+KK+JKHcYI  K *WO%>>+LK+LK%cYI K )B7>+MWK+KKcYI  K )<@7>>+NK+MK%cYI K (%F>+OVK+NKH@@zpwB3i H_6-tP>P-x' Z03 INSERT<03*Allocate Rootrn03TFirstPage Alloc>-x -Po`>-x c-x >p P-x  Z@p@-xt>-x -x.na(-x-x   0-x-xa"@-x t`-x i-P>t'p"s`-x i-x@tp"sP-x@`-xi-x0%sta!p"s0-x-xP04t4Xhd<01eq>-8 <-8+t_0~ < +8(getdate())d<-8@  0<)->-8 0<-81LL @>-8 1< 0 OC>-8 +;<-<TR~ <0-8 -8@L0 3aRTSplitPage ISER>-8  <-8  @ l@ne1@-8 <P-8 <0ro>-8 0<-8 UE>-8 <-80in >-8 +;<-8<imT<0-8 -8a, >-8 <-8@< 0T<@ 8CREATE PROCEDURE sp_maintplan_start @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) AND (@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 H 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 = @@@@@@ P4->-x-xt|=p@0aWaaHzs jnAll ad-hoc planssa! I> D>0-x-xNQ0,%=P gg Nsp_get_scriptu " d{ha>-HM","(&%=(s@_get_script " ˜a>-HR"-"(&%=(sp_get_script " q'>-Hz"-8" %=> " f>-H<)<0%=@ 8CREATE PROCEDURE sp_get_script @name sysname AS BEGIN exec master.dbo.xp_get_script @name END  <@ B:R >-H.)-8!)?FI0-%=4?@name  ) s%HA>-H B)-) 6%=@name ) al>-H "-H" SLEC%= " d{h 0-Hg-H ,$0h new entry or updating a@ 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_name, job_id, schedule_id) VALUES( @subplan_id, @ @plan_id, @description, @name, @job_id, @schedule_id) END ELSE BEGIN --Update the table DECLARE @s_subplan_name sysname DECLARE @s_subplan_description NVARCHAR(512) DECLARE @s_job_id UNIQUEIDENTIFIER DECLARE @s_schedule_id INT SELECT @s_subplan_name = subplan_name, @s_subplan_description = subplan_description, @s_job_id = job_id, @s_s@hedule_id = schedule_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 (@description IS NOT NULL) SELECT @s_subplan_description = @description IF (@job_id IS NOT NULL) SELECT @s_job_id = @job_id IF (@schedule_id IS NOT NULL) SELECT @s_schedule_id = @schedule_id H --UPDATE the record UPDATE msdb.dbo.sysmaintplan_subplans SET subplan_name = @s_subplan_name, subplan_description = @s_subplan_description, job_id = @s_job_id, schedule_id = @s_schedule_id WHERE (subplan_id = @subplan_id) END RETURN (@@ERROR) END   < AI>>-  ))])K0-:$$KH@@@@@@P> -TP> c-P(UGTEkHF03aCREATE TABLEn-  UGTE>-%"-P"Z"0,UGTE U  Zsysdbmaintplan_jobs" " Uyi܏>- "-P"4I&UGTE4sysdb@aintplan_jobs " *I>-"-P"4s&UGTE4sysdbmaintplan_jobs " *f6>-z"-P" UGTE " V{u>-%"-"  UGTE " Uyi܏>-8=))])C0-UGTE$$@Cplan_idO ) VtX>- +)-P) a6UGTE plan_id ) Ƨ>- 8>)- )A0-UGTE$$Ajob_id" ) W">- )*`)p6UGTEjob_id  ) >- @%"-"UGTE " Uyi܏a> c-(kHFǏ-)"- "pE0,kHFUQUGTE pUQ__sysdbmaintplan_j__46486B8E " 0>-""-"J&kHFJUQ__s@sdbmaintplan_j__46486B8E " 1^ڔ>-S",h"J&kHFJUQ__sysdbmaintplan_j__46486B8E " 1Fz>-z"-" UGTEkHFx " 6Yw-  u>--P])%u''$'u re@  r5y>--P<*|'uUGTEI  r5t><-P=>-j-xIEu ow  k*T>--P?u @ Uxi>-yx -PT -)u $-  9>--PU% "uh  9>-yy - -))u $<  w#>--%@s"u  w#$-ua>-'6-Pa6k@p0'UGTE u kUQ__sysdbmaintplan_j__46486B8E 6 V~l>-6-PX6L 6UGTELUQ__sysdbmaintplan_j__46486B8E 6 Z/_>- q@-PY7UGTE 7 X؝ >-!q7-!7s UGTE 7 Wamk>-"7<-PZ<"e0-#%"-"$"UGTE " Uyi܏$-$ue>-@%- uUGTEu  r5-&  kHF-'  UGTE-(  UGTE>-)'6-6   "KUGTE 6 V~l_-*  UGTE>-+)"-$" kHF " 0>@ c-(Ǐ-.-"-,"p0,Ǐ-/"-P#"J&Ǐ-0@"-P$"J&Ǐ-1z"-" UGTEǏ-3  UGTE>-4 "-/"$I> "  >-5aJ-J@lǏ J A%>-6cJ-JI>Ǐ-7aJ-6JǏ>-8cJ-7JUGTEǏ-9aJ-8JǏ@ J >-:cJ-9J I>Ǐ-<-"-5" Ǐ-P>@-t  R,c>-P?ym - -)t $  RT>-P@-%"t  RT>-PAyn -P@ -()t 4@ H Ig>-PB-PA%"t  I>-PCyo -PB -)t =  ,]T>-PD-PC%"tod  ,]TN>-PEyp -PD @@7ymPL  -3> c--(0H9$I03alCREATE TABLEn-  0H>-1"-="d0,0H U  dsysdbmaintplan_databases " ~>- "-">&0H>s@sdbmaintplan_databases " >-"-">&0H>sysdbmaintplan_databases "  >-z"-2" a0H " |kA>-1"-" 0H " ~>- ))U)@C0-0H$$Cplan_id )  hC>- ,)- ) 60H plan_id ) $Hs>-  )- )OX0-0H4Odatabase_nameq ) Q>- )-G), 60H,databas@_name ) W>- 1"-"0H " ~> c-(9$IrJ-   9$I>-5"- "p0,9$IUQ0H pUQ__sysdbmaintplan_d__4924D839 " 9.>-""-@"J&9$IJUQ__sysdbmaintplan_d__4924D839 " 8q>-S"-"J&9$IJUQ__sysdbmaintplan_d__4924D839 " 8G>-z"-" <0H9$I " :-  v>--&@)%vv 8  0p_>--*@s'v0HAS  0NT><- SE> -> -> -> @->  -> -> -> -> -> - > -!> @-"> -#6 -x >-^-$IidEv n_i  >7ON>-&-WHv  +7 >-'yz - @- I)v $   pj>-(-% "v  >-)y{ -( - )v 4  t->-*-)%"v  t- $-@va>-,46-*6k$$0'0H v kUQ__sysdbmaintplan_d__4924D839 6 e8>--6- 6L)60HLUQ__sysdbmaintplan_d__4924D839 6 7'q>-.q7-"70H 7@ b>-/q7-/70H 7 Mp>-0 <+0<"0<0H " < = Ch>-11"-"$u&m0H " ~ $-2ve>-3- v0H@v  0-4  9$I-5  0H-6  0H>-746--6   KK0H 6 e8-8  0H>-95"-2" 9$I " 9.> c-(rJ K-@  rJ>-<9"-:"pil0,rJF 0H pFK__sysdbmain__plan___4A18FC72 " rA>-="-0"J&rJJFK__sysdbmain__plan___4A18FC72@ " 7]bv)>->"-1"J&rJJFK__sysdb@ain__plan___4A18FC72 " 7R>>-?z"-"  0HrJ> " sT-@  I>-A  0H>-B "-="$URI> "  >-CaJ-:JKrJI> J 7\>-D@cJ-;JI>rJ J T1l >-EaJ-DJKrJ0H J B9>-FcJ-EJ0HrJ J JL >-GaJ-FJKrJI> J Y>-HcJ-GJHI>rJ J WԺ -I  0H>-J9"-C"  KrJ " rA0--1h@P`pD8tL$lTLh( h ( h ( h ( P 0 $hTHhK f/7, >-/(K-.Km:+eyP -]Z> c-;( KDL03a CREATE TABLE--  K03 SplitPage>- "-%gt@s@-"P-",@t>-"-(HppbNppbpdphppPVppdppLppJppbppnppbfpj0,eE U  >fCf HMSdbms_map0,kHFUQUGTE pUQ__sysdbmaintplan_j__46486B8E0,u}FD C pDF__sysmail_s__is_ou__467D75B80,FP dd @bsp_manage_jobs_by_login0, FPKeE>f?f Npk_MSdbms_map0,Ǐf?f pDF@_MSdbms_ma__src_l__47DBAE450,0HU  dsysdbmaintplan_databases0,*eHD C pDF__sysmail_s__last___4865BE2A0,TȚHP )) hsp_remove_job_from_targets0,~HD eE>f?f pDF__MSdbms_ma__src_l__48CFD27E0,9$IUQ0H@ pUQ__sysdbmaintplan_d__4924D8390,cYIU   Psysmail_server0,IP  Vsp_get_job_alerts 0,ID eE>f?f pDF__MSdbms_ma__src_p__49C3F6B70,rJF 0H pFK__sysdbmain__plan___4A18FC720,NJPKcYI@ SYSMAIL_ACCOUNT_AccountServerTypeMustBeUniquedu0,JP  dsp_convert_jobid_to_char0,JD eE>f?f pDF__MSdbms_ma__src_p__4AB81AF00,*BK@F cYI pFK__sysmail_s__accou__4B422AD50,4wKP PP Lsp_start_job0,@?KD eE >f?f pDF__MSdbms_ma__src_s__4BAC3F290,O6LF cYI pFK__sysmail_s__serve__4C364F0E0,8YkLP  Jsp_stop_job 0,bcLD eE >f?f pDF__MSdbms_ma__src_s__4CA063620,Gs*MD cYI pDF__sysmail_se__port__4D2A@3470,q}_MP  bsp_cycle_agent_errorlog 0,MD eE >f?f pDF__MSdbms_ma__src_n__4D94879B0,ND cYI pDF__sysmail_s__use_d__4E1E97800,SNP xx nsp_get_chunked_jobstep_params0,ԫND eE >f?f pDF__MSdb@s_ma__defau__4E88ABD40,OD cYI pDF__sysmail_s__enabl__4F12BBB90,GOP ښښ bsp_check_for_owned_jobs:0, |OF eE>f?f ffk_MSdbms_map_src_dbms_id0,PD cYI  pDF__sysmail_s__flags__5006DFF20,;PP <<@ jsp_check_for_owned_jobsteps<- ("-K(&>- "-  >-  "+>- ")" eEs0- ->-"-"`0, K@ U    `sysdbmaintplan_history " R<(>- "-":b& K:sysdbmaintplan_history " zy)>-"-":b& K:sysdbmaintplan_history " X:>-z"-@"  K @" P>-"-" @ K " R<()>-!)- )K0- K88 Ksequence_idl ) ; >--)-8)()6 K(sequence_id ) 3]?e - K-  @>-!)-) 00KM K ) ;_KMZ>-")-)C0- K$$Cplan_id ) <>--)- ) 6 K plan_id ) ?x>-#)-)@GK0- K4Gplan_name ) >-/)-)$6 K$plan_name ) [F>-$)-)O0- K4Odatabase_name ) GW03a SplitPageK>-@ )-@@-)P-) )>- )- ,62""$(8****6Jyt",database_name6\ 6database_user_name6Jyt 2database_version 6-")-"K >-#)-@_>-$r ),&).6Jyt.database_name0--x>-)-#),6 K,database_name ) }>-'%)-)K0- K4Kserver_name )@ l %>-(9)-)( 6 K(server_name ) qX >-)&)-()EX0- K4Eactivity ) ^7>-*)-')"6 K"activity ) j,s>>-+')-*)@G0- KhhGsucceeded ) >-,?)-P)$6 K$succeeded ) g>--()-,)E0- K==Eend_time ) >-. )-D)"u6 K"end_tim@> ) U<7>-/))-.)E0- K 88 Eduration ) ԟ=o'>-0X)-$)"6 K "duration ) dqi>-1*)-0)I0- K ==Istart_time ) :0} >-@y)-))&6 K &start_time ) m>-3<-<I>0 K  I8(dateadd(second, -[duration],[end_time])) < U'>-4+)-2)M>0- K 88 Merror_number ) _W4>-5)-@/)*6 K *error_number ) 4Nj >-6,)-5)C0- K 4Cmessage ) oX>-7`)-P) 6 K  message ) QdO.3]>-8"-" " K " R<(>-@9"-9"  K " R<(-:  w>-;-4)%w E)w   y->-<-*'w K  y- ><-4>-@_-&I Ew   ٌa>-?-'w  dӣ>-@y| -* ->)w 8    c)>-A-+%@K"w@  cP>-By} -A -)w $  JF>-C-B%""w  JF>-Dy~ -C -%)w 4%  /!j%>-E-@D%%"w  /!j">-Fy -E -)w4"  ">-G-F%"w  "">-Hy -G -)w 4"  @~>-I-H%"w  ~">-Jy -I -)w4"  Ѵ>-K-J%"w  Ѵ">-Ly -K -)w@h"  x0>-M-L%"w  x0">-Ny -M -)w ="  .kh>-O-N%"w  .kh">-Py -@O -)w 8 ! "  K>-Q-P%"w   K">-Ry -Q -)w 8 % "  nb>-S-R%"w   @ z">-Ty -S -)w 4 "  z>-U-T%"w   y1 "$-Vwa>-W66-86+' Kw  6 V1>-X~6+@6  K 6 :j>-Y"-:"$ "j K " R<($-Zwe>-[-< w Kw  y-> c-(DLiL-\  DL>-^"-Z"@0,DLUQ K pUQ__sysdbmaintplan_h__4C0144E4 " jD">-_#"-"J&DLJUQ__sysdbmaintplan_h__4C0144E4 " 8(z>-`T"-"Jm&DLJUQ__sysdbmaintplan_h__4C0144E4" " 8d>-a@"-"  KDL " `-b  x>-c-\)o%x  x   >-d-=*'x K  ><->p>-e`@-?I"Ex   |_= >-g-@x  >t>-hy -U -a)x 8   )hv>-i-V%"x@rr  )h>-jy -i -e)x   o>-k-j%"x  $-lxa-m  K>-n76-X6k>0' K x kUQ__s@ysdbmaintplan_h__4C0144E4 6 Py>-o6-.6Li6 KLUQ__sysdbmaintplan_h__4C0144E4 6 *>-pq7-07 K2 7 #rX03)SplitPage8 >-r <-@l@@-s<P-t<>-u<-u7x""""""""""""""""""""""""p0<0-w<-w>-x+<-Pt<<-q <-@<"0< K " < c >-{"-_"$ K " R<($-|xp>-}-d x Kx  -~  DL-  K-  K>-7@-o6   K K 6 Pe-  K>-"-|" 6DL " jD:> c-](iLVM-  iL>-"-"p 0,iLD K pDF__sysdbmain__pla@___4CF5691D " MGo->-v%"-P"J&iLJDF__sysdbmain__plan___4CF5691D " 4:>-x%"-P"J&iLJDF__sysdbmain__plan___4CF5691D " 4Fw>-z"-b" } KiL " G@L>-@")-7)%iL K ) <-  K>-"-" iL " MGo-N-  K>-L<)0<H0iL H8('00000000-0000-0000-0000-000000000000') < Z> c-@(VMN-  VM>-!"-"p.0,VMD K pDF__sysdbmain__plan___4DE98D56 " Vƍ^L>-v&"-"J&VMJDF__sysdbmain__plan___4DE98D56T^ " 9"X>-x&"-"@J)&VMJDF__sysdbmain__plan___4DE98D56 " 9>-z"-"  KVM " ̊?N>-#)-)%VM K ) -  K>-!"-" VM " Vƍ^t-@  K>-L<-<40VM 48('All ad-hoc plans') < Wg% > c-(NO-  N>-%"-"p0,ND K pDF__sysdbmain__serve__4EDDB18F " l >-@v("-"J&NJDF__sysdbmain__serve__4EDDB18F " FV:*>-x("-"J&NJDF__sysdbmain__serve__4EDDB18F " FLB>-z"-"  KN " ;f k>-%)-)%N@ K ) l %-  K>-%"-" N " l -  K>-L <-<S0N S8(CONVERT([sysname],serverproperty('ServerName'),0)) < F > c-(OP-@  O>-)"-"p0,OD K pDF__sysdbmain__succe__4FD1D5C8 " @>-v)"-"J&OJDF__sysdbmain__succe__4FD1D5C8 " P_>-x)"-"J&OJDF__sysdbmain__@ucce__4FD1D5C8 " P`L@>-z"-" > KO " t>-')-)%O K ) -  K>-)"-"  O " @-  K>-L <@<%0O %8((1)) < NE> c-(P:Q-  P>- "- "p0,PD K pDF__sysdbmain__end_t__50C5FA01 " ò>-v""-"J&PJD@__sysdbmain__end_t__50C5FA01 " 4u# >-x""-"J@&PJDF__sysdbmain__end_t__50C5FA01 " 4R>6>-z"-"  KP " uPb>-()-)%P K ) ת- @ K>- "-" P " ò-  K>-<)0<+0P +8(getdate()) < 1> c-(:QsBR-  :Q>- "-"p 0,:QD @ K  pDF__sysdbmain__durat__51BA1E3A " : U >-v""-"J&:QJDF__sysdbmain__durat__51BA1E3A " *~z>-x""-"J&:QJDF__sysdbmain__durat__51BA1E3A " *y>-z"-"@   K:Q " 14>-))-)%:Q K   ) ԟ=o>-  K>- "-" g :Q " : U-  K>-<-<%0:Q %8((0)) < ;~ >@ c-(sBRfS-  sBR>-  "-"p0,sBRD K  pDF__sysdbmain__error__52AE4273 " sa0>-v$"-"Jv&sBRJDF__sysdbmain__error__52AE4273i " ;$Dc>-@$"-"JTP&sBRJDF__sysdbmain__error__52AE4273@8 " ;͚C0>-z"-"  KsBR$ " ,>-+)-)%sBR K  0 ) _W4Ű(-  K>-  "-" psBR "@ sa-  K>-N<)0<%0sBR %8((0)) < t@>-*K#K K K K i7>-K-8+K K K  K i>-*K-K @ K  K j>-K-K K K  K jv0--1!,<8x~}<}l|D|{p{H{zz8zy ytxw|w0wv|v vuluuTtsrrdrqqDqqp8ponnmmllPl(lkDkjiihhhg|gTgfpfeeHd dc,ccblbaa`0``_8_^|^T^]]]h]\\X\[[D[ZZHXHHGxGFLFEXE4EDDCCBAAA|@T@?==L=<<<<;D; ;::98h87P76865 544x32`21H1000//@.---,h,+++d*)()|('H'&&%$l$#@#""d! , HDpH0 p|(D4h\vO| K {>#eK#KfvO|\a K 0[0#e~# $8ĄHԃX؂dtxx~~}$}|t||{l{0{lLl lklkj|jjiih(hg8gf--e*'x K  6 -s>-@-l%"x  )hs6 -k >- - %"x   >>- -~)%x  K >  6 - >-@ y -k -)x 8   )h6  - >-y - -)x   o>--hx  >>-`-gI@Ex "  |_=6 - >-"-"$ K " R<(>-76-6! xdi K 6 PE>-6-p6L6 KLUQ__sysdbmaintplan@h__4C0144E4 6 *86 6- >-76-6k0' KK kUQ__sysdbmaintplan_h__4C0144E4 6 P>-q7-q7 K 7 #rX6 7- >-@ <-{<"0< K " < c '6 <--  y>-- )%y ?)y   L>--*'y K  L><@f>-a-IEy   -]>-!-y  %y>-"y - -)y"8   ٪ >-#@ %"y  ra>-$y -# -)y $  va>-%-$%"y  v >-&y -% -B)y 8  @ >-'-&%"y  ٪ 7>-(y -' -a)y 4  %)t<>-)-(%"y  >-*y -) -e)y@4  @NȄ>-+-*%"y  %)t<>-,y -+ -')y 4  }>---,%"y  @NȄkH>-.y @- -)y4  ˆ.>-/-.%"y  }y>-0y -/ -)y h  v>-1-0%C"y @ ˆ.>-2y -1 -a)y = "  >-3-2%Ǐ"y   vI>-4y -3 -)y 8 !   ^>-5-4%"@y   >-6y -5 -)y 8 % >  s9d>-7-6%"y   s9d>-8y -7 -)y 4   >-9@-8%"y   $-:ya$-;w-->-<-*'w K-  y->-=-:%"w   c>->->@"w  JF>-?-?%"w  /!j$>-@-@%"w  ">-A-A%"w  ~t>-B-BH%"w  Ѵ>-C-C%"w  x0TLD<lT<$ lT<$ |d L ( P d 0 h0 dH8|8p%"tTLD<lT<$ lT<$ |d L ( P d 0 h0 dH8|%---_