Post reply

Missing proc sp_add_jobstep_internal

  • May 30, 2007 at 5:37 pm

    #92591

    Hi All,

    I have a subscriber server that is missing msdb.dbo.sp_add_jobstep_internal I have tried to reinstall SP4 but the proc does not get installed. I can only assume that other system proc's may be missing.

    All machines seam to be on the same version. Has anyone come across the problem and or know the fix ?

    The server version is as follows: -

    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

        May  3 2005 23:18:38

        Copyright (c) 1988-2003 Microsoft Corporation

        Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1

     

    kevin

    Kevin

  • May 31, 2007 at 7:26 am

    #709985

    Are you sure it is missing and that you have not actually turned off the viewing of system objects? Is this the only thing missing?

    Does this database have many jobs, maintenance plans, and DTS packages? If none then you could try backing up and restoring a copy of the msdb from another server to see if this will correct for you (of course backup the original just for safety). If a few or just jobs you could script them out (or in the DTS packages open and store in a strcutured file temporarily) then try the previous mentioned restore from another msdb and run you job script to restore the jobs and open and load the DTS package files.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply