AnsweredAssumed Answered

In dSeries, is it possible to render a SQL job failed based on the LStatus output ?

Question asked by HC2014 on Feb 16, 2016
Latest reply on Feb 22, 2016 by JustinHubbard

In dSeries, is it possible to render a SQL job failed based on the LStatus output tex?

 

Field

Value

Application Name

XXXXX

Generation Number

136

Job Name

YYYYY

State

COMPLETE

Job Type

SQL

LStatus

exec updated -1 rows

Start Time

Mon 15 Feb 2016 03:00:03 EST

End Time

Mon 15 Feb 2016 03:00:03 EST

Agent Name

ZZZZZ

Average Execution Time

0 mins

Anticipated End Time

Mon 15 Feb 2016 03:00:03 EST

Critical Path

Yes

Completion Code

0

Overdue if execution time exceeds (in minutes)

120

Submission Count

1

DB user

AAAAA

DB URL

jdbc:sqlserver://BBB.ON.CA:1433;DatabaseName=master

SQL command

Exec SERVER.msdb.dbo.sp_start_job @job_name ='STEP1'

Outcomes