SQL Server stored procedure

Stored Procedure can execute set of queries and/or return result to caller. It can't run repeatedly.
But you can call SP from application side after some interval using timercontrol or like this.
Be careful, it will slow down your application if you fetch data frequently (depending on data volume).
It will be better store modification datetime on table and fetch data depending on that field, it will decrease traffic and faster your application.