SQL Agent

There are two methods I can think of right off hand...

1. Using SQL Server DTS packages locally, you can schedule DB actions that can access your remote DB.
   Note: We don't have access to remote DTS but you can add a local and remote server on your end.
2. Create a dynamic page that you hit from the schedule feature in your Control Panel.
   There are DASP customers who do that now.
   In Classic ASP, PHP and ASP.NET you can create a page that when hit will create the action needed.

Salute,
Mark

 

I have hosted my website on discountasp.net along with sql server database. Can I use the SQL Agents to schedule jobs to run updates on my database tables. I need to update the rows in certain table which contains listings data posted by the user. This needs to be done everyday.

If SQL Agent is not available, is there any alternative to accomplish these tasks. Would certainly appreciate some feedback on this matter.

Thanks

Jags