For data saved in tables with DATE type fields you can always use the SE16 screen programs with dynamic date calculation and output to spool with mail recipients.
Rather simple, perhaps even a bit primitive but works.
Ahh.. it is not a customized program. SE16 generates screen programs and you can feed it dynamic parameters from screen variants. Only some config of the job and mail recipients and you have email alerts...
I have created a variant and able to execute the program with variant.
This option will run on daily basis and will fetch the list of all FF users IDs who are going to expire in next 10 days. Now the main problem is how this will trigger email ID to all those users with specific email content?
Every time job will run, list of users will be different because of difference in their validity end date. So how this job will figure out their email ID.
Previously we were talking about sending a mail to spool list recipients of the job --> distribution list.
Now you want individual mails to the dialog user themselves?
If the dialog user is also the approver and is in the same office location as the reviewer, would you like to have an alert email to any supervisors who are not family members?
Yes, My requirement is to send individual mails alerts to the dialogue users not to their supervisors.
Once user will get mail notification that their validity is going to expire in another 10 days, they may arrange approval, to get extension, from their supervisors. This way we will avoid any last minute rush/requests from users.
As I was not sure whether this is possible through some existing functionality (other than custom code) or not so I raised this concern.
Hope this will give you the complete idea on my requirement.
First of all - admin of such tables and alerts for expiry dates is security relevent. the date should be set intentionally and monitored. Hence I assumed the mail to a fixed group or person.
That peron can easily contact the dialog user if there is doubt.
If you want to create a job for each user then you can also do that, but i am not aware of a dynamic way of user assignment to recipient lists which are configurable to have only one job running).
I think you are trying to be too clevel.
Set it up correctly in the first place in GRC and alert the admin. That should do the trick without any custom coding.
Your point is right and alert to the admin is already setup but still we need this functionality to be in place (as you said; I am trying to be more clever )
I'll look into this and if I could able setup this without any custom code; I'll update the solution.
I know of some customer support centers which avoid any tickests for over complex emergencies, because it is a pain to get access to solve the problem.
Rather choose the correct setup and persons in the first place, log activity and have a central admin responsible for who has such access to request more power.
You will either have emergencies from 9 to 5 or they will share the passwors like in the old days again if it is too complicated. Defeats the purpose....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.