Hi,I'd create a job that is a set of T-SQL statement( has error in this SQL commands) and I want to execute the job this results in failure of the job and I want the error statement to be printed in to the text file, rather than sending me an e-mail.Thanks & Regards,Ravi Varma
Ravi, In your Job Step Properties -> Advanced option, look for output file option and give it a path and file name will populate the out put of the results including errors. My suggestion, if something fails, you should use SQL Mail to send out an email and using your outlook to organize the errors for the future references may be a good idea. In any case, you can do both..!
Hi shihab, In advanced options I had given a output text file. I have a job of 4 steps that in first step i did execute some sql statements but If there is error in the first step(that error ) should get printed into the text file. Thanks & Regards, Ravi
