hi

my project is an eLeave system which using ASP.Net and SQL server 2000.

i proposed to do: leave entitlement assigned to the users will be auto generated in adding start from the every beginning of the year. Therefore the administrator do not need to add the leave entitlement for each user every year.

So how can i do, if i use the SQL jobAgent in the Microsoft SQL Server 2000? then how i m going to update the entitlement in user datatable?
i need u all help, so everyone know about this, please teach me.

Thanks a lot.