<div>
<div class="content wysiwyg-content">
I'm going to be creating a few triggers on tables to add new records to a seperate table (AlertData). &nbsp;Come 6pm or so I want a scheduled job to automaticaly run to make an HTTP wbe request to my SendAlerts.ASPX page. &nbsp;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.<br />
<br />
My question is is how do i create such &nbsp;a scheduled job under Sql Server 2000? &nbsp;It should run everyday at 6pm EST (even if the dbase server is restarted) &nbsp;and make an HTTP web request to my URL.<br />
<br />
Thank you.<br />

</div>
</div>


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.

Thank you.


SQL Server 2000 - Schedule a Job?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.