I use several Notification Forums to make announcements to different groups in our Scouting organization.  The forums are setup to email users that belong to a certain Role.  The problem that I have is if I add a user (solely for the purpose of sending e-mails) or a user registers and does not visit the forum page the forum will not send mail to that user.   What I have been doing for the last few years is running a report that I created, then for any user listed in the report I go to the Forum Administration page and view that user.  Once I do that, the forum will email the user.  

Here is the report that I run:
Select
  U.Username "Account",
  U.DisplayName "User Name",
  U.UserID      "Number",
  AM.Email      "E-Mail"
from
  aspnet_Membership as AM with (nolock)
  join aspnet_Users as AU with (nolock) on AM.UserID  = AU.UserID
  join Users        as U  with (nolock) on U.UserName = AU.Username
  join UserPortals  as UP with (nolock) on U.UserID   = UP.UserID
  join UserRoles    as UR with (nolock) on U.UserID   = UR.UserID
  join Roles        as R  with (nolock) on UR.RoleID  = R.RoleID and UP.PortalID = R.PortalID
where
  AM.ApplicationID  = ( select ApplicationID from dbo.aspnet_Applications where ApplicationName = 'DotNetNuke')
  and U.IsSuperUser = 'False'
  and R.RoleName    = 'Announcements'
  and UP.PortalID   = 3
  and not exists      ( select * from Forum_Users where UserID = U.UserID and PortalID = UP.PortalID )
order by
  U.UserID

My question is; Is there something I can schedule in DNN to add missing users to the forum instead of having to do this process manually?  I often forget to this and people do not get the email.

Thanks,
Greg 

I am thinking the simple solution may be to add a database insert  trigger on the UserPortals table to run the Forum_User_Add procedure.
Thanks,
Greg Hart