[Pradeepa]

Hi,

Currently there are a few sql's that are used for daily check on the system.These sql's are currently run manually (approx thrice in a day) and results distributed to concerned ppl.
I would like to automate this by setting up a recuring task to excute them at specific intervals and send out the result via automation agent to the respective contact.

Can some one suggest me how I can draft the results of the sql in an email formate?

PS: I was thinking on the lines of similar to a pickup notification with the sql data !

Thanks,
Pradeepa.