Hi nagarjun16,
Please refer below sample test query.
SQL
DECLARE @CurrentDateTime AS TABLE ([Name] VARCHAR(20),[Date] DATETIME,[Status] VARCHAR(10))
INSERT INTO @CurrentDateTime VALUES('Mudassar','2018/05/15 12:11','Pending')
INSERT INTO @CurrentDateTime VALUES('John Mohammad','2018/01/12 12:11','Pending')
INSERT INTO @CurrentDateTime VALUES('Suzan Mathew','2018/08/27 12:14','Pending')
DECLARE @DateTime VARCHAR(16)
SET @DateTime = CONVERT(VARCHAR(10),GETDATE(),111) + ' ' +CONVERT(CHAR(5), GETDATE(), 108)
DECLARE @Name VARCHAR(20)
IF EXISTS(SELECT [Name] FROM @CurrentDateTime WHERE [Date] = @DateTime)
BEGIN
SELECT @Name = [Name] FROM @CurrentDateTime WHERE [Date] = @DateTime
UPDATE @CurrentDateTime
SET [Status]='Completed'
WHERE Name=@Name
END
And refer below link to check the record at regular interval and update the status.
Make procedure and call inside code.