The 16th tip of DB Query Analyzer
----
SQL Schedule will be executed even DBMS has ever been down in 6.02
Ma Genfeng
(Guangdong Unitoll Services incorporated, Guangzhou 510300)
Abstract The latest version of DB Query Analyzer is 6.02. In 6.02, if yous elected the option ‘SQL Schedule Reconnect’ in window configurations, theSchedule SQL scripts will be executed as long as the Database Server is in use,even though the Database Server had been down.
As I said in the interview with ChineseSystem Development Net, if I have time what I want to do is to realize the reconnection to DBMS in SQL Schedule Function even DBMS has ever been down. Today, I am very glad to realize this function.
Key words DB Query Analyzer
1 Brief introduction of DB Query Analzyer
DB Query Analyzer is presented by Master Genfeng, Ma from Chinese Mainland. It has English version named ‘DB Query Analyzer’ and Simplified Chinese version named
vcD48cD5EQiBRdWVyeSBBbmFseXplciBpcyBvbmUgb2YgdGhlIGZldyBleGNlbGxlbnQgQ2xpZW50IFRvb2xzIGluIHRoZSB3b3JsZCBmb3IgaXRzoa9wb3dlcmZ1bCBmdW5jdGlvbiwgZnJpZW5kbHkgaW50ZXJmYWNlLCBlYXN5IG9wZXJhdGlvbiBhbmQgYXBwbGljYWJpbGl0eSB0byBldmVyeSBwcm9kdWN0aW9uIG9mIFJEQk1TLjwvcD48cD5JdCBsZXRzIHlvdSBxdWVyeSBPREJDIGRhdGFzb3VyY2VzLCBhdXRob3IgU1FMIHNjcmlwdHMgYW5kIHF1ZXJpZXMsIHJldHVybiBxdWVyeSByZXN1bHRzIHRvIGEgZ3JpZCBvciBmcmVlLWZvcm0gdGV4dCBvciBhIGZpbGUsIHJldHJpZXZlIE9EQkMgZHJpdmVyIGluZm9ybWF0aW9uLCBleGVjdXRlIG11bHRpcGxlIFNRTCBzY3JpcHRzIG9yIHN0b3JlZCBwcm9jZWR1cmVzIHNpbXVsdGFuZW91c2x5LCBhbmQgbW9yZS48L3A+PHA+PHN0cm9uZz4gPC9zdHJvbmc+PC9wPjxwPjxzdHJvbmc+QWNoaWV2ZW1lbnQgb2YgREIgUXVlcnkgQW5hbHl6ZXI8L3N0cm9uZz48L3A+PHA+SW50aGUgTmV3IHByb2R1Y3RzICZhbXA7IFRvb2xzIHJldmlld3Mgb2YgcHJvZ3JhbW1lciBzZWNvbmQgaXNzdWUgb2YgMjAwNywgREIgUXVlcnkgQW5hbHl6ZXIgaGFkIGJlZW4gc3Ryb25nbHkgcmVjb21tZW5kZWQuPC9wPjxwPk5vdyB0aGUgU2ltcGxpZmllZCBDaGluZXNlIHZlcnNpb24gb2YgREIgUXVlcnkgQW5hbHl6ZXIgaXMgdGhlIHRvcCA1MCBkYXRhYmFzZSBhcHBsaWNhdGlvbiBzb2Z0d2FyZSBpbiB0aGUgZmFtb3VzIHNvZnR3YXJlIHdlYnNpdGUgaHR0cDovL3hpYXphaS56b2wuY29tLmNuL2Rvd25sb2FkX29yZGVyL3N1Yl81NTAuaHRtbC4gSW4gbW9zdCBjYXNlIGl0IGxpZXMgdGhlIHRvcCAxMCBhbmQgaXQgaGFzIGJlZW4gZG93bmxvYWQgbW9yZSB0aGFuIDEwMCwwMDAgdGltZXMuPC9wPjxwPjxzdHJvbmc+NzEgdGVjaG5pY2FsIGFydGljbGVzIDwvc3Ryb25nPmFib3V0IERCIFF1ZXJ5IEFuYWx5emVyIGhhdmUgYmVlbiBwdWJsaXNoZWQgb3IgYmVlbiBwdWJsaXNoaW5nIGluIGNvbXB1dGVyIGpvdXJuYWwsIEJBSURVIExpYnJhcnksIHRoZSBDU0ROIHJlc291cmNlIG9yIG15IGZvdXIgYmxvZy13ZWJzaXRlLjwvcD48cD4gPC9wPjxwPjxzdHJvbmc+QSBraW5kIHJlbWluZDwvc3Ryb25nPjwvcD48cD5CZWNhdXNlIFdpbjcvV2luOC9XaW5kb3dzIDIwMTAgc3RhcnQgdG8gc2VsZWN0IKGuL6GvICBhcyB0aGUgZGVmYXVsdCBzZXBlcmF0b3IgY2hhcmFjdGVyIGJldHdlZW4gc2hvcnQgZGF0ZS4gVGhpcyB3aWxsIHJlc3VsdCBpbiBhbiBlcnJvciB3aGlsZSBydW5uaW5nIERCIFF1ZXJ5IEFuYWx5emVyLGluY2x1ZGluZyBFbmdsaXNoIHZlcnNpb24goa5EQiBRdWVyeSBBbmFseXplcqGvIGFuZCBTaW1wbGlmaWVkIENoaW5lc2UgdmVyc2lvbiA8aW1nIHNyYz0="https://www.cppentry.com/upload_files/article/57/1_avtxh__.jpg" alt="\" />.
I will solve this BUG in DB Query Analyzer 6.03. In order to use DB Query Analyzer properly,please set ‘-‘ as the default setting of short date in Win7.
2 6.02 version new characteristic
The latest version of DBQuery Analyzer is 6.02.
In 6.02, if you selected the option ‘SQLSchedule Reconnect’ in window conf