I need to execute a webmethod form awebservice every 5 minutes and wanted 2 use a stored procedure but I can't schedulea job because Tiscali won't allow me. Is there another way to schedule a storedprocedure or call a webmethod with out having my computer do it over the internet?They also won't allow me to install a windows service in the server.
sqlFriday, March 30, 2012
Scheduling Stored Procedures for MS SQL Server 2000
Is there any way to make MS SQL Server 2000 to perform some stored procedures, say 3 times a day? If so, how? Thanks.Use the SQL Agent. Google for examples. It's a core part of a SQL server installation. Set up your jobs, let fly.|||
Labels:
database,
microsoft,
mysql,
oracle,
perform,
procedures,
scheduling,
server,
sql,
stored
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment