Who's On?

	Membership:
	Latest: chaoticist
	Past 24 Hours: 2
	Prev. 24 Hours: 0
	Overall: 5185

	People Online:
	Visitors: 228
	Members: 0
	Total: 228

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Report Schedules

Sort:

You are not authorized to post a reply.

Author

Messages

Ruma Malhotra

Veteran Member

Posts: 412

7/10/2009 3:02 PM

I am wondering if anybody has found out a way to get notified whenever a report scheduled to refresh at a particular day and time fails to refresh without going through the log files.

On reporting services for maintain schedules the status of success or waiting is not the true status of whether the report refreshed but the status which defines that the handoff for reporting services to CRAS to refresh was successful or not.

Also we are on version 9031 in test and 9022 on prod ans was wondering where the information about a report, the schedule bname and the day and time of schedule is stored. I am looking to create a report and I cannot see where this information is stored. But maybe I am overlooking something since there is absolute no documentation on this.

Thanks in advance

Greg Moeller

Veteran Member

Posts: 1498

7/13/2009 2:09 PM

I would really be interested in this capability as well. We have tons of reports that our users and Managers have come to rely on, and when they don't get them it can cause a snowball effect.

Ruma Malhotra

Veteran Member

Posts: 412

7/13/2009 2:21 PM

I am thinking of adding an enhancement request on lawson Support site to provide us of an report that will gives us the schedule names, scheduled time and frequency, Last refresh date, next refresh date and whether the report refreshed successfully or not(status).

Matthew Nye

Veteran Member

Posts: 514

7/13/2009 2:21 PM

it would require parsing the RS repository tables. This can be difficult because some of the fields are blob or encoded. Another way would be to create some custom server side pages to interject during the 4 accessible Events of a report run:
- Report Request Received
- Parameter Selection
- Parameter Validation
- Report Request Complete

Using these and information included in the referring URLs you could determine which report requests were based on a user and which were based on a schedule and whether or not it completed. You could then log this in a file or custom database table and create a SmartNotification to email to the responsible parties.

unfortunately though, there are not ou-of-box solutions for this that I know of.

hth
matt

Ruma Malhotra

Veteran Member

Posts: 412

7/13/2009 2:59 PM

Thanks for replying. This defnitely helps. However I do not know java programming to create any server side pages and nobody on our staff knows this as well. Also if we have to interject a script during the processing of a report refreshing we are skeptical in doing this as we do not want to mess with normal processing. We also defnitely know for a fact that lawson will not support us.

End result is to carry on with the normal side of things but I will defnitely create an enhancement request as I have a very strong business justification need for this hoping that the request will be entertained in the near future.

However thanks once again for the reply.

You are not authorized to post a reply.