SQL Job Scheduler是否有替代方案

本文介绍了SQL Job Scheduler是否有替代方案的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好 是否有其他方法可以使用Classic ASP

解决方案

完成相同的SQL调度程序的工作，调度程序将在后台运行并执行某些操作在给定的时间. ASP是一种在Web服务器上运行的服务器端技术，无法保证它将在给定时间或长时间内运行，并且这样做浪费了服务器资源(Web服务器可能会终止并重新启动)无论如何). 因此，您需要诸如Windows服务之类的东西来进行调度.版本，请查看 SQL代理:作业调度程序框架 [ ^ ]. 这也是很好的学习材料.

Hi all Is there any other way to do the same sql scheduler''s work using Classic ASP

解决方案

a scheduler is something which will run i the background and will do some action on a given time. ASP is a server side technology which runs in a web server, there is no guarantee that it will run at a given time or for a extended period, and it is waste of server resources to do so (the web server will probably kill and restart it anyway). Therefore you need something like a windows service for scheduling.

If you''re looking for an alternative for the SQL Server Job Scheduler, for example because it''s not included in the Express Edition, have a look at SQL Agent: A Job Scheduler Framework[^]. That''s also a good learning material.