SQL Server Scheduled Job - says its running with no errors but doing nothing.... Average completion job time is 3 hours ..but its showing running...Tell me Issue.. ![alt text] : /storage/temp/2589-error-job.jpg
You could see if it's being blocked by something (unlikely but you want to make sure). Run sp_who2 and see if its process is being blocked by another (in the BlkBy column). You could check how hard the machine is working. It might just be working hard and therefore slow. You could look at what the job does. If it processes an input file, is the latest file much bigger than usual?