PeopleSoft Application Engine Scheduled Query

[Anon Anon]

Good morning,

 

I am attempting to migrate a task from our previous scheduler (Tidal) into Dollar Universe that runs a Scheduled Query within PeopleSoft 9.2 that in turn e-mails a distribution list setup within PeopleSoft.

 

I have setup the jobs in $U the same as it was in our previous scheduler however it does not work. 

 

Below is how I have it setup - The OUTDEST is my issue; it was "Distribution List" (no quotes) in Tidal so I attempted that in $U which didn't seem to like the space between the values.  I've tried with quotes, without, no space, only the word Distribution...no luck.

 

Can anyone assist with the setup?

 

UxType - Application Engine

UxName - PSQUERY

UxOprID - PS_JOBS

UxRunCtrlId - JOB_EE_SPV

UxDbaseUser - [db username]

UxDbaseSid - [db ID]

PSCHED - PSNT

PSSERV - PSNT

OUTDESTTYPE - 6

OUTDESTFORMAT - 14

OUTDEST - (This is the field I'm having problems with.  I don't know what to put here to tell the Scheduled Query to output to the distribution list associated with the Query)

 

Thanks,
Terry Nixon

[Anon Anon]

Hello,

 

What I see in the documentation is that for OUTDESTTYPE can have the following values:

• 0  Any
• 1  No output
• 2  File
• 3  Printer
• 4  Window
• 5  e-mail
• 6  Web
• 7  Default

In your case, I see the the value is 6. So it means Web... then for Web.

 

Based on your post it seems that you want actually an email distribution list, right? (so would it be 5 instead of 6 ?)

 

Regards

[Anon Anon]

However if I use 5 to have Dollar Universe send the emailed report I must maintain the email list within $U itself, correct?  This also puts the report in the actual e-mail instead of a link to an internal site which is desired due to security. 

 

PeopleSoft Scheduled Queries have built in Distribution List that are maintained by the Business Unit of our company.  This built in distribution sends an e-mail with a secure link to the report within PeopleSoft requiring login to view the report. 

 

Our previous Enterprise Scheduler (TIDAL) was capable of sending the same values as $U.  In the OUTDESTTYPE for TIDAL we would have 6 with OUTDESTFORMAT being 14 and OUTDEST with simply the phrase - DISTRIBUTION LIST. That phrase triggered PeopleSoft to use it's default email distribution list.

 

 

$U however doesn't like the phrase DISTRIBUTION LIST within the OUTDEST field.  It complains about the spaces.  I've tried putting the phrase together without spaces, wrapping it in " " with no success. 

 

PeopleSoft is capable of accepting the phrase DISTRIBUTION LIST as the proper command, however I seem to be dealing with a simply syntax issue that $U either cannot handle or the proper way to send the phrase is unknown...

 

Thank you,

Terry Nixon

[Anon Anon]

Hi,

 

Actually, I'm not an expert with the manager for PeopleSoft. I'm going to check if someone can help us on that.

 

Regards