Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itissidhu
Starting Member
3 Posts |
 Posted - 2008-07-04 : 06:04:35
|
| By default the Job Step output messages are written to msdb..sysjobstepslogs. Is it possible to write the message to a custom table?Your help is much appreciated. Thanks,Siddharth |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-04 : 13:30:53
|
| Yes create a custom table with desired column:Insert into custom table( desired column names)select columnname1...... from msdb..sysjobstepslogs. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 19:40:37
|
| Sql agent will not write those to user table. |
|
|
|
|
|
|
store SQL Agent Job Step output to custom table