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.

Rerun SAP BO JOB using VBS


 
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
satheesh_rvs
Forum Member
Forum Member



Joined: 02 May 2019

Posts: 7



PostPosted: Mon May 06, 2019 1:01 pm 
Post subject: Rerun SAP BO JOB using VBS

Hi All,

I wrote the following code to rerun the failed Job in SAP BI but its now working . Kindly help me make it work . Let me know whether i need to include any SDK for VB script .

Code:
strComputerName = CreateObject("WScript.Network").ComputerName

On Error Resume Next

Set SessionManager = CreateObject("CrystalEnterprise.SessionMgr")
    Set esession = SessionManager.Logon("USERNAME", "PASSWORD", strComputerName, "secEnterprise")
    Set oInfoStore = esession.Service("", "InfoStore")
  set oScheds = oInfoStore.Query("select top 1 * from ci_infoobjects where   si_recurring=1 and SI_NAME='"TESTJOB"'"")

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)

SessionManager.logoff

WScript.Quit
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
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.0265 seconds using 17 queries. (SQL 0.0023 Parse 0.0008 Other 0.0233)
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