hi,
exec xp_cmdshell 'echo job_status_msg_hehe > test.txt'
can be used to write to file name test.txt but how to allow multiple jobs append their success/failure status and other related custome messages to the file.
Basically, I want all jobs running in a day to log their status to a log/text file so, their status can be easily viewed -- ofcourse jobs will log custom messages containing other info too.
how to go about it?
exec xp_cmdshell 'echo job_status_msg_hehe > test.txt'
can be used to write to file name test.txt but how to allow multiple jobs append their success/failure status and other related custome messages to the file.
Basically, I want all jobs running in a day to log their status to a log/text file so, their status can be easily viewed -- ofcourse jobs will log custom messages containing other info too.
how to go about it?
