SQL Server - How to find a Stored procedure being called in sql nightly job in database

Asked By ram chander on 10-Sep-14 02:17 PM
I have a Stored procedure. now I want to see which nightly job triggers this  in  Sql server database.
Robbe Morris replied to ram chander on 10-Sep-14 02:17 PM
You could always run sql profiler but you may not be able to identify the exact app.  If the procedure only gets run by this job, rename the procedure and wait for the job to fail.  Sounds silly I know but it may be the only reliable way to locate what is calling it.