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
Solved! Go to Solution.
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