sys.sp_syscollector_disable_collector

Description

Disables 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 disables the data collector.

Syntax

sp_syscollector_disable_collector
[ ; ]

Examples

Example 1

0

Example 2

1

Example 3

sp_syscollector_disable_collector
[ ; ]

Example 4

EXECUTE dbo.sp_syscollector_disable_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;