use msdb declare @schedule_uid uniqueidentifier select @schedule_uid=(select schedule_uid from msdb..sysschedules where name=N'CollectorSchedule_Every_15min') declare @collection_set_id int; exec dbo.sp_syscollector_create_collection_set @name = N'SqlTraceDefault', @schedule_uid = @schedule_uid, -- 15 minutes @collection_mode = 1, -- non-cached: scheduled @logging_level = 0, -- minimum logging @days_until_expiration = 5, @description = N'This is a demo collection set', @collection_set_id = @collection_set_id...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/09/24/2180.aspx