Database query - Calendar keywords expried

Discussion created by JohnO'Mullane on Sep 6, 2016
Latest reply on Mar 22, 2017 by laura_albrecht_automic
Anyone with Static Calendar keyword will know that there is always a risk of reaching the end date.
I want to write a little SQL job that will alert me when a static keyword is reaching it's last set date.

Anyone out there implemented something like this?
If I knew the table that contained the keywords that would be a good start.
I did looked at the Database Schema under but not so clear there which table I need to query.