Help get this topic noticed by sharing it on Twitter, Facebook, or email.

How should I execute SF_BulkOps 'Upsert' if the previous job step is successfully is finished?

I have 3 stored procedures and one function.
BeginSync, GetChanges(),Commit,Rollback
after running BeginSync, I should fill my local table with GetChanges and do
Exec SF_BulkOps 'Upsert'.
If this step ran successfully in sql Server Job I should do Commit otherwise I should use Rollback. Could you please help me and let me know how to proceed?

Thanks in advance!
1 person has
this question
+1
Reply