Thread: Automation
I need to create reports every month for the marketing people...
I need suggestion on how to automate that...
I thought of querying but it will make the mail server slow and cause it to hang....
Hope you can help me... Thanks is adance..
On Fri, 13 Oct 2000, Jerome Macaranas wrote: > I need to create reports every month for the marketing people... > > I need suggestion on how to automate that... > > I thought of querying but it will make the mail server slow and cause it to hang.... > > Hope you can help me... Thanks is adance.. Pick a language which has a libpq interface (C, C++, perl, ...) and write your queries with that program/interface to PostgreSQL. Have the results of the queries either sent to the appropriate printer or mailed from within the program. You can have cron execute the program/script (as a particular user if needed) whenever you want. Every 4th sunday at 3:03 am, whatever. Perl has modules for talking to PostgreSQL and mail, which takes a lot of work out of it, but any language will do. As far as when it executes, see the man page on how to set up cron for your purposes. Gord Matter Realisations http://www.materialisations.com/ Gordon Haverland, B.Sc. M.Eng. President 101 9504 182 St. NW Edmonton, AB, CA T5T 3A7 780/481-8019 ghaverla @ freenet.edmonton.ab.ca 780/993-1274 (cell)