question

kumarkiran avatar image
kumarkiran asked

Need to change sp to consider failure tables for next run

Hi We are daily refreshing the tables by using stored procedure. if any table failed to load today. while running the stored procedure next day it will take care of data of the tables which were failed yesterday. How can I do this ? Here I am attaching the my script . [1]: /storage/temp/ 3606-incremental-load.txt
sqlstored procedures
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

We would need a LOT more information than a portion of some code using a cursor for which we can't see the definition. We have no idea what you are trying to do here. Here is a great place to start. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
2 Likes 2 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.