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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2008-11-03 : 12:10:03
|
| There are 15 jobs need to run every day.How to print all log files for all jobs? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-03 : 12:32:39
|
quote:
Originally posted by Sun Foster
There are 15 jobs need to run every day.How to print all log files for all jobs?
Can you explain clearly? Do you mean you want notification for jobs? |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2008-11-03 : 12:41:21
|
| When you in "Job activity monitor" screen, right click a job, click "view history", you will see "log file viewer", at bottom of screen, you will see job name, duration...How to print all of log files? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-03 : 12:43:29
|
| You can get those information from system tables of MSDB...sysjobs... etc |
|
|
|
|
|
|
How to print jobs log file?