| Re: Sql results as email alerts
Pradeepa,
You can search for crontabs and shell scripts in google and there are lots of guidance for this. Cron jobs needs to be scheduled in your app servers and system admins will be aware of this script files (.sh files if it is a UNIX one).
Normally the output of the cron jobs will be of a CSV format and you have to the format the sql query for that.
Kindly revert if your are not clear with the same.
Regards
Arun. |