June 20, 2003 at 11:28 am
Hello.
I have a DTS package that runs a Visual Basic ActiveX Script. I can manually execute the DTS package without any problems.
However, when I try to run the DTS Package from a SQL Server Agent job, nothing happens. It just sits there, no warnings, no failure notices, nothing in the logs. It looks like it hangs and if I right-click on the job and select Stop Job, it stops and the 'Last Run Status' shows canceled.
Here are the properties of the Job:
[General Tab]
Enabled
Target Local Server
Category: Uncategorized (local)
Owner: Domain/Administrator
[Steps Tab]
-General
Type: Operating System Command (CMDExec)
Process Exit Code: 0
Command: DTSRun / ~big long alpha string
[Schedule]
Every night at 12:05:00 AM.
I am at a real loss here since I have several other DTS packages that execute fine. The only difference is that they are T-SQL based Types rather than the Operating System Command (CMDExec) Type.
Can it be something with a Job trying to Execute a VB ActiveX Script?
Thank you for your help.
ks
Kevin S.
June 23, 2003 at 8:00 am
This was removed by the editor as SPAM
June 23, 2003 at 10:52 am
Hi,
99% of the scheduling problems it fixed with this article..
DTS schedule problem
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074
JFB
June 23, 2003 at 11:23 am
quote:
Hi,99% of the scheduling problems it fixed with this article..
DTS schedule problem
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074
JFB
Thank you JFB, I printed out that article last week. I completed all of the checks contained therein. That is why I am stumped. No errors anywhere either.
Kevin S.
Kevin S.
June 23, 2003 at 11:28 am
What are you doing inside the pkg?
Are you using cubes?
Make sure the account running sql agent have permissions in the places where DTS is working.
JFB
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply