Transaction in SQL Job

#1

Hi All,

How can we maintain transaction inSQL Job ?

I create DTS package and SQL job of that package.what i wanted to do is when
user stop SQL job during its run, Job should able to rollback all transation.

--
Regards
Bharat Jariwala

#2

Hello Bharat,

Have a look here at some of my pervious answers to this Q

http://groups.google.com/group/micro...04ff5f36c75773

Allan

Quote:

Hi All,

How can we maintain transaction inSQL Job ?

I create DTS package and SQL job of that package.what i wanted to do
is when user stop SQL job during its run, Job should able to rollback
all transation.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transaction in SQL Job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Transaction in SQL Job - 01-09-2006 , 03:11 AM

Re: Transaction in SQL Job - 01-09-2006 , 06:02 PM