Can the Scheduler update the database?

scheduling XI Scheduler
1

Hi,

Is it possible for a BO scheduled report to run an update statement in the database when the report completes? I want to create a database table and have BO update the table to indicate that the report has been run upon completion. Is this possible?

I am running BO XI, Webi reports, oracle 10g database

sef149 (BOB member since 2008-06-09)

2

A Webi document is not allowed to write back to a database. So the only way that I can think of here is to create a stored procedure that can be called from a universe object. I’ve never done this, but I’ve heard rumors that it can be done.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Similarly, can have an event that triggers a program object to be executed.

newgun :us: (BOB member since 2007-08-01)

4

Or similarly if your using Crystal you can base a report on a DB Command which can do updates.

ABILtd :uk: (BOB member since 2006-02-08)

5

I like the idea of “to create a stored procedure that can be called from a universe object. I’ve never done this, but I’ve heard rumors that it can be done.”

Has anyone tried this? I assume the object would just call a procedure and you would place that object last in the query panel? Any info would be much appreciated!

sef149 (BOB member since 2008-06-09)

6

I’d assume it would have to be a separate query on a universe based on a store procedure. The stored procedure would have some output but it would also perform an update or insert each time it is executed. The query would be unconnected from your data queries used as the foundation of your report.

I suspect such a method couldn’t receive information and could only write back to the database when it was executed.

The issue is that the query could execute but then your data query could fail, resulting in a failed instanced with a positive message in the database…

BrotherPaulos (BOB member since 2005-12-15)

7

I have used a stored proc to achive the same thing as you, only in DESKi reports, add another dataprovider as SP and in the SP you can log the time , report name, unv name in a log table each time the report gets executed. I guess most of you might have already done this.

kondratr :switzerland: (BOB member since 2005-02-02)