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

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Alan,
    Another alternative might be to look at Extended Store Procedure to
be Called from the SQL Server. 

    Since your backend is in SQL server may be worth a look. 

HTH 
Datta. 
--- John Willson <jwillson@dssltd.com> wrote:

> 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
> 



                
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush

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