24x7 Scheduler version 3.4.24 DatabaseConnect issue

24x7 Scheduler version 3.4.24 DatabaseConnect issue

Hello.

I have following issue with DatabaseConnectEx statement. When i use it in my .jal file everything works fine, job successfully connects to db and can receive data from DatabaseRetrieve statement etc.

But when i use DatabaseConnectEx in created by myself script in Script Library - i have connection to db only in created script. In that script connection succeeds, i can receive data from DatabaseRetrieve etc, but when script finishes and i return to jal file - connection to db disappears! DatabaseRetrieve throws an error that there is no connection to database.

Is it possible to keep connection during the whole .jal file running, including scripts from script library? Can you tell me what i did not do or what i did wrong?

Thanks a lot!

The scope of both DatabaseConnect and DatabaseConnectEx is limited to the current script only. DatabaseDisconnect is executed implicitly when the script completes and the connection goes out of scope. If you need a connection both in the JAL job script and user-defined JAL statement , you would need to open 2 separate connections, one from each script.

Just a tip, an alternative to using reusable user-defined statements is using external reusable JAL files that are "included" into the main script using @SCRIPT tag.