SQL Server 2000 - Schedule a Job?
Posted on 2006-07-11
I'm going to be creating a few triggers on tables to add new records to a seperate table (AlertData). Come 6pm or so I want a scheduled job to automaticaly run to make an HTTP wbe request to my SendAlerts.ASPX page. The page will simply make a database call for all users and the AlertData table contents, build what it needs and send out all the email alerts.
My question is is how do i create such a scheduled job under Sql Server 2000? It should run everyday at 6pm EST (even if the dbase server is restarted) and make an HTTP web request to my URL.