# Notification on SQL completion **URL:** \ **Category:** Idea Pond\ **Created:** [March 15, 2021, 6:26pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391 "2021-03-15T18:26:30Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![johnsolomon](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@johnsolomon](https://forums.toadworld.com/u/johnsolomon)\ **Post date:** [March 15, 2021, 6:26pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/1 "2021-03-15T18:26:30Z")
How to set the feature where I can know that my SQL has completed. I often run large queries that take several minutes or hours and have no way of knowing when complete other than periodically checking the toad window. Is there a setting I'm missing for some sort of notification or toaster I can turn on? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 15, 2021, 6:32pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/2 "2021-03-15T18:32:48Z")
If you look in the lower right corner of Toad, there is an animation that runs when a threaded query is still executing. So assuming that you only have one long-running SQL, you could just glance down there to see if it stopped. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 15, 2021, 6:40pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/3 "2021-03-15T18:40:18Z")
Another Option is: Main menu: View -\> Query Viewer. You could just leave that window open. You can click the Toad icon on top-left as shown below to pop the window outside of Toad, then put it someplace where it won't get in the way and you can just look in the Status column to see when it finishes. ![image](https://global.discourse-cdn.com/quest/original/2X/5/52840f37c824b06f461d73c60a2920229be6b02e.png) ---
**Author:** ![johnsolomon](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@johnsolomon](https://forums.toadworld.com/u/johnsolomon)\ **Post date:** [March 16, 2021, 3:07am UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/4 "2021-03-16T03:07:28Z")
Hi, Thanks for the information. the solution is not the one which I am looking for. I don't want to keep watching the toad window to check the status. This option was there in previous versions. ---
**Author:** ![johnsolomon](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@johnsolomon](https://forums.toadworld.com/u/johnsolomon)\ **Post date:** [March 16, 2021, 3:17am UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/6 "2021-03-16T03:17:25Z")
![toad_file](https://global.discourse-cdn.com/quest/original/2X/0/01491f5f3a5d44fc4afee0c34a5d7e44910c4620.jpeg) Looking for marked kind of notification. this notification will appear when I am working on another application. I have taken the screen shot from my old version of TOAD ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 16, 2021, 12:44pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/7 "2021-03-16T12:44:43Z")
I had no idea Toad did that before. This was an unintentional change, due to an intentional change for something else. You can restore old behavior by closing Toad, and adding this under the [SETTINGS] section of Toad.ini: MainFormOnTaskBar=0 There are some [directions here](https://forums.toadworld.com/t/toad-editor-behaviour-copy-paste-ctrl-chars/50501/23) on how to find Toad.ini I have logged this as a bug in our internal bug tracking system and will hopefully fix for version 14.2. -John ---
**Author:** ![johnsolomon](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@johnsolomon](https://forums.toadworld.com/u/johnsolomon)\ **Post date:** [April 13, 2021, 1:00pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/8 "2021-04-13T13:00:09Z")
> [@JohnDorlon](#): > > MainFormOnTaskBar=0 Thanks you very much John. Hope changing the ini setting will not effect any other performance issues. ---
**Author:** ![johnsolomon](https://avatars.discourse-cdn.com/v4/letter/j/919ad9/32.png) [@johnsolomon](https://forums.toadworld.com/u/johnsolomon)\ **Post date:** [April 13, 2021, 1:02pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/9 "2021-04-13T13:02:13Z")
Could you inform what is the expected release date for 14.2? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 13, 2021, 1:05pm UTC](https://forums.toadworld.com/t/notification-on-sql-completion/52391/10 "2021-04-13T13:05:29Z")
The 14.2 beta (with this bug fixed) is available now. You can get it [here](https://forums.toadworld.com/t/toad-for-oracle-14-2-beta/41283). Most of our changes in Toad have been bug fixes, so I don't think the beta is "risky". You can see the change log by scrolling down on that page. The official release date for 14.2 will be in June.