July 24, 2012 at 12:39 pm
I have a job which has an SSIS package which basically runs different stored procedures. Now when i stop the job manually i know that all the stored procedures will be rolled back but would it send some type of signal or flag to the job? Is there something i can lookup in msdb tables to confirm that my rollback is completed?
July 26, 2012 at 2:22 pm
anyone?
July 26, 2012 at 2:27 pm
The only thing you will find regarding the job in MSDB is that the job was cancelled. There is no signal back to record that a rollback was done.
July 26, 2012 at 3:47 pm
Lynn Pettis (7/26/2012)
The only thing you will find regarding the job in MSDB is that the job was cancelled. There is no signal back to record that a rollback was done.
Came across this, what do you think :
http://msdn.microsoft.com/en-us/library/ms182793.aspx
When SQL Server Agent receives the stop notification, it waits for the job step that is currently running to finish before it processes the cancel request. Some long-running Transact-SQL statements such as BACKUP, RESTORE, and some DBCC commands can take a long time to finish. When these are running, it may take awhile before the job is canceled. Stopping a job causes a "Job Canceled" entry to be recorded in the job history
--------------------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply