xp_cmdshell running as a sql agent job

[ezecastle]

I have created a job that runs this code:

exec master..xp_cmdshell 'D:\Trace_output\Auto_perfmon\Autoperfmon.bat'

This runs fine as long as I place the counter.txt file in the windows\system32 dir.

The bat file has this code:


typeperf -cf counter.txt -o D:\Trace_output\Auto_perfMon\autoperf

This starts without any issues and i see typeperf.exe in the taskmanger.

The question i have is how can i stop this without having to go into taskmanager and killing typeperf.exe?

thanks for your time

[ezecastle]

I think I figured it out.

I can create another .bat file with this command.

Kill -f typeperf.exe

this will kill the process