Christopher_Poullard_6587

How to stop report from emailing individual email and email the report in one email.

Discussion created by Christopher_Poullard_6587 on Jun 1, 2016
Latest reply on Jun 1, 2016 by Christopher_Poullard_6587

I am using the PREP_PROCESS_REPORT and GET_PROCESS_LINE to collect and email the report of my job but the job email each line separately.  How do I script my job to email the whole report without email each line separately. Here's what I have so far.

 

:SET &DEV# = PREP_PROCESS_REPORT(,,,)
:PROCESS &DEV#
:  SET &INFO# = GET_PROCESS_lINE(&DEV#)
:  PRINT &INFO#
:  SET &OUT# = SEND_MAIL('prodservices@vizientinc.com',,'User SQL Audit Report','&info#')
:ENDPROCESS

Outcomes