How do I setup a sql server job in sqlServer 2k?
[256 byte] By [Matrix.net] at [2007-11-11 10:06:28] 
Hi can anyone give me some directions on as to how I would set up a job in sqlserver 2000 to look at the value of a column ( a date value to be exact) and then do an update on that record ? Like what menus/wizards would I have to go through etc. Thanks
# 1 Re: How do I setup a sql server job in sqlServer 2k?
Basically, you need to do two things... The first is to come up with the SQL query which performs the query/update. Then, you just need to go into SQL Server Jobs (under management in SQL Server 2000 if memory serves) and create a new job (make sure that the SQL Server Agent service is set to start up automatically). Then put the sql in a step within the job you created. Click 'Schedule' to schedule it, and follow the steps there. Note: You can also encapsulate this functionality within a stored procedure, then call that stored procedure from the job (a little more neat and manageable).
waterjock2000 at 2007-11-11 23:43:34 >
