DEV Community

Cover image for How to Get the List of SAP BusinessObjects Schedules using Query Builder
Luca Liu
Luca Liu

Posted on • Updated on

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

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
Enter fullscreen mode Exit fullscreen mode

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

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
Enter fullscreen mode Exit fullscreen mode

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.

Execute Query:

Copy and Paste the SQL Script, Then Submit the Query

Image description

Review Results:

After the query execution is complete, the results will be displayed in the Query Builder interface.

Image description


Explore more

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement.

🚀 Connect with me on LinkedIn

🎃 Connect with me on X

🌍 Connect with me on Instagram

Top comments (0)