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 |
|
sravanim
Yak Posting Veteran
58 Posts |
 Posted - 2013-03-26 : 10:38:43
|
| Is there any way to get job history after executing sp_purage_history? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-03-26 : 10:50:22
|
| The history is stored in the sysjobhistory table in the msdb database. If you make regular backups of msdb (and you should) you can restore them to another database and copy the contents of sysjobhistory to a permanent store. Or modify your purge job to copy the history elsewhere beforehand. |
 |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-03-26 : 11:08:02
|
| how to see lock time in sqlserver? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-03-26 : 11:11:48
|
| What does lock time have to do with job history? |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-03-26 : 11:17:01
|
| This one is different post. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-03-26 : 11:37:02
|
| Please start a new thread for new questions. |
|
|
|
|
|
|
history of job