update table
-
You question is a bit open-ended, but I'll try to point you in the right direction. If you are logged in as "sa" in SQL server Management Studio, look under "SQL Server Agent" and you will find "Jobs". Here you can create a job to execute with a Daily Frequency of every hour. Does this help? :cool:
-
You question is a bit open-ended, but I'll try to point you in the right direction. If you are logged in as "sa" in SQL server Management Studio, look under "SQL Server Agent" and you will find "Jobs". Here you can create a job to execute with a Daily Frequency of every hour. Does this help? :cool:
-
Thanks but I'm not logged in as "sa". please explain more about job? I see it in sql server agent but I didn't work it.I should update table data every hour
If you don't have sa access, then I would write a windows command line utility (no GUI) which can be scheduled in the Windows Task Schedule to run every hour to update your table.
-
If you don't have sa access, then I would write a windows command line utility (no GUI) which can be scheduled in the Windows Task Schedule to run every hour to update your table.