SQL Server Agent

Hi,

I have successfully added my sql server 2005 database to a discountasp.net hosted server, thanks to some great posts in this forum.

My database runs a couple of jobs scheduled and run by sql server agent. Is this functionality present in the discountasp.net hosted environment. If yes, do i have to turn it on somewhere? Also, how to I amend jobs and their schedule?

Any help greatly appreciated

Brian

 

Hi,
You can create a local DTS with the remote DASP server and your own system.
Then scedule events on that local system.
If you search you can even find some free utilities that will fire the event for you against the DTS job, locally.
All the files would be on that local system but the DTS task, local,would have a node for the remote SQL Server.
Salute,
Mark

 

Thats great advice. Thanks


Any particularly good free utilities spring to mind...?

 

Microsoft provides DTS Run:
http://msdn.microsoft.com/en-us/library/aa176402(SQL.80).aspx

At SIEMENS we used that to fire off triggers between the U.S. and Germany.
I have not tested it on SQL Server 2005, or later.

Running it as a Job:
http://support.microsoft.com/kb/q269074/

Article on how to set one up:
http://www.databasejournal.com/features/mssql/article.php/3579941

Using the Agent locally:
http://articles.techrepublic.com.com/5100-10878_11-5031813.html

Any task scheduler should be able to handle it.
I used to do it with the default task scheduler on Windows Server 2000.
Salute,
Mark

 

Hi Bruce,

Whats the best way to run/simulatea scheduled job in sql server 2005 without sql server agent...?

The scheduled job is quite an important one.

 

Brilliant. Thanks again

 

No prob. I hope it works for you because I used to have a lot of fun with it.