Solved

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

Posted on 2011-02-21
1
1,029 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now