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: Upcoming Events: SAP TechEd: Sep 28.

schedule IS task job after BODS job


 
Search this topic... | Search DI: Information Steward... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Information Steward  Previous TopicPrint TopicNext Topic
Author Message
robbydebacker
Forum Member
Forum Member



Joined: 16 Dec 2014

Posts: 3



PostPosted: Tue Dec 16, 2014 11:53 am 
Post subject: schedule IS task job after BODS job

Hi experts,



In our Data Services and Information Steward environment we have set up a Business Objects environment with Information Platform Services (4.1 support pack 4).

In order to automate the process, the information steward task job should start after Data Services job has finished successfully. Therefore I use the schedule event in the CMC as stated in the next article:
http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=318669651

1. Data Services job extracts the data from the source application(s) and loads it in the staging repository.
2. Information Steward profiling tasks and rule validation tasks run against the staging repository.
3. Optionally there may be another Data Services job that moves the ‘Failed Data’ identified by Information Steward into a data mart to enable custom BI reporting.

Problem: the Information Steward task job always starts at the same time when the Data Services job starts, so the event gets triggered before the Data Services job is completed. Is there any workaround on this issue?



Thanks in advance.
Back to top
manoj_d
Forum Addict
Forum Addict



Joined: 01 Jan 2009

Posts: 2944



PostPosted: Mon Jan 05, 2015 7:25 pm 
Post subject: Re: schedule IS task job after BODS job

DS job scheduled in BOE will only trigger the job start and return the status of that not of the job so from BOE side as soon as job is started successfully the BOE Job is completed and since you have tied this to IS Task it will be started without waiting for the DS job to complete

DS Job Execution is not completely integrated into CMS, IS Task(job) execution is, see if you can trigger IS task by writing some file to a shared location once the DS Job Completes, you can write the file to this location in the DS job using a DF or a script, you can't rely on the status of the schedule created for DS job in CMS
Back to top
dcdas
Forum Associate
Forum Associate



Joined: 17 Jun 2002

speaker.gif*2
Posts: 751
Location: Atlanta


flag
PostPosted: Thu Jan 29, 2015 5:57 pm 
Post subject: Re: schedule IS task job after BODS job

Manoj,
We are using Business Objects Data Services 4.2 on linux and have installed IPS. Everything is working fine but we dont see event servers and so we are not able to run the jobs using file events. The IPS document suggests that EVENT SERVER is part of the install but it doesn't show. Any help on how to configure and run event server?

_________________
Durgesh Das
IntercontinentalExchange
durgesh.das@theice.com
Back to top
wilsoja1
Forum Member
Forum Member



Joined: 10 Feb 2012

Posts: 23



PostPosted: Fri Oct 23, 2015 1:29 pm 
Post subject: Re: schedule IS task job after BODS job

same issue here. What is everyone else doing ? (other than writing BODS job status to a file <like it was 1980>)
Back to top
manoj_d
Forum Addict
Forum Addict



Joined: 01 Jan 2009

Posts: 2944



PostPosted: Fri Nov 20, 2015 11:44 pm 
Post subject: Re: schedule IS task job after BODS job

from IS 4.2 SP05 you can export IS Task execution command, you can take that command and call it using exec from the DS job at the end
or use that command line in any other application like 3rd party scheduler
Back to top
wilsoja1
Forum Member
Forum Member



Joined: 10 Feb 2012

Posts: 23



PostPosted: Sat Nov 21, 2015 9:21 am 
Post subject: Re: schedule IS task job after BODS job

Very Nice ! I just upgraded our dev environment to 4.2 SP5 Patch 1 a month or so ago. I'll be sure to give that a try. Thank you for the tip ! (seriously)
Back to top
vikashcvrce303
Senior Member
Senior Member



Joined: 13 Feb 2012

Posts: 37
Location: Bangalore, Karnataka


flag
PostPosted: Mon Mar 27, 2017 11:43 am 
Post subject: Re: schedule IS task job after BODS job

Just wanted to know if export execution command from IS worked in your case.

What are the parameter you edited in the command?
Back to top
wilsoja1
Forum Member
Forum Member



Joined: 10 Feb 2012

Posts: 23



PostPosted: Mon Apr 03, 2017 11:52 am 
Post subject: Re: schedule IS task job after BODS job

IS export command works. We've been using it for some time now.
Back to top
sudhar51
Forum Member
Forum Member



Joined: 22 May 2017

Posts: 1



PostPosted: Mon May 22, 2017 7:09 pm 
Post subject: Re: schedule IS task job after BODS job

Hi Wil,

Can you please let me know how did you use the SAP IS Export execution command in the SAP DS job?.

You can also send the screenshot of the job to sudhar51@gmail.com

Thanks,
Sudharsan C
Back to top
wilsoja1
Forum Member
Forum Member



Joined: 10 Feb 2012

Posts: 23



PostPosted: Wed May 24, 2017 8:16 pm 
Post subject: Re: schedule IS task job after BODS job

In BODS, use a script like so:

print( 'Running Info Steward Scorecard...');
print( exec('EXPORTED IS COMMAND'));
print( 'Finished - Info Steward Scorecard...');
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Information Steward  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.0119 seconds using 17 queries. (SQL 0.0034 Parse 0.0003 Other 0.0082)
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