Re: [sqr-users] Within an SQR program: How to execute a commandto email a report file

[bknoch@hinda.com]

We just use a cheap program called commail.

http://www.xwebware.com/products/commail/readme.html

Basic command line mailer.  We use call system to call it.  Seems to work
fine.  We use it to email notifications of program failures, missing files
for interfaces and to send spreadsheets out that are generated bi-weekly by
sqr reports.

We're using SQL Server 7 on windows NT.




|---------+-------------------------------------------->
|         |           "Lim, Alan" <alim@calwater.com>  |
|         |           Sent by:                         |
|         |           sqr-users-bounces+bknoch=hinda.co|
|         |           m@sqrug.org                      |
|         |                                            |
|         |                                            |
|         |           08/25/2004 07:15 PM              |
|         |           Please respond to "This list is  |
|         |           for discussion about the SQR     |
|         |           database reporting    language   |
|         |           from Hyperion Solutions."        |
|         |                                            |
|---------+-------------------------------------------->
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       To:       <sqr-users@sqrug.org>                                       
                 |
  |       cc:                                                                   
                 |
  |       Subject:  [sqr-users] Within an SQR program: How to execute a command 
to    email a    |
  |        report file                                                          
                 |
  
>----------------------------------------------------------------------------------------------|




Hello,

I am running SQR for Peoplesoft version 4.3.4.  The Peoplesoft
application is HR/Payroll version 7.51 running on PeopleTools 7.61.  Our
database is MS SQL Server 2000 version 8.00.

My question is :  Can you execute a command inside an SQR program that
will initiate MS Outlook, take a report file, and email to a specified
recipient?  If the answer is yes, what is the structure of the syntax,
or do you have sample code?

Thank you very much.

Regards,
Alan Lim
California Water Services, Inc.
San Jose, CA

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



This communication is for the exclusive use of addressee and may contain
confidential, proprietary or privileged information which may be used
exclusively for its intended purpose. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited.  If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication, and
destroy all copies.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users