Post reply

Mixing print statement with select

  • February 25, 2005 at 10:48 am

    #86922

    Hi gurus,

    I', getting a problem with the log file for sql agent jobs. I execute all loading jobs from one server, some of which includes SPs to be executed on linked server and hence I execute them using sp_executesql.

    the problem is, in the log file of the job, I'm not getting any of the comments that I use with Print statement, while all results for select statements and rowcounts are available.

    I'was not able to simulate this issue always. I trend seems to be .. with long running queries..

    any suggestion are welcome, as this would help me to make the output log file more meaningful.

    thanks

    --smk

  • February 25, 2005 at 2:29 pm

    #544267

    Instead of using print, try using select. i.e.

    print 'hello'

    use

    select 'hello'

     

  • February 25, 2005 at 3:55 pm

    #544291

    Oh... i cant believe the solution is no simple....thanks buddy.. 

    --shiji

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

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