dbTalk Databases Forums  

Write to msdb.sysjobhistory.messages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Write to msdb.sysjobhistory.messages in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Don Reith
 
Posts: n/a

Default Write to msdb.sysjobhistory.messages - 01-27-2005 , 12:56 PM






When you execute a package from SQL Server Agent there is some run
information that gets written to msdb.sysjobhistory.messages. Is there a
way to use a script action to append some text to that information? This
seems like an obvious thing to do to me but I'm banging my head against the
wall trying to figure out a way to do it.

Thanks
Don

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: Write to msdb.sysjobhistory.messages - 01-27-2005 , 01:30 PM






Directly updating system tables isn't supported or
recommended.
Doing your own logging is probably a better way to go.

-Sue

On Thu, 27 Jan 2005 10:56:40 -0800, Don Reith
<don (AT) nospam (DOT) reith.ca> wrote:

Quote:
When you execute a package from SQL Server Agent there is some run
information that gets written to msdb.sysjobhistory.messages. Is there a
way to use a script action to append some text to that information? This
seems like an obvious thing to do to me but I'm banging my head against the
wall trying to figure out a way to do it.

Thanks
Don


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.