I have created the BPA on 25th Aug with an effective end date as 1st of september, 2012 , and used the Tools from menu to define Notification control. I set the condition as Expiration and warning delays as 10 days.
When I run the sql query for Alert for BPA reaching expiration date in Alert Responsibility, It returns with the result as "No rows Selected".
Any Idea why this BPA reaching expiration is not getting extracted. Is there other ways to get the data of BPA reaching expiry?