I have configured job to write log but it is writing in dbo.sysssislog or in a text file depends upon option you select. Here I want complete error details in "Job Activity Monitor" when I expend a failed job.
It depends on the type of task you are performing in the job. If it is an SSIS package then you can probably configure an output (text) file and it will write all the details into it. Also the message column in sysjobhistory table has max length of 8000 hence it might not write all the error details
Sunder, thanks for your reply. I tried to put things in text output file from SSIS package but it return exception error only, no detail is avaliable in the error log, whereas in SQL 2008 it return whole error in "Job Activity monitor" which is quite handy for me.
Is there any way to get error details in failed jobs step details?