How to remove data from source after transfered to another table on SQL

Question

Hi all

I have following workflow in a SQL Database.

I receive new data in a "staging table" every hour.

Over night I transfer and clean/preparate these data into a final table

After this is succesfully done I want to remove data older than xx hours from the staging table.

Right now I make it this way and scheduled this for every 24 hours:

Im not really happy with this.

Does it really works sequential ?

How can I check that the data tansferred succesfull before removing?

Do you have any smarter and more secure ways ?

Thanks in advance

Steffen

gnans19 · Accepted Answer

Consider using CrewMacros by @acmartin55. I would consider 'Conditional Runnner' or 'List Runner' macros. These macros are life savers.

Macros are available for free download at  http://downloads.chaosreignswithin.com/Macros.zip