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.

Thank you.

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.

Francesco Anti

"Ty-Ty" <Ty-Ty (AT) discussions (DOT) microsoft.com> wrote