How to Get the List of SAP BusinessObjects Schedules using Query Builder

#python #sap #sapbo #querybuilder

Introduction

To retrieve a list of SAP Business Objects schedules using Query Builder, you can execute a query against the repository database where the scheduling information is stored. The repository database typically contains tables with information about schedules, jobs, and other related objects. Here are the general steps:

Access and Log in to Query Builder:

To access Query Builder directly, log in to Query Builder using your SAP Business Objects credentials by entering the following URL in your web browser:

http://localhost:port/AdminTools/querybuilder/ie.jsp

After replacing localhost:host you will see the login page:

Build Query:

SELECT 
    SI_ID, 
    SI_NAME, 
    SI_SCHEDULEINFO.SI_SCHEDULE_TYPE, 
    SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS, 
    SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NTHDAY, 
    SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_MONTHS 
FROM 
    CI_INFOOBJECTS 
WHERE 
    SI_SCHEDULE_STATUS != 8 AND SI_RECURRING = 1

the script retrieves specific columns (SI_ID, SI_NAME, and scheduling-related information) from the CI_INFOOBJECTS table for objects that meet the specified conditions. The conditions filter out objects with a schedule status of 8 and include only recurring objects.