SQL 表定时同步

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代理新增作业

转载于:https://www.cnblogs.com/Sakura007/p/7650849.html