For doing that we need to create procedure first and also define the repeating interval to call it again
We will create procedure named getnotification from the particular database that gets fired after 3:30 hours on a daily basis.
When we gets connected with our database it gets executed automatically from the given time period
CREATE PROCEDURE GetNotification
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- The interval between cleanup attempts
declare @timeToRun nvarchar(50)
set @timeToRun = '03:33:33'
while 1 = 1
waitfor time @timeToRun
-- Run the procedure when the database starts.
spprocoption @ProcName = 'GetNotification',
@OptionName = 'startup',
@OptionValue = 'on'