MS SQL SERVER STORE PROCEDURE and schedulling
hi, i dont know this is the right place to let me ask the problem about the database script or not.
if wrong, plz inform me.
i wan to write a store procedure to check the balance leave of the user when end of year.
if end of year then
if balanceleave>4days then
i have one table is store the user
totalannualleave, balanceanual leave, empid, leaverecordid (PK)
i m first time user to use the store proc,so i duno how to start it.the store proc will run when the date is 31/12 every year(midnite)
can u all guide me?