Hai friends,
Please provide the solution for the following:
In an employee table 10 employees are there, every month we have to increase the salary 1000 for all the employees dynamically.
I don't want to write query every month.
Based on the date Employee joined, It should update.
Please provide solution friends.

Sreekanth ReddyPosted Nov 6, 2014, 12:10 AM
Sibeesh VenuPosted Nov 5, 2014, 11:26 PM
http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/
http://blogs.msdn.com/b/sqlagent/archive/2010/10/14/creating-a-regularly-scheduled-job.aspx
Please up vote if it helped you.