Thanks everyone, I used this in my where clause and it worked perfect.

where CAST(LEFT(whenreceived, 8) as datetime) + 30 < GETDATE()

Thanks, I forgot about these.

Thanks for the reply. Do you know if sql agent will skip a job if it is past its run window? Or will it realize that it was missed and run...