MZ @ !L!This program cannot be run in DOS mode.
$ PE L .S ! 8 V ` @ t @ pV K ` B > H .text 6 8 `.rsrc ` : @ @.reloc @ @ B V H $S L P T2 R l
l.collection_set_id = c.collection_set_idl.status = 1l.runtime_execution_mode = 1l.finish_time IS NOT NULLl.collection_set_idtop 1 l.statusl.runtime_execution_model.finish_timel.package_execution_id = d.executionidl.log_idd.sourced.eventd.messaged.starttimed.endtimed.datacode
<
l.collection_set_id = c.collection_set_idl.collection_item_id = i.collection_item_idl.log_idl.parent_log_id
CASE
WHEN l.package_id IS NULL THEN c.name
WHEN l.package_id = N'84CEC861-D619-433D-86FB-0BB851AF454A' THEN N'Master'
ELSE l.package_name
END
l.statusl.runtime_execution_model.start_timel.last_iteration_timel.finish_time
CASE
WHEN l.finish_time IS NOT NULL THEN DATEDIFF(s, l.start_time, l.finish_time)
WHEN l.last_iteration_time IS NOT NULL THEN DATEDIFF(s, l.start_time, l.last_iteration_time)
ELSE 0
END
l.failure_messagel.operatorl.package_execution_idl.collection_set_idc.namei.collection_item_idi.namel.package_id
Z
ct.collector_type_uid = ci.collector_type_uidci.collection_item_idci.collection_set_idci.namect.nameci.frequencyci.parametersscheds.schedule_uid = cs.schedule_uidproxy.proxy_id = cs.proxy_idcreate table #tmp_help_proxy (
proxy_id int null,
name nvarchar(128) null,
credential_identity nvarchar(128) null,
enabled tinyint null,
description nvarchar(1024) null,
user_sid varbinary(40) null,
credential_id int null,
credential_identity_exists int null
)
-- sp_help_proxy calls sp_verify_subsystems which runs an INSERT-EXEC
-- statement if subsystems are not setup. Since INSERT-EXEC statements
-- cannot be nested, make sure sp_verify_subsystems is executed here once
-- or the following INSERT-EXEC statement will fail
--
-- dc_operator is granted permission to execute sp_verify_subsystems
--
-- this call will populate subsystems table if necessary
EXEC msdb.dbo.sp_verify_subsystems
insert into #tmp_help_proxy exec msdb.dbo.sp_help_proxydrop table #tmp_help_proxycs.collection_set_idcs.collection_set_uidcs.namecs.targetscheds.nameproxy.namecs.collection_modecs.logging_levelcs.is_runningcs.is_systemcs.descriptioncs.days_until_expiration
DECLARE @MDWInstance sql_variant;
DECLARE @MDWDatabase sql_variant;
DECLARE @Enabled sql_variant;
DECLARE @CacheWindow sql_variant;
DECLARE @CacheDirectory sql_variant;
SELECT @MDWInstance = parameter_value
FROM [msdb].[dbo].[syscollector_config_store]
WHERE parameter_name = N'MDWInstance'
SELECT @MDWDatabase = parameter_value
FROM [msdb].[dbo].[syscollector_config_store]
WHERE parameter_name = N'MDWDatabase'
SELECT @Enabled = ISNULL(parameter_value, 0)
FROM [msdb].[dbo].[syscollector_config_store]
WHERE parameter_name = N'CollectorEnabled'
SELECT @CacheWindow = ISNULL(parameter_value, 1)
FROM [msdb].[dbo].[syscollector_config_store]
WHERE parameter_name = N'CacheWindow'
SELECT @CacheDirectory = parameter_value
FROM [msdb].[dbo].[syscollector_config_store]
WHERE parameter_name = N'CacheDirectory'
create table #tmp_pivot_config_table (
[MDWInstance] sql_variant null,
[MDWDatabase] sql_variant null,
[Enabled] sql_variant null,
[CacheWindow] sql_variant null,
[CacheDirectory] sql_variant null);
Insert into #tmp_pivot_config_table Values(@MDWInstance, @MDWDatabase, @Enabled, @CacheWindow, @CacheDirectory)
drop table #tmp_pivot_config_table serverproperty(N'Servername')ISNULL(tmp.MDWInstance, N'')ISNULL(tmp.MDWDatabase, N'')tmp.Enabledtmp.CacheWindowISNULL(tmp.CacheDirectory, N'')
T^җIcMb76.&X*=
ʢ@{*g]PI@aUX59h&$7_o02âHTtno4-BW>Em S.y'JpN7; ]_Il-TBSJB v2.0.50727 l #~ 0 ` #Strings #US #GUID #Blob 3 $
A D p d g , . y0