BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

All Scheduler List
3 members found this topic helpful
Goto page 1, 2, 3  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
sunder.ramani
Forum Member
Forum Member



Joined: 27 May 2009

Posts: 16



PostPosted: Tue May 10, 2011 3:55 am 
Post subject: All Scheduler List

Author: Sunder Ramani

Hi All,

Author notes
Quote:
Following utility list down all schedulers in your repository with recursive status. It returns you all details of scheduler including reoccurring time, events associated, output format, file and email locations etc.


Cheers,
Sunder Ramani



BO Schedulers.xls
 Description:

Download
 Filename:  BO Schedulers.xls
 Filesize:  306 KB
 Downloaded:  9497 Time(s)

Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19353
Location: Bratislava


flag
PostPosted: Tue May 10, 2011 4:56 am 
Post subject: Re: All Scheduler List

Moderator note:
Approved, and moved to BOB's Downloads.
Back to top
MFleming
Forum Member
Forum Member



Joined: 07 Jun 2011

Posts: 4


flag
PostPosted: Tue Jun 07, 2011 3:17 pm 
Post subject: Re: All Scheduler List

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?
Back to top
gmoorthyp
Senior Member
Senior Member



Joined: 29 Aug 2005

Posts: 89



PostPosted: Fri Sep 09, 2011 1:48 pm 
Post subject: Re: All Scheduler List

it's Compile error. Please upload updated file.
Back to top
sunder.ramani
Forum Member
Forum Member



Joined: 27 May 2009

Posts: 16



PostPosted: Sun Sep 18, 2011 9:39 am 
Post subject: Re: All Scheduler List

Thanks MFleming, will try to upload updated utility soon.

Thanks,
Sunder
Back to top
sunder.ramani
Forum Member
Forum Member



Joined: 27 May 2009

Posts: 16



PostPosted: Sun Sep 18, 2011 9:43 am 
Post subject: Re: All Scheduler List

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
Back to top
binnu23
Principal Member
Principal Member



Joined: 21 May 2010
ASUG Icon
Posts: 206


flag
PostPosted: Tue Nov 22, 2011 6:07 am 
Post subject: Re: All Scheduler List

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
Back to top
maresh
Senior Member
Senior Member



Joined: 28 Jul 2007

Posts: 70



PostPosted: Wed Nov 23, 2011 1:15 am 
Post subject: Re: All Scheduler List

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.
Back to top
alisonc
Forum Member
Forum Member



Joined: 23 Mar 2009

Posts: 5



PostPosted: Tue Jan 31, 2012 5:54 am 
Post subject: Re: All Scheduler List

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?
Back to top
sbroam
Senior Member
Senior Member



Joined: 24 Aug 2006

Posts: 41



PostPosted: Tue Mar 06, 2012 3:36 pm 
Post subject: Re: All Scheduler List

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.
Back to top
TOMVDW
Forum Member
Forum Member



Joined: 08 Jul 2009

Posts: 3



PostPosted: Thu Apr 12, 2012 7:33 am 
Post subject: Re: All Scheduler List

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.
Back to top
dsahni
Forum Member
Forum Member



Joined: 04 Jun 2012

Posts: 1



PostPosted: Mon Jun 04, 2012 6:08 pm 
Post subject: Re: All Scheduler List

Hi,

Can you please advise if you are able to solve this one and run the macro?
Back to top
lax_lambor
Forum Member
Forum Member



Joined: 27 Sep 2011

Posts: 8



PostPosted: Wed Jun 13, 2012 7:39 am 
Post subject: Re: All Scheduler List

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.
Back to top
dora
Senior Member
Senior Member



Joined: 09 Apr 2008

Posts: 72



PostPosted: Thu Jun 21, 2012 8:59 am 
Post subject: Re: All Scheduler List

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

-Dora
Back to top
lax_lambor
Forum Member
Forum Member



Joined: 27 Sep 2011

Posts: 8



PostPosted: Fri Jun 29, 2012 7:07 am 
Post subject: Re: All Scheduler List

Hi Dora,

Just use " SELECT top 100000 * FROM .... " in your select statement of sql query , it will work.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 3 All times are GMT - 5 Hours
Goto page 1, 2, 3  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0378 seconds using 20 queries. (SQL 0.0059 Parse 0.0027 Other 0.0292)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo