I occasionally need to run a report for each user in a user group. Currently I do this in a script include, where I iterate through each user in the group and run a function that creates a record on the sysauto_report table, setting run_as and user_list to the person I am running the report for and setting run_type to once. This accomplishes what I need, but since I am doing this weekly, it is cluttering up the Scheduled Reports table, and I wonder if there is a cleaner way to do this. (If you look at my app in Studio, I see hundreds of records under "Scheduled Email of Reports" because it keeps creating Run Once records.)
I suppose one possibility is that I instead create this records to run weekly, and my script checks to see if one already exists for that user and that report before creating a new record. Another possibility is that instead of having a script include that is called by a weekly scheduled job, I have a business rule that only runs when a member is added or removed from that group that will add/deactivate the scheduled report for that person. But I wonder if there is a third way that I'm not thinking of that would be better than either of these plans. Anyone have any ideas?
