创建作业定时执行SQL语句同步数据

DECLARE @ServiceUrl AS VARCHAR(1000)
DECLARE @UrlAddress VARCHAR(500)
SET @UrlAddress='http://47.96.236.193:88/OA/Common/API/HRAttendance.ashx'
DECLARE @Object AS INT
DECLARE @ResponseText AS VARCHAR(8000) 
DECLARE @Body AS VARCHAR(MAX) 
DECLARE @temp TABLE
    (
      empno VARCHAR(50) ,
      empname VARCHAR(50) ,
      worktime int ,
      workdate DATETIME,
      fk_id VARCHAR(36)
    )
--以下参数对应WebService中4个参数的[参数名]
DECLARE @type VARCHAR(4) ,
    @productkey VARCHAR(10) ,
    @hard VARCHAR(4) ,
    @log VARCHAR(3)
SET @type = 'type'
SET @productkey = 'productkey'
SET @hard = 'hard'
SET @log = 'log'
DECLARE @type_value VARCHAR(10) ,
    @productkey_value VARCHAR(100) ,
    @hard_value VARCHAR(10) ,