automatic update

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

0

Pooja Chowdhury9y ago

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

0

Ramesh Palanivel9y ago

Hi Aishwarjya,

Try this link,

https://www.codeproject.com/Tips/620768/Create-New-Jobs-In-SQL

0

Pooja Chowdhury9y ago

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

0

Ramesh Palanivel9y ago

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!..

0

Sibiraj Thattalam9y ago

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

0

Rajeesh Menoth9y ago

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

0