BusinessObjects Board

All Scheduler List

Author: Sunder Ramani

Hi All,

Author notes

Sunder Ramani
BO Schedulers.xls (313.0 KB)

sunder.ramani (BOB member since 2009-05-27)

Moderator note:
Approved, and moved to BOB’s Downloads.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

This is awesome…works great! Would it be possible to add a few fields…such as Days of the Week or Month and Parameter Settings?

MFleming :us: (BOB member since 2011-06-07)

it’s Compile error. Please upload updated file.

gmoorthyp (BOB member since 2005-08-29)

Thanks MFleming, will try to upload updated utility soon.


sunder.ramani (BOB member since 2009-05-27)

Hi gmoorthyp,

Please share error details, this will help to identify cause.

One of the reason for compile error occur because of missing reference, try to add following references:
Crystal Enterprise framework library 12.0
Crystal Enterprise infostore library 12.0
BusinessObjects 12.0 Object library 12.0

Let me know if this still doesn’t work.


sunder.ramani (BOB member since 2009-05-27)


Can you please help me as how to add the above mentioned libraries ?

I got this compile error : "Object library feature not supported ".

Thanks a lot


Arun Yadav

binnu23 :india: (BOB member since 2010-05-21)


I do have XI 3.1 client installed on my machine. When running this utility getting the error "Item SI_PSS_SERVICE was not found in the collection.

Please contact Administrator to fix it!"

Can the utility be modified to get the prompt details please.

maresh (BOB member since 2007-07-28)

Hi. I have just tried to use this utility and I get an error message which says

Error. Access denied. You cannot log on to an older version of CMS. Please contact Administrator to fix it.

I am running BO XI R2 and the CMS is version

I do not have an administrator I can get help from. Can anybody please help me?

alisonc (BOB member since 2009-03-23)

1st - thank you for this spreadsheet - it is awesome! All by itself it is handy, but also …

2nd - i’ve been struggling with the SDK syntax for referring to nested properties in a .Net app - this helped me solve my problem more handily than anything to this point. (I think some of my problems were due to changes between versions) Again, thanks!

3rd - to users that are getting errors (such as Maresh), some of these may be due to oddball objects in your system. I was getting an error about si_mail_addresses not being found in the collection - this was due to the report having an e-mail destination, but it was also set to use the job server defaults (a CMS query shows no “si_mail_addresses” for that instance). Yours may be similar. To step around that, look at the VBA in the spreadsheet and add a “Resume Next” so that processing can continue. You might also comment out the message box, too.

sbroam (BOB member since 2006-08-24)

Very usefull already, really helped me tracking down a few schedules from people who already left company

Would be even greater if I could see which report in which folder it uses.

TOMVDW (BOB member since 2009-07-08)


Can you please advise if you are able to solve this one and run the macro?

dsahni (BOB member since 2012-06-04)

Its great help Sunder Ramani
Thanks , I was trying to do same kind of task using vba in my project, only difference is I wanted to list reports from particular universe which are scheduled and schedule include emails.

lax_lambor (BOB member since 2011-09-27)

This retrieves only 1000, is there a way we can get beyond 1000?


dora (BOB member since 2008-04-09)

Hi Dora,

Just use " SELECT top 100000 * FROM … " in your select statement of sql query , it will work.

lax_lambor (BOB member since 2011-09-27)

OMG!!!..It’s really awesome.It worked great.

Thanks for your help .It’s really helpfull.

SANTROL (BOB member since 2012-08-21)

It’s great. Everything works except for Audit Notification / Columns L, M, N on the Excel Worksheet. Do you have any suggestions?

carrollrv (BOB member since 2012-09-18)

I must be misssing someting here from the code.

'Instance Recurrence
        If objScheduleInfo.Properties("SI_SCHEDULE_TYPE") = 8 Then
            Wksht.Cells(RowNum, 4) = "Weekly"
            bolShowCalendarDays = True
        ElseIf objScheduleInfo.Properties("SI_SCHEDULE_TYPE") = 2 Then
            Wksht.Cells(RowNum, 4) = "Daily"
        ElseIf objScheduleInfo.Properties("SI_SCHEDULE_TYPE") = 5 Then
            Wksht.Cells(RowNum, 4) = "Nth Day of Month"
            bolShowCalendarDays = True
        ElseIf objScheduleInfo.Properties("SI_SCHEDULE_TYPE") = 9 Then
            Wksht.Cells(RowNum, 4) = "Calendar"
            bolShowCalendarDays = True

Per my understanding if SI_SCHEDULE_TYPE = 3 means Weekly sceduled reports. But in the code id SI_SCHEDULE_TYPE = 8 then its displaying the weekly type.

Though the code works correctly, I wanted to check what I am missing on SI_SCHEDULE_TYPE = 8 vs 3


dora (BOB member since 2008-04-09)


when I try to use this utility I get an error message saying S_OUTPUTFILES not found contact admin.

Has anybody else faced this? can you help.

Manasi (BOB member since 2004-12-17)

This works great

But I cant capture the emails in cc, it is always empty even if i have selected schedules sending emails as cc.

Can you help?

bulgaru10 :malta: (BOB member since 2006-12-15)