SQL Server Performance

JOB Failure

Discussion in 'Getting Started' started by RVG, Feb 16, 2010.

  1. RVG Member

    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
  2. shihab New Member

    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..!
  3. RVG Member

    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

Share This Page