Conditionally Emailing Report Output In maximo

Hi ,

I have a Scheduled Report in Maximo . Every time it runs ,the PDF output is Emailed to the End User .
My Question is : I don't want the report output to be mailed if there is no data to Display but i want it to run .

Regards

Find more posts tagged with

Comments

wwilliams

Just thinking that maybe you could update the REPORTSCHEDULE crontask column CRONTASKINSTANCE.ACTIVE to inactive when there are no rows returned and 1 when there are rows. 
 
So maybe the first thing your report does is check the number of rows, when 0, then have the report run a SQL statement like update CRONTASKINSTANCE set ACTIVE = 0 where INSTANCENAME = 'The associated instance name' 
 
So each run the first thing that happens is the check and then an update if necessary. 
 
I guess it would be worth a try. 
 
-W 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="'Jack S'" data-cid="109065" data-time="1346776769" data-date="04 September 2012 - 09:39 AM">
Hi , 
 
I have a Scheduled Report in Maximo . Every time it runs ,the PDF output is Emailed to the End User . 
My Question is : I don't want the report output to be mailed if there is no data to Display but i want it to run . 
 
 
Regards </blockquote>