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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-14 : 22:06:27
|
| Paulo writes "I want to know how can i create a log of a job in a txt file by adding a line in transact sql of that job.Thanks" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-15 : 05:26:47
|
| Not sure how you could do this in T-SQL, but there are a few alternatives.1. Get the job to write to the NT application event log (do this on the Notifications tab of the job dialog). You can select when you want this to be done (e.g. every time, on failure, etc.)2. Add a step to the job of type 'Operating System Command (CmdExec)' that writes to the file you want. |
 |
|
|
|
|
|
Job log