Thanks....It worked for me. Thanks again.

As i am new to T-SQL and i don't know how to create a job. Can you please explain me or send me an example of it.

actually i want to update the column in a table when the a specific date arrives. You can say that i want to expire a person's login when a specific date...