there is any procedure (method etc) available in sql server /query analyzer that run following update query automatically ?


update arc set imagereference=replace(imagereference,'$(ROOTDIR)' ,'\\Auhtripdc\As_Built\tiffiles') where imagereference like '%$(ROOTDIR)%'


update the records daily automatic ?

regards.

Mateen

Make sure SQL Agent is running and schedule a new job to run daily. Maybe easier to put the code into a stored procedure.

--

Joe

thanks.

My SQL Agent not running, it give message that performing this
service operation on SQLServerserver Agent.

I am using client side sql server, in my PC (control panel, services) there is no SQL Server Agent service available.

I need to start SQL Server Agent service on the Server side ?
can I start this serivce from the client side ?

regards.

Mateen

What operating system and which version of SQL Servre?

--

Joe

I am using Windows XP and SQL SERVER 2000 client side.
in server side SQL Server 2000 and operation system
windows 2000.


regards.

Go into the enterprise manager, navigate to the server in question and start up the service (from Magement Section, I think). Look in books on-line that should have been installed when you installed the manager. Even if you don't have the manager you can stop/start with the app that normally sits in the system tray.

--

Joe

thanks.

you can give me online book site address.
it miss by me.

Mateen

The first result from Google for "SQL Server Books Online" brought this linK:

http://www.microsoft.com/sql/techinf...2000/books.asp

Was that too difficult?

--

Joe

thanks.

Some times SQL Server Agent will not start with the default installation. Make sure that you download the latest service pack for SQL Server ant the latest MDAC release.

I think you can use SQLDMO to start/stop the Agent, but preferably use enterprise manager. Do not allow your users to start or stop the agent.



Sal