Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Scheduling Traces

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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft