Solved

"SQLSERVERAGENT Sql Server Scheduled Job '' - Status: Failed  Job engine 208 " Getting warning ..

Posted on 2011-02-21
1
1,035 Views
Last Modified: 2012-05-11
I m getting this warning.

Will U plz tell me wat is the reason behind it?? ASAP

RCHDNT11:1 NT Events from Application - batch 1  Type     mm/dd/yyyy hh:mm:ss             Source Category      Event       User         MachineName Description  WARNING           2/15/2011 0:00:19 AM           SQLSERVERAGENT Job Engine           208          N/A         RCHDSQLSRV SQL Server Scheduled Job  Get Database Row Counts  (0x3

I m getting this  msg ....I am executing this command :: Exec sp_DBDetails.
 My job is : Get Database Row Count.

Date            2/21/2011 12:00:04 AM
Log            Job History (Get Database Row Counts)

Step ID            0
Server            RCHDSQLSRV
Job Name            Get Database Row Counts
Step Name            (Job outcome)
Duration            00:00:13
Sql Severity            0
Sql Message ID            0
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Message
The job failed.  The Job was invoked by Schedule 10 (Schedule1).  The last step to run was step 1 (Get Database Row Counts).
0
Comment
Question by:krishnabalar
1 Comment
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 34947914
You should be able to look at the step details in the job history and get a more full explanation of the error.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question