Scheduling a trace

Question

Post reply

Scheduling a trace

Steve Jones - SSC Editor

SSC Guru

Points: 736297
More actions
October 27, 2010 at 9:19 pm

#242257

I had a request for a basic article on how to schedule a trace. This article should assume someone knows how to create a custom server side trace. Show one that you've created and then go over how to schedule with T-SQL and/or SSMS

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

You mean like http://www.sqlservercentral.com/scripts/66808/?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

I'll write up something on this.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 3

That script sets up a simple trace, but doesn't go through scheduling it for a period of time to run. It would be good to have a short explanation of how to schedule it via T-sQL and/or SSMS.

tjaybelt SSCrazy Points: 2604 More actions · Answer 4

ive done this, and would love to write up something.

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 736297

January 3, 2011 at 8:46 am

#1268502

Closing this one as complete.