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

Register | Login 

IBIS 2014: Limitless BI 2.0 
IBIS 2014: Limitless BI 2.0 (Opens a new window)  

General Notice: Upcoming Events: BONYMAUG: May 14, BI2014 Nice, France: May 21.

Batch file & business objects scheduler


 
Search this topic... | Search XI Scheduler... | Search Box
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Author Message
rulezbecca
Forum Member
Forum Member



Joined: 06 Feb 2008

Posts: 7



PostPosted: Wed Feb 11, 2009 10:05 am 
Post subject: Batch file & business objects scheduler

Hello all, we are in need to update and distribuite xi documents only when a particolar Data Base job run. So the data Base got updated, and the DB batch job itself create the event.txt file to start the XI scheduler process.

So the steps are:

1) We have a DB2 data base updated when needed

2) After the DB2 update is complete we need to refresh all our corporate documents using XI scheduler in an authomatic way.

We are able to do so using the procedure described in

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60215a0c-5d3f-2b10-708b-94ac54e4d868

So the DB batch jobs create the specific file events.txt, starting the BO scheduling.

The problem is that after BO START to refresh the report we need to DELETE the file events.txt (generated by the DB2 job), so The XI scheduler update the corporate documents only ONE time (cuz it take about 2 days...) and restart ONLY if a new events.txt is created.

So we need a way to interact with operating system between Business Objects and windows itself. After the scheduler operation is done we need that BO delete that file!

Any ideas? =)

Thx!
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1380
Location: Atlanta, GA


flag
PostPosted: Wed Feb 11, 2009 12:19 pm 
Post subject: Re: Batch file & business objects scheduler

Are you running on Windows or Unix? How often does the DB job run? How long does it take to run?

If the DB job runs longer than the Polling Interval on the Event Server, can the job delete the file before it starts?

If the job runs once a day or less, another option would be to have a scheduled process that deletes the file every day. In Windows I would do this with a .bat file that is run through the Windows Scheduler.

-Dell
Back to top
rulezbecca
Forum Member
Forum Member



Joined: 06 Feb 2008

Posts: 7



PostPosted: Thu Feb 12, 2009 4:21 am 
Post subject: Re: Batch file & business objects scheduler

hilfy wrote:
Are you running on Windows or Unix? How often does the DB job run? How long does it take to run?

If the DB job runs longer than the Polling Interval on the Event Server, can the job delete the file before it starts?

If the job runs once a day or less, another option would be to have a scheduled process that deletes the file every day. In Windows I would do this with a .bat file that is run through the Windows Scheduler.

-Dell


It's Windows , DB job run every month and it takes some days.
When the DB job is finished, it create the file.txt on a specific path and this start the schedular trigger by event server of BO XI r3.

Our problem: this month DB job start random during the month itself, so we don't have a fixed start date and we can't create a .bat file that is run through the Windows Scheduler. We simply need that BO after the auto report update (scheduling proces) delete the triggering file .txt...we really dont know how =-/

thanks in advance for your interest!

w8ing news!?!? banghead.gif
Back to top
agileDSS
Sponsor
Sponsor



Joined: 22 Jan 2007

Posts: 61
Location: Canada


flag
PostPosted: Thu Feb 12, 2009 9:07 am 
Post subject: Re: Batch file & business objects scheduler

Hi,

1) Create a simple batch file that will delete the file
2) Schedule it throught the XI Scheduler (see doc for scheduleing external content)
3) Create an event in the XI Scheduler that will be trigger by the SUCCESS or FAILURE or COMPLETE of your report(s),
4) Create a dependency between your job(responsible to delete the file) and this new event.

Have fun!

_________________
agileWORKFLOW: Take Business Objects scheduling to the Next Level

Integration Pack: Schedule BusinessObjects content from your preferred scheduler

www.agileDSS.com
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  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.0482 seconds using 17 queries. (SQL 0.0030 Parse 0.0346 Other 0.0106)
CCBot/2.0 (http://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