Auto increment a value using cursor in SQLServer I am developing an employee leave management system and

My table structure with data is :

+-----------+---------+----------+----------+------------+--------------+
|   EmpID   |   CL    |     PL   | ISActive | LastUpdate |  NextUpdate  |
+-----------+---------+----------+----------+------------+--------------+
|   E001    |   5     |     3    |    1     | 2015-01-01 |  2015-02-01  |
+-----------+---------+----------+----------+------------+--------------+
|   E002    |   3     |     7    |    1     | 2015-01-01 |  2015-02-01  |
+-----------+---------+----------+----------+------------+--------------+
|   E003    |   0     |     1    |    1     | 2015-01-01 |  2015-02-01  |
+-----------+---------+----------+----------+------------+--------------+
|   E004    |   5     |     1    |    0     | 2015-01-01 |  2015-02-01  |
+-----------+---------+----------+----------+------------+--------------+


I want every active employee to get 2 CL on the 1st of every month and 
1 SL every 45 days automatically. I have been told it is possible to do this using a cursor, but i don't know.

Is there any other efficient way to do this?
I don't think a cursor is good solution to this as it would have to be running 24 / 7 and you would need to check it was running. A better solution would be to have a SQL Agent job that runs at midnight each night. The Agent job would call a stored procedure that checks the IsActive flag, LastUpdate field and NextUpdate field for each employee and then increments the mentioned values for each employee. 

The stored procedure could send an email after each run to show you how many records were updated. It could also incorporate error handling to alert you if there was a failure for some reason. This way you can be sure the process is running correctly.