• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

How to view the error log for SQL agent job

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
countrymeister
Asked:
countrymeister
1 Solution
 
Paul JacksonSoftware EngineerCommented:
In object explorer, expand SQL Server Agent under the database instance.
Expand Jobs.
Right-click your job and select View History
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now