SQL scheduled job

1. Call the PAGE method on a regular basis

 

------------------------------------
-- Purpose: refresh the page every few minutes
-- Note:
------------------------------------
Alter procedure [DBO]. [sendinfo]
As
Declare @ ADC int
Declare @ HR int
Select @ ADC = 1
If @ ADC = 1
Begin
Exec @ hR = sp_oacreate [microsoft. XMLHTTP], @ ADC out
Exec @ hR = sp_oamethod @ ADC, [open], null, [get], [http: // 10.0.1/msg. aspx]
Exec @ hR = sp_oamethod @ ADC, [send], null
End

-- Create a scheduled job
Exec [sendinfo]