sys.sp_syscollector_enable_collector

Description

Enables the data collector. Because there’s only one data collector per server, no parameters Defaults to the data collector on the server. (with EXECUTE permission) fixed database role to execute this procedure. The following example enables the data collector.

Syntax

sp_syscollector_enable_collector
[ ; ]

Examples

Example 1

0

Example 2

1

Example 3

sp_syscollector_enable_collector
[ ; ]

Example 4

USE msdb;
GO
EXECUTE dbo.sp_syscollector_enable_collector;

Example 5

D:\tempdata

Example 6

USE msdb;
GO
EXECUTE dbo.sp_syscollector_disable_collector;
GO
EXECUTE dbo.sp_syscollector_set_cache_directory @cache_directory = N
'D:\tempdata'
;
GO
EXECUTE dbo.sp_syscollector_enable_collector;
GO

Example 7

USE msdb;
GO
EXECUTE dbo.sp_syscollector_disable_collector;
GO
EXECUTE dbo.sp_syscollector_set_cache_window 3;
GO
EXECUTE dbo.sp_syscollector_enable_collector;