View Point alerts setup for blocked sessions sent to users with thier email dl's
Hi, I want to setup Viewpoint blocking alerts ,and want to send communications of user id basis, for such user id, this should go this dl, and like wise.. But how about where a username is blocking a proxy id on DEV, where users have dml access as well? Also, since the project come and get decomnissioned, how will it be handled, if the proxy id's and the database along with it are decomissioned. Are the blocking set based on if the user is in blocked state for some time, and can we also show , what kind of lock and who is in blocked and blocked by state ? Please let me know , if all above can be done within scope of Teradata Viewpoint or have to go some other options within and outside Viewpoint. Also, if not every 10 min, can we pull any report every hour and send email communication report , who was in blocked state and how long.