 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Dominik
Joined: 30 Jul 2007 Posts: 36
|
|
Databaseprofile vs Mailsend Problem |
|
Dear Support Team,
I Got Two Problems in our 24x7 Multi-platform Edition (5.1.402)
I want to ask a Oracle DB via SQL for information from a table and want to send them via Email to the Admin. That sounds easy ...
Its possible to send Emails via VAL:
MailSend email_from, email_pwd, email_to_admin, head , ret_val
.. that works fine.
But its not possible to send Emails via JScript in another Job: (Error: Could not connect to SMTP host: xxxxx, port 25; ... refused connect)
Mail.send(email_from, email_pwd, email_to_admin, head , ret_val);
Ok, thatswhy i decided to script in VAL, but now i cant connect to the Database via VAL: ( Profile not found)
DatabaseConnect "OPIS_DWH"
This on the other hand works fine in JScript!
Database.connect("OPIS_DWH");
I found a post in this forum, with a simular problem and you wrote:
<<Please take a look at Upgrade from 24x7 Windows Edition, see section "3. Migrating database connection profiles..."
I did it and i can see the reg entries but it still doesnt work.
I need a solution for one - better for both problems - to combine my wishes.
Thanks a lot.
Dominik
|
|
Mon Oct 07, 2013 10:51 am |
|
 |
Dominik
Joined: 30 Jul 2007 Posts: 36
|
|
|
|
Hi,
i guess the email problem is depends on our virusscan tool. i will see whether i can fix it myself.
Can you please explain a solution how to access to da DB via VAL (Profile not found Error)?
Best regards,
Dominik
|
|
Mon Oct 07, 2013 11:07 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Hi,
To connect to a database from a JAL (Job Automation Language) script, please use DatabaseConnectEx statement.
|
|
Mon Oct 07, 2013 12:54 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|