I need to create a job using SQL Server 2005. I was wondering is this is possible. If i have one column and it updates the column lets say from 'complete' to 'Incomplete' after particular date or time of month.
I dont see SQL Server agent in my SSMS in SQL server 2005. Please if someone can tell me do i need to login using sQL Server authentication as I am logged in using window authentication righte now.
Please help me how to create a job in SQL Server 2005. I cant see SQL Server Agent in SQL Server 2005. I wnat to create a job in SQL which willl update a column in database table. Please suggest.