NASSSQL JOBQUEU STOP

andy76

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

andy76

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

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]

bbrown

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.