How to automate SQL Jobs Status alerts?

[Soniya Singh]

We have a lot of scheduled jobs in sql server and we want to find a solution in any language that will give alerts about the jobs status automatically through mails or through any other way if the job is not succefully executed like if the job get failed or
if the job is taking more time.
What approach should we can follow?

[Rabbit]

By jobs I assume you have integration services. You can turn on logging for those jobs. You can have it insert log records into a table. You can then create a job that will read that table and send out the appropriate e-mails and have it run on a loop.

[PsychoCoder]

You can send email directly from SQL using CDONTS. Microsoft has a good writeup on accomplishing this here