BusinessObjects Board

List of scheduled jobs XIR2

server administration XI Server Discussion
#1

Hi,

Is there a way of creating a list of which reports are scheduled, and which are failed.

Don’t have auditing enabled.

Ideally would like not to use an unsupported macro and use query builder.

Is this possible?

Many Thanks

philipo (BOB member since 2005-07-22)

#2

Philipo,

Check this link: https://bobj-board.org/t/111635

Regards,
Jim

jwaterbury :us: (BOB member since 2007-09-21)

#3

Thanks for update.

Useful link.

Is there anywhere which documents the repository tables and what each of the columns/values mean for scheduling + other useful queries could run via Query Builder/macros.

Many Thanks

philipo (BOB member since 2005-07-22)

#4

Try running this in Query Builder. SI_SChedule_Status = ‘3’ is failed, ‘1’ is sucess, both is total. This is what I ran today, the 06 for hour is for GMT offset.

HTH

select Top 3500 SI_GUID,SI_Owner,SI_NAME,SI_STARTTIME, SI_APS_STARTTIME,SI_STATUSINFO,SI_NextRuntime,SI_ENDTIME
from ci_infoobjects where SI_STARTTIME between ‘2011.12.19.06.00.00 AM’ and ‘2011.12.20.06.00.00 AM’
and SI_SCHEDULE_STATUS in (1,3)
ORDER BY SI_Endtime desc

tmcd :us: (BOB member since 2005-10-02)

#5

Thanks for update.

philipo (BOB member since 2005-07-22)