All Scheduler List

sunder.ramani · Forum Member Joined: 27 May 2009 Posts: 16

Author: Sunder Ramani

Hi All,

Author notes

Marek Chladny · Posted: Tue May 10, 2011 4:56 am Post subject: Re: All Scheduler List

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

MFleming · Forum Member Joined: 07 Jun 2011 Posts: 4

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?

gmoorthyp · Senior Member Joined: 29 Aug 2005 Posts: 88

it's Compile error. Please upload updated file.

sunder.ramani · Forum Member Joined: 27 May 2009 Posts: 16

Thanks MFleming, will try to upload updated utility soon.

Thanks,
Sunder

sunder.ramani · Forum Member Joined: 27 May 2009 Posts: 16

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.

Thanks,
Sunder

binnu23 · Principal Member Joined: 21 May 2010 Posts: 182

Hi,

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

Regards,

Arun Yadav

maresh · Senior Member Joined: 28 Jul 2007 Posts: 65

Hi,

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.

alisonc · Forum Member Joined: 23 Mar 2009 Posts: 5

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 11.5.3.417

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

sbroam · Senior Member Joined: 24 Aug 2006 Posts: 31

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.

TOMVDW · Forum Member Joined: 08 Jul 2009 Posts: 3

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.

dsahni · Forum Member Joined: 04 Jun 2012 Posts: 1

Hi,

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

lax_lambor · Forum Member Joined: 27 Sep 2011 Posts: 7

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.

dora · Senior Member Joined: 09 Apr 2008 Posts: 61

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

-Dora

lax_lambor · Forum Member Joined: 27 Sep 2011 Posts: 7

Hi Dora,

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