check if data collection is on

select * from msdb.[dbo].[syscollector_config_store_internal]
where parameter_name = 'CollectorEnabled'