Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Job Queue - how kill unwanted sessions and refresh the job
RachelSoon
Member Posts: 202
Hi there,
we are setting the NAS with the job queue. We found that the job queue seem unstable in NAV2009R2.
a) Day 1, the service has stopped due to ODBC error (we dont know the reason).
b) Day 2, we are force to start the service (restart server and start service as well)
c) Day 3, the job does not get trigger (suppose to run on Day 4 1am)
After we restart the NAS service on 23 Dec, NAV starts creating multiple session entries in the Job queue processes continuously. These entries, we are not able to track down through SQL with the respective SPID. Also, checking from the Event Viewer, the warning that are generated from this NAS source, those are from a previous instance of the NAV object. The object has already been modified and the error has already been resolved, but still it shows up. All these happens once the NAS is restarted. How do we kill these unwanted sessions and refresh the job process to make it work again?
Currently, even we kill the job queue processes, the entries will be still keep on creating by itself.
Hope that someone can provide us the pointer on this problems.
thank you.
we are setting the NAS with the job queue. We found that the job queue seem unstable in NAV2009R2.
a) Day 1, the service has stopped due to ODBC error (we dont know the reason).
b) Day 2, we are force to start the service (restart server and start service as well)
c) Day 3, the job does not get trigger (suppose to run on Day 4 1am)
After we restart the NAS service on 23 Dec, NAV starts creating multiple session entries in the Job queue processes continuously. These entries, we are not able to track down through SQL with the respective SPID. Also, checking from the Event Viewer, the warning that are generated from this NAS source, those are from a previous instance of the NAV object. The object has already been modified and the error has already been resolved, but still it shows up. All these happens once the NAS is restarted. How do we kill these unwanted sessions and refresh the job process to make it work again?
Currently, even we kill the job queue processes, the entries will be still keep on creating by itself.
Hope that someone can provide us the pointer on this problems.
thank you.
0