January 8, 2014 at 11:52 pm
Hi,
I created one job, when execute it it takes around 9 hours and when i manually executes that sp which is used in job than only takes 1 min.
So why this happens ?
Please reply. it will be helpful,
Thanks in advanced.
January 9, 2014 at 5:01 am
read something about parameter sniffing.
put your code if its possible
January 9, 2014 at 6:29 am
Is this problem reproducable? Does it occur when the job is scheduled to run at a different moment? Are other processes running at the same moment (could cause blocking issues)?
January 9, 2014 at 10:12 am
What time does the job run and what time are you testing your code?
Is anything else running when the job runs (scheduled)?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply