You can write a small console app or windows app and schedule it using windows scheduler.

No Problem.

Yes, you are good to go.

As you are comparing two diff. text objects it is good to go with If.

Let me know how it goes.

Switch is faster than using "if". Also i think you are in the right direction with the login.

ok, I got the problem,
In the database you might be getting diff. verification code but when you send in email it is coming same, right?
And the reason is because you are using the same mail...

First debug and see what values are you getting for String v_code = generateVCode(); for each each call.
Then try using diff. mail objects to send mails to diff. people. In the above example you are...

You can check it against the Database, if it already exists then call the same routine to generate next randomn no.

Yes, if app id is only for one user then you can.

You said this requests can goto only designated people. So is anyone allocated to a particlar project? Can the same request goto multiple people? If then you might have to add user_id in ver_code

Let me know if you need some help we can work out something.

Send a verification code in the link which will identify them provide you maintain a record of all verification codes, once it is clicked it cannot used by anyone. You might have to maintain a table...