You can use the following SQL stored procedure : sp_publication_validation to check for the publication validation. You can also schedule this sql job to run at specific times.