图片 3

表定时同步

1.创建存储过程

   

create proc [dbo].[sync_calendar]
as
truncate table dbo.CalendarEvents
insert into CalendarEvents (title,startdate,enddate,type,year,createdate,updatedate ) 
select title,startdate,enddate,type,year,createdate,updatedate 
from  calendar.RSCalendar.dbo.CalendarEvents

2.SQL代理新增作业

图片 1

图片 2

图片 3