Rev 174 | Blame | Compare with Previous | Last modification | View Log | Download
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"DTS:refId="Package"DTS:CreationDate="5/11/2016 10:39:05 AM"DTS:CreationName="Microsoft.Package"DTS:CreatorComputerName="SQLS04"DTS:CreatorName="NLRTTIA\jordaanm"DTS:DTSID="{3E2577D0-76B1-48B8-9998-12ADB4F6B15A}"DTS:ExecutableType="Microsoft.Package"DTS:LastModifiedProductVersion="12.0.4100.1"DTS:LocaleID="1043"DTS:ObjectName="SQLS04 MaintenancePlan"DTS:PackageType="6"DTS:VersionBuild="3"DTS:VersionGUID="{B99D475A-1336-4085-B1FF-6AF56C14B007}"><DTS:PropertyDTS:Name="PackageFormatVersion">8</DTS:Property><DTS:ConnectionManagers><DTS:ConnectionManagerDTS:refId="Package.ConnectionManagers[Local server connection]"DTS:CreationName="ADO.NET:SQL"DTS:DTSID="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"DTS:ObjectName="Local server connection"><DTS:ObjectData><DTS:ConnectionManagerDTS:ConnectionString="Data Source=SQLS04;Integrated Security=True;Pooling=False;MultipleActiveResultSets=False;Packet Size=4096;Application Name="Microsoft SQL Server Management Studio";" /></DTS:ObjectData></DTS:ConnectionManager></DTS:ConnectionManagers><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:DTSID="{B2CE6CD3-9926-433A-9B50-2128F347493B}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="EmailReportToOperator"><DTS:VariableValueDTS:DataType="8"xml:space="preserve"></DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{963ABEDA-1C23-4846-A662-F2ABC205D089}"DTS:IncludeInDebugDump="6789"DTS:Namespace="global"DTS:ObjectName="ExtendedLogging"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{9D3F3579-A072-49EF-9D05-63F9FC23D4F5}"DTS:IncludeInDebugDump="6789"DTS:Namespace="global"DTS:ObjectName="GenerateEmailReport"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{1E290D8F-DA4B-41D0-960C-EC114029113E}"DTS:IncludeInDebugDump="6789"DTS:Namespace="global"DTS:ObjectName="GenerateTextReport"><DTS:VariableValueDTS:DataType="11">-1</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{726F6F6B-A9B3-4BAF-800E-FC1A71ECE8E3}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="LocalConnectionForReportingAndLogging"><DTS:VariableValueDTS:DataType="8">Local server connection</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{3EB029A2-DCFA-4C7E-AE35-FB5A1DCF4729}"DTS:IncludeInDebugDump="6789"DTS:Namespace="global"DTS:ObjectName="LogRemote"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{1CE29A62-4B3C-4416-A939-A196CC2BA214}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="MaintenanceDesignerVersion"><DTS:VariableValueDTS:DataType="8">12.0.2000.8 ((SQL14_RTM).140220-1832 )</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{5D4ED4EF-8AD5-445F-B936-8173B755021D}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="ProxyAccount"><DTS:VariableValueDTS:DataType="8"xml:space="preserve"></DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{90A02D97-60BA-4C77-9BCC-6D246DA530C7}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="RemoteConnectionName"><DTS:VariableValueDTS:DataType="8"xml:space="preserve"></DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{76D00C6C-0B5D-46BA-86B4-04BC80E84D90}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="RunId"><DTS:VariableValueDTS:DataType="8"xml:space="preserve"></DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{07E8A59E-2C29-49B4-9ADC-41638E2A7D78}"DTS:IncludeInDebugDump="6789"DTS:Namespace="global"DTS:ObjectName="TextReportInNewFile"><DTS:VariableValueDTS:DataType="11">-1</DTS:VariableValue></DTS:Variable><DTS:VariableDTS:CreationName=""DTS:DTSID="{206E0BCA-9624-41EA-A124-C701B3543BF8}"DTS:IncludeInDebugDump="2345"DTS:Namespace="global"DTS:ObjectName="TextReportPath"><DTS:VariableValueDTS:DataType="8">D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables><DTS:ExecutableDTS:refId="Package\Reporting Task for subplan-{D560F2A2-1DD8-4B57-B121-010C417EBB32\}"DTS:CreationName="Microsoft.ReportingTask"DTS:DTSID="{015A99B1-2ECA-45AF-BAC1-C2C30CB58191}"DTS:ExecutableType="Microsoft.ReportingTask"DTS:LocaleID="-1"DTS:ObjectName="Reporting Task for subplan-{D560F2A2-1DD8-4B57-B121-010C417EBB32}"DTS:TaskContact="Maintenance Plan Reporting Task; Microsoft Corporation; Microsoft SQL Server v9; � 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"DTS:ThreadHint="0"><DTS:Variables /><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:ServerVersion="9"SQLTask:ExtendedLogging="True"SQLTask:LocalConnectionForLogging="Local server connection"SQLTask:TaskName=""SQLTask:IgnoreDatabasesInNotOnlineState="False"SQLTask:GenerateTextReport="True"SQLTask:ProxyAccount=""SQLTask:CreateNewFile="True"SQLTask:Path="D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log"SQLTask:EmailReport="False"SQLTask:LogRemote="False" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" /></DTS:ObjectData></DTS:Executable><DTS:ExecutableDTS:refId="Package\Subplan_1"DTS:CreationName="STOCK:SEQUENCE"DTS:Description="Subplan_1"DTS:Disabled="True"DTS:DTSID="{D560F2A2-1DD8-4B57-B121-010C417EBB32}"DTS:ExecutableType="STOCK:SEQUENCE"DTS:FailParentOnFailure="True"DTS:LocaleID="-1"DTS:ObjectName="Subplan_1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:DTSID="{1719851F-9000-4FAA-A92A-D1F080DCEC12}"DTS:IncludeInDebugDump="6789"DTS:Namespace="subplans"DTS:ObjectName="SubplanSortIndex"DTS:ReadOnly="True"><DTS:VariableValueDTS:DataType="3">1</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables><DTS:ExecutableDTS:refId="Package\Subplan_1\Execute SQL Server Agent Job Task"DTS:CreationName="Microsoft.DbMaintenanceExecuteAgentJobTask"DTS:Description="Execute SQL Server Agent Job Task"DTS:DTSID="{2FC08029-E4D3-492B-BA34-38E0A63942FA}"DTS:ExecutableType="Microsoft.DbMaintenanceExecuteAgentJobTask"DTS:LocaleID="-1"DTS:ObjectName="Execute SQL Server Agent Job Task"DTS:TaskContact="Execute SQL Server Agent Job Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"DTS:ThreadHint="0"><DTS:Variables /><DTS:EventHandlers><DTS:EventHandlerDTS:refId="Package\Subplan_1\Execute SQL Server Agent Job Task.EventHandlers[OnPostExecute]"DTS:CreationName="OnPostExecute"DTS:DTSID="{649F99EF-22FB-4F92-9B7C-524A293E1C10}"DTS:EventID="0"DTS:EventName="OnPostExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{61C8740E-2BFA-4700-A1AC-55C8EB0C1FD7}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler><DTS:EventHandlerDTS:refId="Package\Subplan_1\Execute SQL Server Agent Job Task.EventHandlers[OnPreExecute]"DTS:CreationName="OnPreExecute"DTS:DTSID="{A9CD8D9B-8C77-45EC-B291-02C7D4690408}"DTS:EventID="0"DTS:EventName="OnPreExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{16712650-63C1-47AB-AD90-FF177302FFFF}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler></DTS:EventHandlers><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:ServerVersion="9"SQLTask:ExtendedLogging="False"SQLTask:LocalConnectionForLogging="Local server connection"SQLTask:TaskName=""SQLTask:IgnoreDatabasesInNotOnlineState="False"SQLTask:AgentJobID="SQL Server recylce log file" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" /></DTS:ObjectData></DTS:Executable><DTS:ExecutableDTS:refId="Package\Subplan_1\Maintenance Cleanup Task"DTS:CreationName="Microsoft.DbMaintenanceFileCleanupTask"DTS:Description="Maintenance Cleanup Task"DTS:DTSID="{AEB59167-1FCD-45AA-92CF-1BB64FB412A0}"DTS:ExecutableType="Microsoft.DbMaintenanceFileCleanupTask"DTS:LocaleID="-1"DTS:ObjectName="Maintenance Cleanup Task"DTS:TaskContact="File Cleanup Task; Microsoft Corporation; Microsoft SQL Server 2014; © 2014 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"DTS:ThreadHint="0"><DTS:Variables /><DTS:EventHandlers><DTS:EventHandlerDTS:refId="Package\Subplan_1\Maintenance Cleanup Task.EventHandlers[OnPostExecute]"DTS:CreationName="OnPostExecute"DTS:DTSID="{4CEBF228-D504-458E-80F7-D018172E610E}"DTS:EventID="0"DTS:EventName="OnPostExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{F4BD6CD0-B4C8-4C7D-87EF-FD417F55CC35}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler><DTS:EventHandlerDTS:refId="Package\Subplan_1\Maintenance Cleanup Task.EventHandlers[OnPreExecute]"DTS:CreationName="OnPreExecute"DTS:DTSID="{7EB62DB7-3696-4389-9016-4F0223B5AE00}"DTS:EventID="0"DTS:EventName="OnPreExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{BEEDBD89-70DF-44B5-B44F-01A578545F49}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler></DTS:EventHandlers><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:ServerVersion="9"SQLTask:ExtendedLogging="False"SQLTask:LocalConnectionForLogging="Local server connection"SQLTask:TaskName=""SQLTask:IgnoreDatabasesInNotOnlineState="False"SQLTask:FileTypeSelected="0"SQLTask:FilePath="D:\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log"SQLTask:FolderPath=""SQLTask:CleanSubFolders="False"SQLTask:FileExtension=""SQLTask:AgeBased="True"SQLTask:DeleteSpecificFile="True"SQLTask:RemoveOlderThan="2"SQLTask:TimeUnitsType="1" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" /></DTS:ObjectData></DTS:Executable><DTS:ExecutableDTS:refId="Package\Subplan_1\Reorganize Index Task"DTS:CreationName="Microsoft.DbMaintenanceDefragmentIndexTask"DTS:Description="Reorganize Index Task"DTS:DTSID="{78948A88-CD76-4F7E-9B5B-531438D0774F}"DTS:ExecutableType="Microsoft.DbMaintenanceDefragmentIndexTask"DTS:LocaleID="-1"DTS:ObjectName="Reorganize Index Task"DTS:TaskContact="Reorganize Index Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"DTS:ThreadHint="0"><DTS:Variables /><DTS:EventHandlers><DTS:EventHandlerDTS:refId="Package\Subplan_1\Reorganize Index Task.EventHandlers[OnPostExecute]"DTS:CreationName="OnPostExecute"DTS:DTSID="{DD1CB02B-AA3B-4ACF-BBDE-6D3D26B25F01}"DTS:EventID="321244652"DTS:EventName="OnPostExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{E2FA9ECE-C77E-479B-8C98-7AFB83E9ECB5}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler><DTS:EventHandlerDTS:refId="Package\Subplan_1\Reorganize Index Task.EventHandlers[OnPreExecute]"DTS:CreationName="OnPreExecute"DTS:DTSID="{B6BEE581-AB09-48F3-9713-B996D8E1FEFF}"DTS:EventID="0"DTS:EventName="OnPreExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{C42DE0E3-242B-4F27-BFC4-B5C166C2C9E0}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler></DTS:EventHandlers><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:DatabaseSelectionType="4"SQLTask:ServerVersion="12"SQLTask:ExtendedLogging="False"SQLTask:LocalConnectionForLogging="Local server connection"SQLTask:TaskName=""SQLTask:IgnoreDatabasesInNotOnlineState="True"SQLTask:CompactLargeObjects="True" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"><SQLTask:SelectedDatabasesSQLTask:DatabaseName="610620" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="EVA" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="MASSA" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="MESAL" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="MPV" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="T10" /></SQLTask:SqlTaskData></DTS:ObjectData></DTS:Executable><DTS:ExecutableDTS:refId="Package\Subplan_1\Shrink Database Task"DTS:CreationName="Microsoft.DbMaintenanceShrinkTask"DTS:Description="Shrink Database Task"DTS:DTSID="{BC692AF5-A8AC-412B-8E84-ABC55ACD343A}"DTS:ExecutableType="Microsoft.DbMaintenanceShrinkTask"DTS:LocaleID="-1"DTS:ObjectName="Shrink Database Task"DTS:TaskContact="Shrink Database Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"DTS:ThreadHint="0"><DTS:Variables /><DTS:EventHandlers><DTS:EventHandlerDTS:refId="Package\Subplan_1\Shrink Database Task.EventHandlers[OnPostExecute]"DTS:CreationName="OnPostExecute"DTS:DTSID="{1C4BF108-897F-4E83-9E2F-2563261B0AC9}"DTS:EventID="0"DTS:EventName="OnPostExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{FAEA47DD-9EC4-4E6B-B73B-4F90DB16928A}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler><DTS:EventHandlerDTS:refId="Package\Subplan_1\Shrink Database Task.EventHandlers[OnPreExecute]"DTS:CreationName="OnPreExecute"DTS:DTSID="{3305D1A8-C4EC-43F6-88FD-7221B92A814F}"DTS:EventID="0"DTS:EventName="OnPreExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{9B73F4DF-6D9D-4843-B949-8BBD2BB74096}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables /></DTS:EventHandler></DTS:EventHandlers><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:DatabaseSelectionType="4"SQLTask:ServerVersion="9"SQLTask:ExtendedLogging="False"SQLTask:LocalConnectionForLogging="Local server connection"SQLTask:TaskName=""SQLTask:IgnoreDatabasesInNotOnlineState="False"SQLTask:DatabaseSizeLimit="50"SQLTask:DatabasePercentLimit="10"SQLTask:DatabaseReturnFreeSpace="True" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"><SQLTask:SelectedDatabasesSQLTask:DatabaseName="610620" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="EVA" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="MASSA" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="MESAL" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="MPV" /><SQLTask:SelectedDatabasesSQLTask:DatabaseName="T10" /></SQLTask:SqlTaskData></DTS:ObjectData></DTS:Executable></DTS:Executables><DTS:PrecedenceConstraints><DTS:PrecedenceConstraintDTS:refId="Package\Subplan_1.PrecedenceConstraints[Constraint]"DTS:CreationName=""DTS:DTSID="{8B3619D8-3761-45C0-A0C6-4E0D540F4E9D}"DTS:From="Package\Subplan_1\Reorganize Index Task"DTS:LogicalAnd="True"DTS:ObjectName="Constraint"DTS:To="Package\Subplan_1\Shrink Database Task" /><DTS:PrecedenceConstraintDTS:refId="Package\Subplan_1.PrecedenceConstraints[Constraint 1]"DTS:CreationName=""DTS:DTSID="{AF9F9F8C-FA4C-47BC-8DD4-2402D1C25A95}"DTS:From="Package\Subplan_1\Shrink Database Task"DTS:LogicalAnd="True"DTS:ObjectName="Constraint 1"DTS:To="Package\Subplan_1\Maintenance Cleanup Task" /><DTS:PrecedenceConstraintDTS:refId="Package\Subplan_1.PrecedenceConstraints[Constraint 2]"DTS:CreationName=""DTS:DTSID="{DE77C4A9-163C-4AA3-8A97-03DA23CD533F}"DTS:From="Package\Subplan_1\Maintenance Cleanup Task"DTS:LogicalAnd="True"DTS:ObjectName="Constraint 2"DTS:To="Package\Subplan_1\Execute SQL Server Agent Job Task" /></DTS:PrecedenceConstraints><DTS:EventHandlers><DTS:EventHandlerDTS:refId="Package\Subplan_1.EventHandlers[OnPostExecute]"DTS:CreationName="OnPostExecute"DTS:DTSID="{52B74018-57FC-4965-B7F0-5D3E2ECD0D4F}"DTS:EventID="0"DTS:EventName="OnPostExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{E490B43D-A2B4-48A1-8B9E-3E07616A382A}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables><DTS:ExecutableDTS:refId="Package\Subplan_1.EventHandlers[OnPostExecute]\{922BBB49-9D76-45CD-B978-EA3C808376CD\}"DTS:CreationName="Microsoft.SubPlanPostExecuteTask"DTS:DTSID="{922BBB49-9D76-45CD-B978-EA3C808376CD}"DTS:ExecutableType="Microsoft.SubPlanPostExecuteTask"DTS:LocaleID="-1"DTS:ObjectName="{922BBB49-9D76-45CD-B978-EA3C808376CD}"DTS:TaskContact="Maintenance Plan Reporting Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"><DTS:Variables /><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:ServerVersion="9"SQLTask:ExtendedLogging="True"SQLTask:LocalConnectionForLogging=""SQLTask:TaskName=""SQLTask:IgnoreDatabasesInNotOnlineState="False" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" /></DTS:ObjectData></DTS:Executable></DTS:Executables></DTS:EventHandler><DTS:EventHandlerDTS:refId="Package\Subplan_1.EventHandlers[OnPreExecute]"DTS:CreationName="OnPreExecute"DTS:DTSID="{86BBC6DB-8E15-464C-BC55-3C980B36E4DC}"DTS:EventID="0"DTS:EventName="OnPreExecute"DTS:LocaleID="-1"><DTS:Variables><DTS:VariableDTS:CreationName=""DTS:Description="The propagate property of the event"DTS:DTSID="{FEEEAD9E-96B0-402D-AA56-44C873E9B7A7}"DTS:IncludeInDebugDump="6789"DTS:Namespace="System"DTS:ObjectName="Propagate"><DTS:VariableValueDTS:DataType="11">0</DTS:VariableValue></DTS:Variable></DTS:Variables><DTS:Executables><DTS:ExecutableDTS:refId="Package\Subplan_1.EventHandlers[OnPreExecute]\{5E9CD7E3-8C90-4781-A2CA-21597A6652A3\}"DTS:CreationName="Microsoft.ExecuteSQLTask"DTS:DTSID="{5E9CD7E3-8C90-4781-A2CA-21597A6652A3}"DTS:ExecutableType="Microsoft.ExecuteSQLTask"DTS:LocaleID="-1"DTS:ObjectName="{5E9CD7E3-8C90-4781-A2CA-21597A6652A3}"DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2014; © 2014 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"><DTS:Variables /><DTS:ObjectData><SQLTask:SqlTaskDataSQLTask:Connection="{C5E90F84-52A9-496B-9FB3-F4BE5BBB0AFD}"SQLTask:SqlStatementSource="DECLARE @Guid UNIQUEIDENTIFIER 

 EXECUTE msdb..sp_maintplan_open_logentry '{3E2577D0-76B1-48B8-9998-12ADB4F6B15A}', '{D560F2A2-1DD8-4B57-B121-010C417EBB32}',NULL, @Guid OUTPUT 

 Select CONVERT(nvarchar(38),@Guid) AS RunId"SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"><SQLTask:ResultBindingSQLTask:ResultName="0"SQLTask:DtsVariableName="RunId" /></SQLTask:SqlTaskData></DTS:ObjectData></DTS:Executable></DTS:Executables></DTS:EventHandler></DTS:EventHandlers></DTS:Executable></DTS:Executables><DTS:PrecedenceConstraints><DTS:PrecedenceConstraintDTS:refId="Package.PrecedenceConstraints[{D560F2A2-1DD8-4B57-B121-010C417EBB32\}]"DTS:CreationName=""DTS:DTSID="{E6EA1226-19BB-4F62-8165-99DE56E29C24}"DTS:EvalOp="3"DTS:Expression="LEN(@[global::RunId]) > 0"DTS:From="Package\Subplan_1"DTS:LogicalAnd="True"DTS:ObjectName="{D560F2A2-1DD8-4B57-B121-010C417EBB32}"DTS:To="Package\Reporting Task for subplan-{D560F2A2-1DD8-4B57-B121-010C417EBB32\}"DTS:Value="2" /></DTS:PrecedenceConstraints><DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?><!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.--><!--If you manually edit this section and make a mistake, you can delete it. --><!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.--><ObjectsVersion="sql12"><!--Each node below will contain properties that do not affect runtime behavior.--><Sequencedesign-time-name="Package\Subplan_1"><LayoutInfo><GraphLayoutCapacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml"><NodeLayoutSize="295,82"Id="{}{78948A88-CD76-4F7E-9B5B-531438D0774F}"TopLeft="56,7" /><NodeLayoutSize="227,82"Id="{}{BC692AF5-A8AC-412B-8E84-ABC55ACD343A}"TopLeft="85,143" /><EdgeLayoutId="{}{8B3619D8-3761-45C0-A0C6-4E0D540F4E9D}"TopLeft="201,89"><EdgeLayout.Curve><mssgle:CurveStartConnector="{assembly:Null}"EndConnector="0,54"Start="0,0"End="0,46.5"><mssgle:Curve.Segments><mssgle:SegmentCollectionCapacity="5"><mssgle:LineSegmentEnd="0,46.5" /></mssgle:SegmentCollection></mssgle:Curve.Segments></mssgle:Curve></EdgeLayout.Curve><EdgeLayout.Labels><EdgeLabelCollection /></EdgeLayout.Labels></EdgeLayout><NodeLayoutSize="296,70"Id="{}{AEB59167-1FCD-45AA-92CF-1BB64FB412A0}"TopLeft="50,263" /><EdgeLayoutId="{}{AF9F9F8C-FA4C-47BC-8DD4-2402D1C25A95}"TopLeft="198.25,225"><EdgeLayout.Curve><mssgle:CurveStartConnector="{assembly:Null}"EndConnector="0,38"Start="0,0"End="0,30.5"><mssgle:Curve.Segments><mssgle:SegmentCollectionCapacity="5"><mssgle:LineSegmentEnd="0,30.5" /></mssgle:SegmentCollection></mssgle:Curve.Segments></mssgle:Curve></EdgeLayout.Curve><EdgeLayout.Labels><EdgeLabelCollection /></EdgeLayout.Labels></EdgeLayout><NodeLayoutSize="247,57"Id="{}{2FC08029-E4D3-492B-BA34-38E0A63942FA}"TopLeft="73.5,380.5" /><EdgeLayoutId="{}{DE77C4A9-163C-4AA3-8A97-03DA23CD533F}"TopLeft="197.5,333"><EdgeLayout.Curve><mssgle:CurveStartConnector="{assembly:Null}"EndConnector="0,47.5"Start="0,0"End="0,40"><mssgle:Curve.Segments><mssgle:SegmentCollectionCapacity="5"><mssgle:LineSegmentEnd="0,40" /></mssgle:SegmentCollection></mssgle:Curve.Segments></mssgle:Curve></EdgeLayout.Curve><EdgeLayout.Labels><EdgeLabelCollection /></EdgeLayout.Labels></EdgeLayout></GraphLayout></LayoutInfo></Sequence></Objects>]]></DTS:DesignTimeProperties></DTS:Executable>