cancel
Showing results for 
Search instead for 
Did you mean: 

What field in CI_Infoobjects indicates a instance succeeded?

Former Member
0 Kudos

This query returns the date an instance was attempted, but not whether or not it succeeded.

   

select top 5000
SI_ID,
SI_NAME,
si_starttime,
si_endtime
FROM CI_INFOOBJECTS WHERE
si_instance = 1
and si_runnable_object = 0
and si_starttime is not null

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Brenda,

As noted by Prithvi, it is SI_SCHEDULE_STATUS=1.

The same in (the CMS database) cms_infoobjects6 (xi 3.1) and cms_infoobjects7 (BI 4.x) is schedulestatus=3.

-Sid

Former Member
0 Kudos

Hi Brenda,

In the where clause, also include SI_SCHEDULE_STATUS=1.

The results will bring all successful instances.


Schedule Status:

Thanks,

Prithvi