We have had an interesting issue with one of our production servers lately and I cant really put my finger on why its happening.
Scenario is as follows: We have a job that has multiple job steps.
The step for the job reads like this: exec ssrsJob_spBillingSummaryCurrentPeriod NULL
When you execute this step, the job just hangs, no processing takes place. The job does not fail or go to the next step, just hangs there and racks up the run time.
When I execute the exact same code from managements studio in a query window, the code executes just fine. and the SP is done in a matter of seconds.
Any ideas as to why I cannot run this in a job?