[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to view the error log for SQL agent job

Posted on 2013-11-25
1
Medium Priority
?
566 Views
Last Modified: 2013-11-25
I tired to look into the Error Logs for my sql agent job i created But I see nothing there.

I set up an Alert to get an email if the job fails.
All i get is

JOB RUN:      'LoadData' was run on 11/25/2013 at 10:40:00 AM
DURATION:      0 hours, 0 minutes, 1 seconds
STATUS:       Failed
MESSAGES:      The job failed.  The Job was invoked by Schedule 17 (DataLoadSchedule).  The last step to run was step 1 (1 - LoadData).

It does not tell me anything specifc
My command is a stored procedure, which when run by itself work fine.

The command is exec dbo.LoadDailyData
0
Comment
Question by:countrymeister
1 Comment
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 2000 total points
ID: 39675192
In object explorer, expand SQL Server Agent under the database instance.
Expand Jobs.
Right-click your job and select View History
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

872 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