>-----Original Message-----
>In article <072b01c3b055$145b43a0$a001280a@phx.gbl>,
Paul Leone
><anonymous@discussions.microsoft.com> writes
>>I have a simple DTS package that executes a VB program
>>that I have created. If i manually launch the DTS
>>package, it works with no problems. After I schedule the
>>job, it does not run - it looks like it starts, but it
>>stops before the exe is completed. It does the same
thing
>>if i click on the scheduled jon and hit start.
>>
>>I know it works, because it runs when i manually execute
>>the package. I am running the job from the server
logged
>>on as domain admin, so please do not point me in the
>>direction of microsoft's knowledgebase article:
>>http://support.microsoft.com/?kbid=269074
>>
>>Any help would be appreciated!
>
>Is the SQL Server Agent service set to run under the
same domain admin
>account as you have used on the server? If not your test
is invalid, so
>try that first.
>
>Make sure the VB exe has no UI components in as SQL
Server Agent does
>not support this.
>
>Does the VB app handle errors? Does the VB app log
errors? The answers
>should be yes. If not then you need to rectify this in
order to diagnose
>the problem.
>
>Check the package error log and job step output log for
any errors.
>--
>Darren Green (SQL Server MVP)
>DTS - http://www.sqldts.com
>
>PASS - the definitive, global community for SQL Server
professionals
>http://www.sqlpass.org
>
>.