Link to home
Start Free TrialLog in
Avatar of venkatesh Sarivisetty
venkatesh SarivisettyFlag for India

asked on

Java and SQL query mail automation

Need to use the SQL and involve that queries to Java program and send an email to the people , The mail consists of the table what we have gathered from the sql queries as a box and , I will schedule that one in the scheduler and run it every time.

How I can achive this one, as I have only quries not program

Please suggeste
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Sounds like you need JavaMail and SQL.
Avatar of venkatesh Sarivisetty

ASKER

Yes
Any help CEHJ, that would be really helpfull thanks
Could you please post the definition of the table?

describe the_table_name;

Open in new window

(would be the SQL)
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.