DAS E-mail on Failure

scheduling Broadcast Agent (BCA)
1

We would like to have an e-mail sent to a group of users when a report fails
in DAS. Has anyone done something like this?

Thanks

Hector

Listserv Archives (BOB member since 2002-06-25)

2

At 10:01 AM 2/11/99 -0600, you wrote:

We would like to have an e-mail sent to a group of users when a report fails
in DAS. Has anyone done something like this?

Thanks

Hector

Hi Hector:
The DAS stores most of this information in the repository. I havn’t
checked but the error information is probably in there as well. If so, you
could write a procedure to search the reporsitory for errors in DAS tasks
and send out the appropriate emails. Also, there has been quite a bit of
discussion on sending emails from DAS using report script. You will
probably find it in the archives. Hope this helps.

Regards,
Chander Aggarwal
COMPUEXCEL http://www.compuexcel.com
The home of BusinessObjects Essentials - the Worlds First and Leading Full
Multimedia Computer Based Training For BusinessObjects, with over 15,000
users world-wide!

Listserv Archives (BOB member since 2002-06-25)

3

Errors for jobs run through DAS are stored in the repository. The errors
are stored in the DS_PENDING_JOB table in the JOB_ERROR column. The only
trick is that error codes are stored, not the entire error text. DAS
internally converts these codes to text for display in the console.

I have an excel spreadsheet which converts all the potential values in the
JOB_ERROR column into their text equivalent. It will probably be easier to
query the DS_PENDING_JOB table then a temporary file as suggested
previously. If anyone would like the spreadsheet just drop me a note. It’s
not added here because the list server rejected my message when I had the
spreadsheet attached.

Hope it helps!

Kumar Kannankutty
Sales Consultant
Business Objects Americas - Midwest Region
Office: 612-391-7834
Fax: 612-391-7839
http://www.businessobjects.com http://www.businessobjects.com

Listserv Archives (BOB member since 2002-06-25)

4

We would like to have an e-mail sent to a group of users when a report fails
in DAS. Has anyone done something like this?

I’m using the following script with Microsoft Outlook 97:

Listserv Archives (BOB member since 2002-06-25)

5

If I may…you may also download the DocAgent bible from the BusinessObjects
Support site, as it lists (in Document 2) all the DAS error messages with
their explanations.

Alain C. Bonnemaison.

Listserv Archives (BOB member since 2002-06-25)