I would like to kown how to determine which stored procedures run during a specific SQL server Job run.
One major constraint is that I have extremely low bandwidth and very high DISK IO on the production box already so I am not allowed to run SQL Profiler either on my work station or on the actual server.
I have information on jobs, schedules and procedures from the sysjobs, sysschedules and procedures system views respectively. I would like to know how do I relate them together.
Thank you,
In anticipation.
Rohit