I am trying to figure out how to cause the JobStep to Error on a condition so
i can have it retry later. The JobStep is written in ActiveX, VBScript. The
JobStep basically does this:


Dim oFso, oFolder, bErr

Set bErr = 0

Set oFso = CreateObject("Scripting.FileSystemObject")
Set oFolder = oFso.GetFolder("C:\Temp")

If oFolder.Files.Count < 10 Then
bErr = 1
End If


Set oFolder = Nothing
Set oFso = Nothing

If bErr = 1 Then
'Cause JobStep to Fail
End If

Here you go:

If bErr = 1 Then
Main = DTSTaskExecResult_Failure
End If

Walter


Main = DTSTaskExecResult_Failure
"John Barr" <JohnBarr (AT) discussions (DOT) microsoft.com> wrote

This is not in a DTS Package, i know how to do that, this is straight from a
jobstep with a type of ActiveX Script.

"Walter Mallon" wrote:

My bad. Perhaps in the vbscript connect to the db and issue a Raiserror.

Walter

"John Barr" <JohnBarr (AT) discussions (DOT) microsoft.com> wrote

Or perhaps try putting a syntax error in the error if then block and see if
that works.


"John Barr" <JohnBarr (AT) discussions (DOT) microsoft.com> wrote