RE: deadlock in agent job
From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 01/28/05
- Next message: Itzik Ben-Gan: "Re: Data structure Internals Question"
- Previous message: Alejandro Mesa: "RE: Triggers and Stored Procedure"
- In reply to: Alejandro Mesa: "RE: deadlock in agent job"
- Next in thread: Alejandro Mesa: "RE: deadlock in agent job"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 Jan 2005 09:25:02 -0800
Sorry, wrong place.
AMB
"Alejandro Mesa" wrote:
> This is normal behavior. A trigger is executed for each statement that causes
> the trigger to fire and not for each row affected by the statement. See
> "Multirow Considerations" in BOL.
>
>
> AMB
>
> "Randy" wrote:
>
> > I have a job with a single t-sql step. The tsql executes a stored proc that
> > occasionally deadlocks.
> >
> > I know i can't trap the deadlock in the stored proc, but I'd like to trap
> > the deadlock in the agent job, and retry the stored proc.
> >
> > What is the best way to handle this?
> >
> > -Rand y
> >
> >
> >
- Next message: Itzik Ben-Gan: "Re: Data structure Internals Question"
- Previous message: Alejandro Mesa: "RE: Triggers and Stored Procedure"
- In reply to: Alejandro Mesa: "RE: deadlock in agent job"
- Next in thread: Alejandro Mesa: "RE: deadlock in agent job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
