autompatic update of a table with a procedures

Database
New Member

autompatic update of a table with a procedures

Dear,

Ive created a table that contains a 4/5 columns with thousands of rows.

This table contains id selected for a marketing campaign. Every week I have to update this list with new id by considering the current_date and by subtracting the ids already inserted in the table.
The job is simple since I have to run the query every week but i want to automate this with a procedures, trigger or somewhat to do this process in the early morning and find the table already update with the new ids.

Do you have any suggestion?
Tnx very much indeed