0 out of 1 rated this helpful - Rate this topic

Scheduling Traces

SQL Server 2008 R2

There are two ways to schedule tracing in Microsoft SQL Server. You can:

Enable a trace stop time.
Use SQL Server Agent to schedule a trace.

You can specify a trace stop time if you use Transact-SQL stored procedures or if you use SQL Server Profiler. The stop time must be set when the trace is originally configured.

Scheduling Traces by Using SQL Server Agent

The best way to schedule traces is to use SQL Server Agent to start the trace and then specify a trace stop time by using the Transact-SQL stored procedure sp_trace_setstatus, or SQL Server Profiler.

To set an end time filter for a trace

How to: Filter End-time Events (SQL Server Profiler)

sp_trace_setstatus (Transact-SQL)

Other Resources

Automating Administrative Tasks (SQL Server Agent)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD