I am searching in a way that make automatic excustion for a view evry specific period of time
any help regard this ?
SQL Server Agent is the built-in feature to handle scheduled tasks on SQL Server:
https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent