Dear Amal,
Write the delete query in sqlcommand method and build the solution, you'll get one exe in Bin folder then assign this exe in windows scheduler as everyday running one.
F Y I, find the sample code,
dim con as new Sqlconnection("your connection string")
con.Open()
Dim cmd As New SqlCommand("delete from tablename", con)
cmd.ExecuteNonQuery()
con.Close()
Regards,
Bluesathish