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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Rescheduling the report using BO SDK jsp

Goto page Previous  1, 2
 
Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6625
Location: Connecticut, USA


flag
PostPosted: Mon May 06, 2019 8:25 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

I've done SDK programming in Java and VBA but not VBS, so I can't be certain it will work.

But this line:
Code:
  set oScheds = oInfoStore.Query("select top 1 * from ci_infoobjects where   si_recurring=1 and SI_NAME='"TESTJOB"'"")

doesn't look right. Is it actually a report named "TESTJOB"? If so, it should be:
Code:
  set oScheds = oInfoStore.Query("select top 1 * from ci_infoobjects where   si_recurring=1 and SI_NAME='TESTJOB' ")
Back to top
satheesh_rvs
Forum Member
Forum Member



Joined: 02 May 2019

Posts: 7



PostPosted: Tue May 07, 2019 4:05 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

Hi joepeters,

I made the query works . But the core help needed is here in the below lines .
am running the script without any SDK .
Code:
oSched = oScheds(1)
oSched.SchedulingInfo.RightNow = True
oSched.SchedulingInfo.Type = ceScheduleTypeOnce

while(oSched.SchedulingInfo.Dependencies.size > 0)
               oSched.SchedulingInfo.Dependencies.remove(0)
wend
         
   oInfoStore.schedule(oScheds)




Also if you have the Java script for this , please help me by providing the code . Since i need to run the Code as script (standalone ) to reschedule the failed job .
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6625
Location: Connecticut, USA


flag
PostPosted: Tue May 07, 2019 7:56 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

What is the exact problem you're having with that code?
Back to top
satheesh_rvs
Forum Member
Forum Member



Joined: 02 May 2019

Posts: 7



PostPosted: Mon May 13, 2019 6:55 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

Hello Joe,

Sorry for delay in replying .

The problem is that it launches a process like "Wscript" kind of a instance and it running with high CPU . Also fore each command line execution its creating a process and CPU is getting completely utilized .

Once the reschedule is done . process should get killed automatically right ?

Note: am trying to rerun only one scheduled report Job .
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6625
Location: Connecticut, USA


flag
PostPosted: Mon May 13, 2019 8:34 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

If it's hanging and pegging the CPU then maybe your While loop is never completing?
Back to top
SuKA
Forum Member
Forum Member



Joined: 20 Oct 2018

Posts: 15



PostPosted: Tue May 14, 2019 11:43 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

Hi,

may be you should change your code:

while(oSched.SchedulingInfo.Dependencies.Count > 0)
oSched.SchedulingInfo.Dependencies.remove(0)
wend
Back to top
satheesh_rvs
Forum Member
Forum Member



Joined: 02 May 2019

Posts: 7



PostPosted: Thu May 23, 2019 9:19 am 
Post subject: Re: Rescheduling the report using BO SDK jsp

Hi All,

Sorry for delay in reply .

Yes . i can see that while loop is the issue . For this code do we need any SDK or any modules for VB script ? .

Even after changing to "oSched.SchedulingInfo.Dependencies.Count" am facing the same issue .

when i try to display the "wscript.echo oSched.SchedulingInfo.Dependencies.count" it displays nothing .

if my oScheds has only one job then can i skip this loop ?

Please help me am new to VB as well as BO
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
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.0290 seconds using 17 queries. (SQL 0.0033 Parse 0.0009 Other 0.0248)
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