dbTalk Databases Forums  

job history

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


Discuss job history in the microsoft.public.sqlserver.dts forum.



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

Default job history - 09-08-2003 , 12:53 PM






Hi, I need help on how to view the job history for a dts
package for like one month ago? I know how to view the
job history by right click on the job and view job
history. But that only shows the history of two weeks
from now. How do I view the earlier history before two
weeks ago say one month ago? Thank you in advance.

Reply With Quote
  #2  
Old   
John Bell
 
Posts: n/a

Default Re: job history - 09-08-2003 , 01:28 PM






Hi

The size is limited on the properties of the SQL Server Agent/Job System. If
you wish to restore the information, then you will have to recover your MSDB
database to a point where the information was not purged.

John

"baobei" <baobei1627 (AT) aol (DOT) com> wrote

Quote:
Hi, I need help on how to view the job history for a dts
package for like one month ago? I know how to view the
job history by right click on the job and view job
history. But that only shows the history of two weeks
from now. How do I view the earlier history before two
weeks ago say one month ago? Thank you in advance.



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.