Monday, July 16, 2012 12:18 PM
Is there way to log the error,when ever package is executing in sqlserveragent?
In brief,Lets say I have package that I have deployed to server.The pacakge is executing fine for two days,third day I got the error.So,now I want to see the error that occured and I dont want to open the package in BIDS.
Can anyone suggest the workflow for this.
Monday, July 16, 2012 12:23 PMModerator
Is it for current failed package?
or you want to implement a logging system for future failures?
If this is for current troubleshooting, you can take a look at SQL Server job history, right click on sql server job and select view history, you can see error message there.
Monday, July 16, 2012 12:55 PM
I want to know the error that may come in future purpose.So,I have to implement logging,
My issue is how to log those error in to sql table and I should able get mail about those errors in the form of table.
Monday, July 16, 2012 9:01 PMModerator
so just follow Jamie's solution (second link in my previous post), to log errors in sql server table
and you can also use send mail task to send a summary or brief description of errors occurred to system administrator
- Proposed As Answer by Khilitchandra Prajapati Tuesday, July 17, 2012 3:07 AM
Tuesday, July 17, 2012 8:49 AM
Thanks for your reply,here I dont want to send the mails to system adminstrator.I need the errors that occured while execution to the group mail.
Thursday, July 26, 2012 11:35 AMModerator
It seems that you need the errors if the job failed? Please correct me if my understanding is wrong.
In that case, you can view the SQL Server Agent error log using SQL Server Management Studio, please see:
Thursday, July 26, 2012 12:44 PM
Thanks for your reply.Here I am not talking about the errors related to job failure.I want to know the errors that takes place while execution of package into sql table.
I have found the solution like configuring the log events for the package and the we can log the errors in to sql table.
- Marked As Answer by lakshmisudha Thursday, July 26, 2012 12:44 PM