Sql results as email alerts

[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.

[arunk]

Re: Sql results as email alerts

Pradeepa,

We have the same requirements sometimes back and I can suggest you two ways of doing this.

1. You can create a cron job (time-based scheduling service in your server) and give the email id's of the distribution list, which will automatically execute the script send the results at any specific time. We can mention the time interval of the execution of sql scripts in the cron file.

2. The second one is you can cofigure an schedule report in OTM itself.

Hope this gives you an idea.

Regards
Arun.

[Pradeepa]

Re: Sql results as email alerts

Arun,

Thankyou for the suggestion.
1. Setting up corn job sounds good to me but I am not aware of how to set the corn jobs up on the servers - will have a study how i can go about this method.
If there is any information you can share on this with me, please let me know.

2. Scheduled reports - I did think of this one but have kept this one of the few options.

Thanks,
Pradeepa.

[arunk]

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.