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

["John Willson" <jwillson@dssltd.com>]

Hi Alan, here is an example using UNIX..

begin-procedure send_email
  if $sqr-platform = 'UNIX'
      let $os_command_line = 'mailx -s "'||
                             'execution failure of sqr program: '||
                             $program_name_out||
                             '" '||
                             $email_address||
                             ' < '||
                             $email_notification
      call system using $os_command_line #status
  end-if
end-procedure ! send_email

This is developed from Darrin Miller's Harnessing SQR.
http://www.sqrevangelism.com   If you are running XP or W2K, then modify the
platform and os_command_line to call Outlook. (msimn.exe  or mapi etc.).

John Willson

----- Original Message ----- 
From: "Lim, Alan" <alim@calwater.com>
To: <sqr-users@sqrug.org>
Sent: Wednesday, August 25, 2004 6:15 PM
Subject: [sqr-users] Within an SQR program: How to execute a command toemail
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



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