I set a job to run every morning, for the first few days it worked fine but from yesterday morning, when I run the query that checks if there are any jobs that are blocks, it showed that the job
starts running but stops after a second then blocks it's self. The jobs wait type is CXPACKET. Would someone let me know how I can resolve this please?
View Complete Post