SQL Procedure to run shapshots when the mirror is connected

Question

Hi all, first i appreciate your help, is my first time on this forum.

I don't have experience writing procedures on sql, i need to schedule a job that verify the conection status on sys.databese_mirroring, if the status is 'SYNCHRONIZED' y need drop a specific snapshot and create a new one. If not i leave the last snapshot running. I use the mirror_guid to select the specific database.

Thanks.