We have an SQR job/program that has been published to the Portal.
The main purpose of the job/program is to query an Oracle table and
send email to individuals based on the query results. The output file
(s) contain the body of each email that is sent and is used as
confirmation of the individual email sent by the administration team.
When that SQR job/program is executed manually through Portal (end
user selects the SQR job/program) the program runs successfully,
emails are sent and the output files are 'pubished' to the Portal
(html and spf files). However, when the same SQR job/program is
executed via Scheduler it runs successfully, sends email but no
output files are created in Portal.
Is this normal? Can the Scheduled SQR job/program be 'enabled' to
produce the same output files in Portal that are generated when it is
executed manually?
We are using Brio Performance Suite on NT - Portal 7.0.3, SQR 6.2.1.
Any help is appreciated.
Thanks,
Bernie