NASSSQL JOBQUEU STOP

andy76
andy76 Member Posts: 616
edited 2011-12-21 in NAV/Navision Classic Client
Hello everybody,

I ask you how it is possibile to stop a scheduled job that is a report that takes more hours executed by NASSQL.
I tried to stop the service NASSQL by snapin but nothing happens and the job continues running...

Thank you

Comments

  • andy76
    andy76 Member Posts: 616
    The report reads an enormous text file and write data into NAV locking other tables and users.
    I want to stop it but don't want to loose data or invalidate the database.
    Could I kill the session of NASSQL user by SQL?

    Thank you
  • kriki
    kriki Member, Moderator Posts: 9,135
    The easiest is killing the session from NAV=>File=>Database=Info=>Sessions :find your NAS and delete it from the form.

    Small detail:
    When you kill a session that has been writing a lot of data in 1 big transaction, that needs to be undone and can take a lot of time.

    [Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • bbrown
    bbrown Member Posts: 3,268
    When you "stop" a service, you are not actually stopping the service. Rather you are issueing a stop request. The service wil complete its current task before responding to your request and stopping. That's why the job keeps running.
    There are no bugs - only undocumented features.

Categories