Scheduled Job Fails

Scheduled Job Fails

Post by BJ » Sun, 30 Nov 2003 03:37:00


The code runs ok as in the DTS designer but fails when I
run it as a job. It gives the following error:

DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -
2147220421 (8004043B)

Error string: The task reported failure on execution.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 1100



Error Detail Records:



Error: -2147220421 (8004043B); Provider Error: 0 (0)

Error string: The task reported failure on execution.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 1100



DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1

DTSRun OnStart: DTSStep_DTSSendMailTask_1

DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -
2147220352 (80040480)

Error string: Logon failed: Unable to get the default
MAPI Message Store due to MAPI error 273: The information
store could not be opened.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 9100



Error Detail Records:



Error: -2147220352 (80040480); Provider Error: 0 (0)

Error string: Logon failed: Unable to get the default
MAPI Message Store due to MAPI error 273: The information
store could not be opened.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 9100



DTSRun OnFinish: DTSStep_DTSSendMailTask_1

DTSRun: Package execution complete.
 
 
 

1. Scheduled Job Fails with Error: "Login Failed for "sa"

2. Active Script OK But Scheduled Job Fails

I have an ActiveX Script task in a DTS package which executes fine
within DTS.
However, if I run it as a sheduled job, it fails with a 'path not
found error'. I've cut the code down to the approriate problem and
posted it here, it just makes a simple text file with a name derived
from the current date and time and puts 'Hello World' in the file
although in reality I go on to make an xml file. (make sure your path
exists before you execute it). Why does the scheduled job not execute
this simple task. I have loads of other jobs that run packages to a
schedule and the account is a domain account with windows
administrative rights.

'******************************
' Visual Basic ActiveX Script
'**********************

Const strPath="d:\xml"

Private Function GetDateTime()
Dim strNow, stryear, strMonth, strDay, strTime
strNow = Now
stryear = Mid(strnow, 7, 4)
strMonth = Mid(strnow, 4, 2)
strDay = Left(strnow, 2)
strTime = Replace(Mid(strnow, 12, 8), ":", "")

GetDateTime = stryear + strMonth + strDay + strTime
End Function

Function Main()
Dim fso,f,MyFile 'file objects
Set fso = CreateObject("Scripting.FileSystemObject")
dim strRightNow
strRightNow=GetDateTime()
Set MyFile= fso.CreateTextFile(strPath &"\" & "UPD-"
& strRightNow & ".txt", True) 'This line fails from a scheduled job
MyFile.WriteLine("Hello World")
MyFile.Close
Main = DTSTaskExecResult_Success
End Function

'Error Source= Microsoft VBScript runtime error Error Description:
Path not found Error on Line 25

3. Scheduled Job fails, but package runs successfully...

4. Change in 'sa' password, scheduled jobs failing

5. Executing Process Task Through Scheduled Job fails

6. Change in 'sa' password, scheduled jobs failing

7. Scheduled job fails because locks were not released on the table

8. Scheduled Job Failed

9. SQL Scheduled Job fails, but Query Analyzer runs the task complete

10. SQL Scheduled Job fails, but Query Analyzer runs the task comp

11. Scheduled job fails because locks were not released on the tab

12. Scheduled Jobs Failing

13. DTS Scheduled Job Fail to complete

14. DTS package from scheduled job fails

15. Scheduled job failing