The R statistical program along with the qcc package fits your specified needs (and it is hard to beat the price):
- There are several packages for interfacing with databases,
RODBC
being a common and useful one on MS windows. - You can leave it on as long as you want, you can program a regular event loop to check for new data and run a new set of charts and notifications if there is new data.
- The
mail
andsendmailR
packages were designed to automatically send e-mails. - It produces the standard SPC charts, these can go to the screen or a file to be sent out.
- You can program your own tests for out of control signals
- Full programming language with common (and uncommon) statistics so you can proproccess you data in many ways to reduce dimension.
- You can have multiple instances running on multiple or a single computer, each processing for a single department, or you can combine it all into one script to run for all the departments.