Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I just tried to create a report and send it by email.
Did so by adding email user in distribution.
Works just fina as to send the entire file, but how can i get it to send just a value?
All I want is to send an email containg the load date and lastupdate as values.
load *,now() as loaddate;
sql
select max(db_update) from db_transfer;
BR
Dan
Hope I posted this in the right area
Hi Dan,
Have you looked at building a report and sending that?
Bill
Hi,
Have you try alerts?
Regards
ASHFAQ
Hi Asfaq,
How to use alert?
Thanks
Sorry for not comming back to you on this earlier.
I tried alerts and got it to sort of work.
1: running within developer, ctrl+r, runs and send alert
2: running in qmc by hitting run, runs and send alert
3: scheduling in qmc, runs but do not send alert
Whats up with that?
Dan
Did you setup the MailServer configuration in the QMC?
Bill