Exporting Data - 05-25-2005 , 10:54 AM
Can someone please tell me how/where is the log file when I am scheduling an
Export from one database to another. I would like to see the details of the
success or failure of that job.
Re: Exporting Data - 05-25-2005 , 11:11 AM
sysjobhistory table in MSDB stores the job history.
You can also specify at DTS package level to save package execution (package
properties/ logging tab): in this case information will be stored in
sysdtspackagelog and sysdtssteplof tables in MSDB.
"Ty-Ty" <Ty-Ty (AT) discussions (DOT) microsoft.com> wrote