NAV Kill Process Issues

Big_D
Big_D Member Posts: 213
edited 2013-10-04 in NAV/Navision Classic Client
Hi Mibuso.com World - hope all well :D !

Wrote a routine in NAV that kills idle user processors if they surpass an hour of inactivity. One admin user logs in and runs this routine under a job queue (in NAV Client not a NAS routine). This routine works great 99% of the time but every now and again the admin user gets the error...

This message is for C/AL programmers:

The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message:
User does not have permission to use the KILL statement.

The User resets the Job Queue and it works perfectly again until the above error happens again! This routine runs for weeks with no problems and then the above happens - any suggestions?

With thanks
Big D signing off!

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Without knowing the answer why your issue happens, why don't you run the script in SQL Agent? That's much easier and saves you a Navision user.
    Marije Brummel | Freelance Business Central Specialist
  • Big_D
    Big_D Member Posts: 213
    Thanks for the advice Mark - will look into.

    The routine isn't using NAS or an additional user - as I customised the routine to run the Job Queue when the admin user logs into the NAV client.

    With thanks
    Big D signing off!

Categories