k i got. My understanding is below
1. Instead of all tables in one sp, just seperate like a group of tables working together / modulewise and shedule as seperate job
2. Instead of insert into and delete statement, use the single statement like you specified.
I have some confusion like the following
1. If i seperate group of tables and it becomes 5 groups / modules, can i schedule all 5 jobs in same time or seperate time?
2. Anyway begin transaction.. is need for each group. May i use try..catch to rollback or independent like my sample sp
Even i use transaction i have doubt that if delete is happened and output clause is not returned, what happened to my data. Any possibility for this?
No comments:
Post a Comment