<div>
<div class="content wysiwyg-content">
I tired to look into the Error Logs for my sql agent job i created But I see nothing there.<br />
<br />
I set up an Alert to get an email if the job fails.<br />
All i get is <br />
<br />
JOB RUN: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'LoadData' was run on 11/25/2013 at 10:40:00 AM<br />
DURATION: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 hours, 0 minutes, 1 seconds<br />
STATUS: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Failed<br />
MESSAGES: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The job failed. &nbsp;The Job was invoked by Schedule 17 (DataLoadSchedule). &nbsp;The last step to run was step 1 (1 - LoadData).<br />
<br />
It does not tell me anything specifc<br />
My command is a stored procedure, which when run by itself work fine.<br />
<br />
The command is exec dbo.LoadDailyData
</div>
</div>


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

How to view the error log for SQL agent job

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.