PRCS_PRINT_SCHEDULE_HTML_REPORT

This service operation retrieves an HTML formatted report displaying all items in a job or jobset as defined in the Scheduled Jobset Definition component.

Request Message: PRQ_PRINTSCHEDULEHTMLREPORT_REQ

Element Name Description

MainSchedName

Specifies the name of the jobset schedule.

MainJobName

Specifies the name of job within the jobset schedule.

PrintJobTree

Specify whether to have the job tree displayed in the HTML report. This parameter takes a string value:

  • 1 to display the tree.

  • 0 to hide the tree.

Note: The default value is 1.

PrintDistList

Specify whether you want the list of Users and Roles who will be the recipient of a report generated for a job item displayed in the HTML report. This parameter takes a string value:

  • 1 to display the list.

  • 0 to hide the list.

Note: The default value is 0.

PrintNotifyList

Specify whether you want the list of Users and Roles who will be notified for the status of a job item displayed in the HTML report. This parameter takes a string value:

  • 1 to display the list.

  • 0 to hide the list.

Note: The default value is 0.

PrintMessageList

Specify whether you want the messages that will be emailed upon completion of a job item displayed in the HTML report. This parameter takes a string value:

  • 1 to display the list.

  • 0 to hide the list.

Note: The default value is 0.

PrintParamList

Specify whether you want the parameter list for a job item displayed in the HTML report. This parameter takes a string value:

  • 1 to display the list.

  • 0 to hide the list.

Note: The default value is 0.

Example Request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:prq="http://xmlns.oracle.com/Enterprise/Tools/schemas/PRQ_PRINT_SCHEDHTMLREPORT_REQ.VERSION_1">
   <soapenv:Header/>
   <soapenv:Body>
      <prq:PrintScheduleHTMLReport>
         <MainSchedName>sct</MainSchedName>
         <MainJobName>3SQR</MainJobName>
         <PrintJobTree>1</PrintJobTree>
         <PrintDistList>1</PrintDistList>
      </prq:PrintScheduleHTMLReport>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: PRQ_PRINTSCHEDULEHTMLREPORT_RES

Element Name Description

HTMLReport

Returns HTML report.

Example Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <prq:PrintScheduleHTMLReportResponse xsi:schemaLocation="http://xmlns.oracle.com/Enterprise/Tools/schemas/PRQ_PRINT_SCHEDHTMLREPORT_RES.VERSION_1 PRQ_PRINT_SCHEDHTMLREPORT_RES.VERSION_1.xsd" xmlns:prq="http://xmlns.oracle.com/Enterprise/Tools/schemas/PRQ_PRINT_SCHEDHTMLREPORT_RES.VERSION_1">
         <HTMLReport><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Job Report</TITLE>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<STYLE type=text/css>
.PSHEADER {BACKGROUND-COLOR: rgb(51,51,153); COLOR: rgb(255,255,255); FONT-FAMILY: "Arial","sans-serif"; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-WEIGHT: bold}
.PSEVENROW {BACKGROUND-COLOR: rgb(255,255,255); COLOR: rgb(0,0,0); FONT-FAMILY: "Arial","sans-serif"; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-WEIGHT: normal}
.PSODDROW {BACKGROUND-COLOR: rgb(226,226,226); COLOR: rgb(0,0,0); FONT-FAMILY: "Arial","sans-serif"; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-WEIGHT: normal}
</STYLE>
<META content="MSHTML 203.0.113.240" name=GENERATOR></HEAD>
<BODY>
<img src="%IMAGE(PT_JOB_EXPANDED)" height='12' width='15' border='0' />
<span class='PSTEXT' ><strong>sct</strong></span><br />
<img src="%IMAGE(PSTREEMGR_ENDCONNECT)" height='17' width='15' border='0' />
<img src="%IMAGE(PT_JOB_EXPANDED)" height='12' width='15' border='0' />
<span class='PSTEXT' ><strong>3SQR</strong></span><br />
<img src="%IMAGE(PT_PIXEL)" width='15' height='1' />
<img src="%IMAGE(PSTREEMGR_CONNECT)" height='17' width='15' border='0' />
<img src="%IMAGE(PT_JOB_PROCESS)" height='12' width='15' border='0' />
<span class='PSTEXT' >1  XRFIELDS:  Cross Reference Field Listing (SQR Report)</span><br />
<img src="%IMAGE(PT_PIXEL)" width='15' height='1' />
<img src="%IMAGE(PSTREEMGR_CONNECT)" height='17' width='15' border='0' />
<img src="%IMAGE(PT_JOB_PROCESS)" height='12' width='15' border='0' />
<span class='PSTEXT' >2  XRFMENU:  Menu Listing Report (SQR Report)</span><br />
<img src="%IMAGE(PT_PIXEL)" width='15' height='1' />
<img src="%IMAGE(PSTREEMGR_ENDCONNECT)" height='17' width='15' border='0' />
<img src="%IMAGE(PT_JOB_PROCESS)" height='12' width='15' border='0' />
<span class='PSTEXT' >3  XRFRCFL:  Cross Reference - Records and (SQR Report)</span><br />
<p> </p><TABLE cellPadding=2 cellSpacing=0 width="100%">
  <TBODY>
  <TR>
    <TD>
     <TABLE border=1 cellPadding=3 cellSpacing=0 width="100%">
        <TBODY>
    <tr>
      <th class='PSHEADER' colspan="10" bordercolor=rgb(51,51,153)><p align="left">Job Name: 3SQR - SQR Multi-process Job</p></th>
    </tr>
    <tr>
      <th class='PSHEADER' colspan="3" bordercolor=rgb(51,51,153)><p align="left">Mode: Serial</p></th>
      <th class='PSHEADER' colspan="7" bordercolor=rgb(51,51,153)> </th>
    </tr>
    <tr>
    <tr>
      <th class='PSHEADER' width="5%">Seq.</th>
      <th class='PSHEADER' width="10%">Process Name</th>
      <th class='PSHEADER' width="15%">Description</th>
      <th class='PSHEADER' width="10%">Process Type</th>
      <th class='PSHEADER' width="10%">Run Control ID</th>
      <th class='PSHEADER' width="5%">Type</th>
      <th class='PSHEADER' width="8%">Output 
Format</th>
      <th class='PSHEADER' width="10%">Destination</th>
      <th class='PSHEADER' width="8%">Server Option</th>
      <th class='PSHEADER' width="5%">Run Time</th>
   </tr>
   <tr>
      <td class='PSEVENROW'  align="center" width="5%">1</td>
      <td class='PSEVENROW'  width="10%">XRFIELDS</td>
      <td class='PSEVENROW'  width="15%">Cross Reference Field Listing</td>
      <td class='PSEVENROW'  align="center" width="10%">SQR Report</td>
      <td class='PSEVENROW'  align="center" width="5%">t1</td>
      <td class='PSEVENROW'  align="center" width="5%">Web</td>
      <td class='PSEVENROW'  align="center" width="8%">Acrobat (*.pdf)</td>
      <td class='PSEVENROW'  align="center" width="10%">Distribution List</td>
      <td class='PSEVENROW'  align="center" width="8%">Any Server </td>
      <td class='PSEVENROW'  align="center" width="5%"> </td>
   </tr>
    <tr>
        <td class='PSEVENROW'  colspan="2"> </td>
        <td class='PSEVENROW'  colspan="8">
        <p><strong>Distribution List:</strong></p>
        <table  border="1" cellpadding="3" cellspacing="0"  bordercolor="#CCCCCC">        <tr>
        <td class='PSEVENROW' ><strong>Type</strong></td>
        <td class='PSEVENROW' ><strong>Name</strong></td>
        </tr>
    <tr>
      <td class='PSEVENROW' >User      </td>
      <td class='PSEVENROW' >VP1      </td>
    </tr>
        </table>
    </td></tr>
   <tr>
      <td class='PSODDROW'  align="center" width="5%">2</td>
      <td class='PSODDROW'  width="10%">XRFMENU</td>
      <td class='PSODDROW'  width="15%">Menu Listing Report</td>
      <td class='PSODDROW'  align="center" width="10%">SQR Report</td>
      <td class='PSODDROW'  align="center" width="5%">t1</td>
      <td class='PSODDROW'  align="center" width="5%">Web</td>
      <td class='PSODDROW'  align="center" width="8%">Acrobat (*.pdf)</td>
      <td class='PSODDROW'  align="center" width="10%">Distribution List</td>
      <td class='PSODDROW'  align="center" width="8%">Any Server </td>
      <td class='PSODDROW'  align="center" width="5%"> </td>
   </tr>
    <tr>
        <td class='PSODDROW'  colspan="2"> </td>
        <td class='PSODDROW'  colspan="8">
        <p><strong>Distribution List:</strong></p>
        <table  border="1" cellpadding="3" cellspacing="0"  bordercolor="#CCCCCC">        <tr>
        <td class='PSODDROW' ><strong>Type</strong></td>
        <td class='PSODDROW' ><strong>Name</strong></td>
        </tr>
    <tr>
      <td class='PSODDROW' >User      </td>
      <td class='PSODDROW' >VP1      </td>
    </tr>
        </table>
    </td></tr>
   <tr>
      <td class='PSEVENROW'  align="center" width="5%">3</td>
      <td class='PSEVENROW'  width="10%">XRFRCFL</td>
      <td class='PSEVENROW'  width="15%">Cross Reference - Records and</td>
      <td class='PSEVENROW'  align="center" width="10%">SQR Report</td>
      <td class='PSEVENROW'  align="center" width="5%">t1</td>
      <td class='PSEVENROW'  align="center" width="5%">Web</td>
      <td class='PSEVENROW'  align="center" width="8%">Acrobat (*.pdf)</td>
      <td class='PSEVENROW'  align="center" width="10%">Distribution List</td>
      <td class='PSEVENROW'  align="center" width="8%">Any Server </td>
      <td class='PSEVENROW'  align="center" width="5%"> </td>
   </tr>
    <tr>
        <td class='PSEVENROW'  colspan="2"> </td>
        <td class='PSEVENROW'  colspan="8">
        <p><strong>Distribution List:</strong></p>
        <table  border="1" cellpadding="3" cellspacing="0"  bordercolor="#CCCCCC">        <tr>
        <td class='PSEVENROW' ><strong>Type</strong></td>
        <td class='PSEVENROW' ><strong>Name</strong></td>
        </tr>
    <tr>
      <td class='PSEVENROW' >User      </td>
      <td class='PSEVENROW' >VP1      </td>
    </tr>
        </table>
    </td></tr>
</TBODY></TABLE>
<p> </p>    </TD></TR></TBODY></TABLE>
<BR></BODY></HTML>]]></HTMLReport>
      </prq:PrintScheduleHTMLReportResponse>
   </soapenv:Body>
</soapenv:Envelope>