CODEWITHSUNDEEP
sqlstored-procedurestriggersjob-scheduling
user3407440
user3407440

Reputation: 183

How do I update the column value after 4 days?

I am looking for your assistant in understanding the way and the code to get the column value to be changed after 4 days.

Currently, whenever I am inserting a new row in the database, the value of the flag will be "Y" by default and I will capture the created date & time by storing the sysdate by default. Now, I want the flag to be changed to "N" after 4 days from the creation.

So, please guide and instruct me on the way to do the above.

Upvotes: 0

Views: 70

Answers (1)

Ramie
Ramie

Reputation: 1201

You should look into creating a Trigger on INSERT/UPDATE/DELETE IF your table is frequently accessed for those operations.

If not, then you would have to schedule a job to run SQL daily or how frequent you'd like to check.

how to schedule a job for sql query to run daily?

Upvotes: 1

Related Questions