Pentaho Email Alerting system

Pentaho can used to create  an Alerting  tool using that any kind of report can be triggered using email.

Some use case example,

1. Suppose I want todays sales report to get this report just send email to given email id with specific subject like  “send me todays sales report” After some time (2-3 min) an email with sales report graphical and tabular  as attachment (pdf ,csv, excel ..)will be send to the user.
2. Data base Artifact report form almost any database can be generated and send on demand to the user .

• It can configured to send some alert also
  • if database/table  space is less then 10 %
  • if any specific query is taking longer than expected to execute.
  • Top 10 query by performance.
  • Top 10 table by space used.
• It can configured to load data from any excel sheet(from email attachment) to any database in predefined tables.
•  It configure to execute any batch of shell command directly from email.
• Major advantage of this tool is to get reports/Alerts without logging into any system, everything can be triggered using email from specific id.
• These reports/Alerts can be scheduled to run on any specific time also,