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]