on 12-30-2014 1:03 AM
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 |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.