SQLSTATE printed in file

  • Below you can find the output of my SQL jobstep. Is it possible that the [SQLSTATE 01000] is not printed? Is it also possible that the first line in not displayed in the output of the jobstep?

    Job 'HK Get cases DE' : Step 2, 'Amount of cases' : Began Executing 2004-03-24 09:50:43

    beneath you will find the amount of cases that will be deleted the next time the Purge action will run [SQLSTATE 01000]

    amount_of_cases_to_be_deleted

    -----------------------------

    223802

  • I have not seen a way to prevent these and no option to do so. Might could have an external app parse and remove after the DTS package runs but what is you ultimate goal, there may be a better way.

  • I don't think it can be removed from the job history. If you need a clearer message, then you can save the result to a table or file.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply