I am attempting to use xmlpserver/services/v2/ScheduleService of the Oracle BI Publisher to schedule a recurring job. Unfortunately, with no examples and no luck with try and error method, I can't schedule a report in a recurring manner, I manage, however, to execute it once. I want to understand what tu put in recurrenceExpression, recurrenceExpressionType, repeatCount, repeatInterval, startDate to make it work. I am looking for a daily execution at n o'clock. Here is the XML :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
<soapenv:Header/>
<soapenv:Body>
<v2:scheduleReport>
<v2:scheduleRequest>
<v2:deliveryChannels>
<v2:ftpOptions>
<v2:item>
<v2:ftpServerName>?</v2:ftpServerName>
<v2:remoteFile>?</v2:remoteFile>
<v2:sftpOption>?</v2:sftpOption>
</v2:item>
</v2:ftpOptions>
</v2:deliveryChannels>
<v2:jobLocale>en_US</v2:jobLocale>
<v2:jobTZ>Etc/UTC</v2:jobTZ>
<v2:mergeOutputOption>false</v2:mergeOutputOption>
<v2:notificationTo>?</v2:notificationTo>
<v2:notifyWhenFailed>true</v2:notifyWhenFailed>
<v2:notifyWhenSkipped>true</v2:notifyWhenSkipped>
<v2:notifyWhenWarning>true</v2:notifyWhenWarning>
<v2:recurrenceExpression>?</v2:recurrenceExpression>
<v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>
<v2:repeatCount>1</v2:repeatCount>
<v2:repeatInterval>86400</v2:repeatInterval>
<v2:reportRequest>
<v2:attributeCalendar>Gregorian</v2:attributeCalendar>
<v2:attributeFormat>Text</v2:attributeFormat>
<v2:attributeLocale>fr</v2:attributeLocale>
<v2:reportAbsolutePath>?</v2:reportAbsolutePath>
<v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>
</v2:reportRequest>
<v2:saveDataOption>true</v2:saveDataOption>
<v2:saveOutputOption>true</v2:saveOutputOption>
<!--Optional:-->
<v2:startDate>2022-09-23T19:07:00Z</v2:startDate>
<v2:userJobName>test_REPORT</v2:userJobName>
</v2:scheduleRequest>
<v2:userID>?</v2:userID>
<v2:password>?</v2:password>
</v2:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>
Many fields in the example are blank to protect sensitive data. Here is the link to the documentation: https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/scheduleservice.htm#BIPDV323