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.
Execute Query:
Copy and Paste the SQL Script, Then Submit the Query
Review Results:
After the query execution is complete, the results will be displayed in the Query Builder interface.
Explore more
Thank you for taking the time to explore data-related insights with me. I appreciate your engagement.
Top comments (0)