JOB - PERFORMING COMPLETION ACTIONS

From: Shamim (shamim.abdul@railamerica.com)
Date: 11/22/02 

From: "Shamim" <shamim.abdul@railamerica.com>
Date: Fri, 22 Nov 2002 10:43:16 -0600

Hi All,
     SQL SERVER 7.0

For the last few weeks , few of my daily SQL jobs shows status as '
Performing Completion Actions' and will not run next day.
I am force to reboot the server or stop/start SQL Agent to clear this.

I was looking into Process Info under Current Activity in EM and found 19
items, one shows as currently running with a command
'SELECT INTO' , when I go into the detail for that spid, it shows dbcc
inputbuffer(18) - 18 is the spid.

There are no locks under Locks / Process ID in EM.

The jobs which shows this status (Performing completion actions) are mainly
data processing job and one transaction log backup job.

Any help/Ideas will be of great help.

Thanks
Shamim

Relevant Pages

  • Re: DBA dissappointed in sql server 2005
    ... That's for NT logins only though. ... SQL Server MVP ... > going down to mangement and then sql server agent and then jobs looking at ...
    (microsoft.public.sqlserver.server)
  • Re: DBA dissappointed in sql server 2005
    ... I realize that a lot of>> improvements have been made in the programmers side of things, but I still>> have to manage the sql servers and I do not see any improvements in my day to>> day, week to week regular management task I have to perform. ... "testing">> or "production" database will only move the table definition and data, but>> not the underlying indexes or constraints. ... I need something that can show>> me easily the status of all jobs across all the servers without manually ... >> mayby others can enlighten me and point out some real benefits in the new>> sql server from a dba point of view. ...
    (microsoft.public.sqlserver.server)
  • Re: Prozedur aufrufen, die in Backend läuft
    ... werde wahrscheinlich mit einem SQL Server arbeiten, ... Das Log für den Ausgang des Jobs kriegst Du dann zusätzlich noch frei Haus, ebenso den EventLog eintrag, ob der Job gelaufen ist und wie der Ausgang desselben war, so dass das Operating des Servers sofort gewarnt wird, wenn was nicht gelaufen ist. ...
    (microsoft.public.de.access)
  • Re: Ignoring Errors
    ... Andrew J. Kelly SQL MVP ... > The problem I'm having is that when my best effort jobs ran in MS SQL ... > one in MS SQL Server. ...
    (microsoft.public.sqlserver.tools)
  • Re: procedure & function inside packages
    ... SQL> create table jobs ( ... SQL> CREATE OR REPLACE PACKAGE job_pkg IS ... SQL> CREATE OR REPLACE PACKAGE BODY job_pkg IS ... 'Chicken tickler') ...
    (comp.databases.oracle.server)