Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jay1
Starting Member
17 Posts |
 Posted - 2010-09-10 : 05:39:42
|
| Hi All,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?Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jay1
Starting Member
17 Posts |
Posted - 2010-09-13 : 06:36:21
|
quote:
Originally posted by tkizer
What does the job do?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
The job looks for any data that has been inserted one day before in one table then it inserts the data into another table then it goes through another condition then updates another table, so there are lots of INSERTS and UPDATES in this particular query. I hope that gives a bit more detail in what the job is trying to achieve.Thank you |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Blocked Job