Re: Automated DTS package will not run

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 02/14/04


Date: Sat, 14 Feb 2004 09:13:01 GMT

Hi Scott,

Thanks for your update and Olu's reply.

Besides Olu's question, could you run the DTS package in the design windows
of the package? Is it successful or any information? When the mail is send
to you, what is the job history? You could also run the following code in
you Query Analyzer and collect the information of this job.

select * from msdb..sysjobs
select * from msdb..sysjobsteps
select * from msdb..sysjobhistory
select * from msdb..sysnotifications
select * from msdb..sysjobservers
select * from msdb..sysjobschedules

I am waiting on your reply. Thanks

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.