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