Wednesday, March 21, 2012

Running SQL2005 profiler from an SQLAgent job

Hi,
I would like to run a certain profiler template against a server on a
regular basis. I can run profiler90 from the Command Prompt and it starts
creating the trace file. Can I run profiler90 from within an SQLAgent job? I
have tried and it did not run.
Thanks
Chris
Hi Chris,
You have to use the trace procedures. An easy way to get started, is to
script the trace from file > export menu.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Chris Wood" <anonymous@.microsoft.com> wrote in message
news:e3dSWiwnIHA.4536@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I would like to run a certain profiler template against a server on a
> regular basis. I can run profiler90 from the Command Prompt and it starts
> creating the trace file. Can I run profiler90 from within an SQLAgent job?
> I have tried and it did not run.
> Thanks
> Chris
>
|||Hi
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
"Chris Wood" <anonymous@.microsoft.com> wrote in message
news:e3dSWiwnIHA.4536@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I would like to run a certain profiler template against a server on a
> regular basis. I can run profiler90 from the Command Prompt and it starts
> creating the trace file. Can I run profiler90 from within an SQLAgent job?
> I have tried and it did not run.
> Thanks
> Chris
>
|||Thanks Uri and Jason. I will look at the url link and go from there.
Chris
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uV5GL55nIHA.4328@.TK2MSFTNGP03.phx.gbl...
> Hi
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
>
> "Chris Wood" <anonymous@.microsoft.com> wrote in message
> news:e3dSWiwnIHA.4536@.TK2MSFTNGP06.phx.gbl...
>

No comments:

Post a Comment