deadlock in agent job

From: Randy (randyvATitolDOTcom)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 11:05:57 -0600

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

Relevant Pages

  • Re: Locking
    ... When this happens sql server automatically detects it and will ... So if your app is slow and waiting it is not ... > At the same time another stored proc is inserting data into the table,> updated fields, and deleting records. ... A deadlock> occurs, an the SQL box begins to get extremely slow. ...
    (microsoft.public.sqlserver.programming)
  • RE: deadlock in agent job
    ... the trigger to fire and not for each row affected by the statement. ... > I know i can't trap the deadlock in the stored proc, ... > the deadlock in the agent job, and retry the stored proc. ...
    (microsoft.public.sqlserver.programming)
  • RE: deadlock in agent job
    ... > AMB ... >> I know i can't trap the deadlock in the stored proc, ... >> the deadlock in the agent job, and retry the stored proc. ...
    (microsoft.public.sqlserver.programming)
  • RE: deadlock in agent job
    ... > I know i can't trap the deadlock in the stored proc, ... > the deadlock in the agent job, and retry the stored proc. ...
    (microsoft.public.sqlserver.programming)