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;
select max(db_update) from db_transfer;
Have you looked at building a report and sending that?
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?
Did you setup the MailServer configuration in the QMC?