大大门帮忙看看，给个关于存储过程和定时执行的解决方案

现有两台SQL：SQLA和SQLB，需要每天每隔一个小时从SQLA上执行一个存储过程获取记录再存储到SQLB上，网页代码采用ASP，请各位大大看看应该怎么做？
SQLA上的存储过程Get_RecordList如下：

CREATE PROCEDURE Get_RecordList(

	@flag as int =0

)

AS 

set nocount on

BEGIN

	declare @rid as int

	declare @enddate as datetime

		

	--return 0

	set @rid=0

	select top 1 @rid=Record_ID, @enddate=LastGetDate from Record_LastGet

	if (@rid=0 or @rid is null or @flag=1)

	begin

		select a.Program_Name as jmmc, 

			startdate as jmrq,

			b.Description as jmpd,

			a.StartTime as jmsd_start,

			a.EndTime as jmsd_end,

			'mms://xx.xxx.com/record'+a.Record_URL as jmdz

			from Record_List a, Publish_Point_List b where a.Record_Type in (1,4)  and  a.Channel_ID=b.Channel_ID

	end

	else

	begin

		select a.Program_Name as jmmc, 

			startdate as jmrq,

			b.Description as jmpd,

			a.StartTime as jmsd_start,

			a.EndTime as jmsd_end,

			'mms://xx.xxx.com/record'+a.Record_URL as jmdz

			from Record_List a, Publish_Point_List b where Insert_Time>=@enddate and a.Record_Type in (1,4) and a.Channel_ID=b.Channel_ID and 

			Record_ID not in (select Record_ID from Record_LastGet)

		delete from Record_LastGet

	end		

	select top 1 @enddate=Insert_Time from Record_List order by Insert_Time desc

	insert into Record_LastGet (Record_ID, LastGetDate) 

		select Record_ID, Insert_Time from Record_List where Insert_Time=@enddate

	return 0

END

GO

主要作用是从SQLA上的表中读出更新的记录赋给自定义的变量，如jmmc、jmpd...然后在临时表Record_LastGet中更新最后一次操作的时间和信息ID号。参数1是获取全部信息，参数0是只获取最新更新的信息！
=======================================================================================
采用的ASP代码如下：

<%

Dim MM_JM_STRING

'这里是SQLB的连接字符串

MM_JM_STRING = "Provider=SQLOLEDB;Server=SQLB;Database=jmdb;UID=xx;PWD=xx"



set conn=server.CreateObject("adodb.connection")

set cmd=server.CreateObject("adodb.command")

'这里是SQLA的连接字符串

strconn="Provider=SQLOLEDB;Server=SQLA;Database=xxxxx;UID=xx;PWD=xx"



conn.Open strconn

set cmd.ActiveConnection=conn

cmd.CommandText="{call Get_RecordList(0)}"

set rs=cmd.Execute()

			if not rs.eof or not rs.bof then

			Do While Not rs.eof 

			if len(rs("jmpd"))<1 then jmpd="节目" else jmpd=rs("jmpd")

			if len(rs("jmmc"))<1 then jmmc="节目" else jmmc=rs("jmmc")

			if len(rs("jmrq"))<1 then jmrq=date() else jmrq=rs("jmrq")

			if isnull(rs("jmsd_start"))<0 then jmsd=0 else jmsd=rs("jmsd_start")

			if isnull(rs("jmsd_end"))<0 then jmsd2=0 else jmsd2=rs("jmsd_end")

			if len(rs("jmdz"))<1 then jmdz="mms://" else jmdz=rs("jmdz")

			MM_editQuery = "insert into dbo.jmdb (jmpd,jmmc,jmrq,jmsd,jmsd2,jmdz) values ('"&jmpd&"','"&jmmc&"','"&jmrq&"',"&jmsd&","&jmsd2&",'"&jmdz&"')"

			Set MM_editCmd = Server.CreateObject("ADODB.Command")

				MM_editCmd.ActiveConnection = MM_JM_STRING

				MM_editCmd.CommandText = MM_editQuery

				MM_editCmd.Execute

				MM_editCmd.ActiveConnection.Close

			response.write "["&jmrq&"]-["&jmpd&"]-["&jmmc&"]-["&jmsd&"-"&jmsd2&"]........OK!<BR/>"

			rs.movenext

			loop

			response.write "ALL OK!!!"

			end if

conn.close 

set conn = nothing 

set cmd = nothing 

%>

============================================================================================
我在服务器上用js做个一个计划任务，每一个小时执行一次，js的代码如下：

ie = new ActiveXObject("InternetExplorer.Application");



// Define how the window should look

ie.left = 50;

ie.top  = 50;

ie.height  = 510;

ie.width   = 470;

ie.menubar = 0;

ie.toolbar = 0;



// Set the browser to a blank page

ie.navigate("http://xxxx/我要执行的这个ASP文件");



// Show the browser

ie.visible=0;



// Open a stream and write data.

//ie.document.open;

//ie.document.write(html);

//ie.document.close;

================================================================================================
现在问题来了，这个流程时常会出现某些时间的数据获取不到的问题，估计可能的问题出在了这个ASP文件上，在执行ASP的时候如果超时了，那么存储过程里面的时间是更新了，但是信息却没传过来，导致了信息的丢失，请各位大大想想办法，看能不能在SQLB中解决这个问题，而不用ASP程序！