Hi Guys,
You can use SQL Maintenance task (Management > Maintenance Plans > New > Cleanup Task) to delete any files based on the age of it.
If you want to delete files by calling a stored procedure, you can use the system stored procedure:
EXECUTE master.dbo.xp_delete_file 0,N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup',N'bak',N'2016-07-17T23:02:07'