hi
I am looking at a some job queues on a 2009 R2 system which refuse to start at the configured date and time.
Yesterday I stopped the NAS service I set the earliest start date and time 30/01/18 01:00 and the start time of 01:00, I then start the NAS service.
I checked today, nothing happened, nothing in the job queue log entries and nothing in the windows event logs.
The user that configured the job to run has super permissions and the password hasn't expired. Sometimes if I restart the NAS service after doing the above a job will randomly start but no other job will run afterwards.
Does anyone have any ideas?
Thanks in advance
Ercan.
0
Answers
If you don't have jobs that are created by users, you can use webservices for it being called from PowerShell in SQL Server Agent.
I have done that for a customer with NAV2009R2 because NAS Jobqueue was too unreliable.
To get you started: https://mibuso.com/howtos/how-to-use-powershell-to-test-your-nav-webservice
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!