SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Databaseprofile vs Mailsend Problem

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Databaseprofile vs Mailsend Problem
Author Message
Dominik



Joined: 30 Jul 2007
Posts: 36

Post Databaseprofile vs Mailsend Problem Reply with quote
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 View user's profile Send private message
Dominik



Joined: 30 Jul 2007
Posts: 36

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Hi,

To connect to a database from a JAL (Job Automation Language) script, please use DatabaseConnectEx statement.
Mon Oct 07, 2013 12:54 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.