Skip to Content
avatar image
Former Member

What field in CI_Infoobjects indicates a instance succeeded?

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 30, 2014 at 02:54 AM

    Hi Brenda,

    In the where clause, also include SI_SCHEDULE_STATUS=1.

    The results will bring all successful instances.


    Schedule Status:

    Thanks,

    Prithvi


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 06:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded