I have a confirmation email system where I generate a 6 digit code on the server, store it in verify_email_code table in db and email user the code.

The verify_email_code table has created_at column which is used to check if the code has expired, but a more elegant approach would be to just delete the entry from the database after a set amount of time. This way the database will not need to store unnecessary data.

How do I schedule a job using next.js server actions. Would a setTimeout do the job or is that not possible?

"use server"

const EXPIRE_TIME = 1000 * 60 * 10 // 10 minutes (ms)

async function scheduleExpireCode(email: string, code: number) {
  setTimeout(() => {
    await removeCodeFromDb(email, code)
  }, EXPIRE_TIME)
}

async function verifyUser(email) {
  const code = await generateCode()
  await insertCodeToDb(email, code)
  await mailUserACode(email, code)

  await scheduleExpireCode(email, code)
}