set Sql job
steps are as below...
MsSQL -> ObjExplorer -> SqlServerAgent ->New (if not accessible then start sql agent service)-> Job ->
in this new window,
general tab -> Name=test
Desc=trial...
check 'Enable' option
Steps tab -> New -> StepName=one type=trans-SqlScr(TSQL)
Database=Your_DB
cmd= Copy paste all your delete queries here.
Advance tab -> On success action=Quit the job
Schedule tab -> New -> Name=From Morning daily
Schedule type= Reccuring
check 'Enable' option
Daily Frequency => check 'Occure once' at = 10 AM
check 'No End date'
OK
Happy Coding!
:)