schedule-traces.md

title	Schedule Traces | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology
ms.topic	conceptual
helpviewer_keywords	filters [SQL Server], events traces [SQL Server] traces [SQL Server], stopping events [SQL Server], filters scheduling traces [SQL Server] traces [SQL Server], scheduling stopping traces
ms.assetid	620b79db-924b-4502-8af3-39efcfca245d
author	MashaMSFT
ms.author	mathoma

Schedule Traces

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] There are two ways to schedule tracing in Microsoft [!INCLUDEssNoVersion]. You can:

• Enable a trace stop time.

• Use [!INCLUDEssNoVersion] Agent to schedule a trace.

Specifying a Stop Time

You can specify a trace stop time if you use [!INCLUDEtsql] stored procedures or if you use [!INCLUDEssSqlProfiler]. 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 [!INCLUDEssNoVersion] Agent to start the trace and then specify a trace stop time by using the [!INCLUDEtsql] stored procedure sp_trace_setstatus, or [!INCLUDEssSqlProfiler].

To set an end time filter for a trace

Filter Events Based on the Event End Time (SQL Server Profiler)

sp_trace_setstatus (Transact-SQL)

See Also

Automated Administration Tasks (SQL Server Agent)