automatic update

Question

i want one sql query of automatic update of date and status column in a table within a particular hours

Sibiraj Thattalam · Answer

Are you using SQL Express Edition? If so you cannot enable Server Agent. You can try some alternate method like using Windows Task.

Pooja Chowdhury · Answer

Start the SQL server agent if it is red color turn on like this: Please check this i cannot find out this

Ramesh Palanivel · Answer

Hi Aishwarjya, Try this link, https://www.codeproject.com/Tips/620768/Create-New-Jobs-In-SQL

Pooja Chowdhury · Answer

cannot find sql server agent in sql server 2012 how to solve this problem

Ramesh Palanivel · Answer

Hi Aiswarjya, You can Run your query automattically to update the date and status using SQL server Agent.. Its like Alarm, IF you set the time for this agent , your mentioned query will run automattically.. To learn about SQL server agent, fine the below link http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/ I hope!.. It will help you!..

Sibiraj Thattalam · Answer

Hello, Create New Job on SQL Server Agent, You can use your time update query on step. Please check below link for more. http://stackoverflow.com/questions/5471080/how-to-schedule-a-job-for-sql-query-to-run-daily

Rajeesh Menoth · Answer

Hi, Please refer the following article : http://www.ifinity.com.au/Blog/EntryId/8/Creating-Automatic-insert-and-update-statements-from-SQL-Tables-using-T-SQL

automatic update

Answers (7)