construction bond expiration

There is a database maintaining in organization for workers who works temporarily or permanent. Workers who has agreements for 6 months, 1 year etc have expire date. organization wants to warning message to come for each worker when those agreement will expire before seven days. The message should come when those computer will open