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
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