We need to create an automated restore of the production SQL Server database.  The restore needs to run every Sunday.  The restore will be done to the Development server from the Full backup taken on Saturday.

Has anyone done this before?

We are struggling with the scheduling piece.

Thanks