SQL Server Performance Forum – Threads Archive
running trace from a job in sql 7 ?what is the process to run a trace from an SQL job? i know in 2000 you can script out the trace, and
then just execute it from a job, but not sure
about the process in SQL 7. thoughts? – SQL.Admin – US.Florida
how about this… save as: ‘sql script’ sound right? if i remember correctly any way.
– SQL.Admin – US.Florida
oops… i’m mistaken. saving it as a script merely saves the trace results as the
tsql code they are run in. just need to some how execute the .trc from a job. thoughts? – SQL.Admin – US.Florida
May take help fromhttp://www.devx.com/getHelpOn/Article/8202/1954?pf=true link. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.