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: :port/AdminTools/querybuilder/ie.jsp. http://localhost 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 ( , , and scheduling-related information) from the table for objects that meet the specified conditions. The conditions filter out objects with a schedule status of 8 and include only recurring objects. SI_ID SI_NAME CI_INFOOBJECTS 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. Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on . Happy exploring!👋 LinkedIn

The code in this story is for educational purposes. The readers are solely responsible for whatever they build with it.

Walkthroughs, tutorials, guides, and tips. This story will teach you how to do something new or how to do something better.

How to Fetch a List of SAP BusinessObjects Schedules Using Query Builder

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

A Quick Guide to Listing All Measures in Power BI via DAX Studio

20 Herramientas de Inteligencia Empresarial (BI) más Populares en 2020

3 Key Advantages of Open-Source Intelligence

3 Ways You Can Build and Update Websites Using Data Pushes

4 of the Best Ways to Use AI in Business

A Quick Guide to Listing All Measures in Power BI via DAX Studio

20 Herramientas de Inteligencia Empresarial (BI) más Populares en 2020

3 Key Advantages of Open-Source Intelligence

3 Ways You Can Build and Update Websites Using Data Pushes

4 of the Best Ways to Use AI in Business

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps