Home Forums SQL Server 2005 SQL Server Newbies SQl 2005 Could not locate entry in sysdatabases for database 'dbo' RE: SQl 2005 Could not locate entry in sysdatabases for database 'dbo'

  • When I look at the job step properties under the general tab

    StepName: MonthlyAR,

    Type is Transact SQL,

    Database is ARC_Rpts,

    Command is exec dbo.sproc.Infmtx_003_MonthlyAR.

    Job step properties under under the advanced tab

    On success action go to next step

    On failure action Quit the job reporting failure

    I have already posted all the code for step 3: Monthly AR in today's post @ 10:59:12 AM

    I get the error when I run the SQL Server agent job ARC_Processing.

    When I review the Job Activity Monitor I see step 1 and step 2 succeeded. Step ID 3 Failed , Job Name ARC_Procesing, StepName MonthlyAR , Message "Could not locate entry in sysdatabases for database 'dbo'. No entry was found with that name. Make sure that the name is entered in correctly [SQL State 08004] [Error 911]