job

Can anyone tell me how to schedual a profiler as a job..
start and stop it... thanxsCS,
this article explains which extended stored procedures are required to
initiate profiling.
http://www.databasejournal.com/features/mssql/article.php/1440421
Once you have generated a script containing the events you require, you
could create a job which runs the script and schedule the job.
HTH,
Paul Ibison|||>
> Can anyone tell me how to schedual a profiler as a job..
> start and stop it... thanxs
--
Try this:
INF: Job to Monitor SQL Server 2000 Performance and Activity
http://support.microsoft.com/?id=283696
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional