Need to setup SQL Profiler Trace as a batch job

• Express12

  SSCoach

  Points: 18514

  More actions

  December 15, 2006 at 7:51 am

  #114886

  Does anyone have a documented procedure for setting up a SQL Profiler TRACE as a batch job?

  (Currently, I manually setup a SQL PROFILER trace every morning - specifying DatabaseID, Events, StopTime, target trace output into a table, etc.. and would like to have this automated via as a scheduled job) 

  BT

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 15, 2006 at 11:56 pm

  #678510

  You can script trace from profiler...

  When you open profile...

  Click on File/ScriptTrace/sql2000 and save the script on your desktop as trace file...

  Open the saved trace file in QA make it a procedure and schedule it...

  You may need to modify code a little before creating proc...

  MohammedU
  Microsoft SQL Server MVP

• sql_er

  SSCarpal Tunnel

  Points: 4135

  More actions

  December 18, 2006 at 10:24 am

  #678730

  See the following for explanation of the script file generated:

   

  http://www.mssqltips.com/tip.asp?tip=1035