This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Have your say in shaping JMP's future by participating in the new JMP Wish List Prioritization Survey
Choose Language Hide Translation Bar
matteo_patelmo
matteo_patelmo
Level IV

How to stop an SQL query

2 hours ago (22 views)

Hello, I'm looking for a to stop a SQL query running in background from JSL, to close a script neatly in case the user wants to exit before the query is completed.

 

I am using JMP 18.0.1.

 

thanks 

Matteo

0 Kudos
1 REPLY 1
jthi
Super User jthi
Super User

Re: How to stop an SQL query

2 hours ago (17 views)  |  Posted in reply to message from matteo_patelmo 07-11-2024

View / Running Queries -> Select query, press stop and hope for the best

jthi_0-1720718930128.png

No cancel commands here https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/sql-messages.shtml

 

From https://www.jmp.com/support/help/en/18.0/#page/jmp/sql-functions.shtml

jthi_1-1720719266351.png

So you might want to contact JMP Support about how JMP handles situations where user closes JMP before the background query finishes (does it just leave running query without any cancel message to database and let database manage with the open query? hopefully not). Post back if you get a good answer from JMP Support

-Jarmo
0 Kudos