Skip to Content

Not able to see the output for scheduled job through ASE Job Scheduler

jsagent-errorlog.txt

i tried creating job schedule first so started with:-

sp_sjobcreate @name='sname=hello',@option='starttime=08:00,endtime=23:00,repeats=1day,startdate=7 August 2017,enddate=31 August 2017'

(return status =2) ----> means Datatype error

then ran below:

1> sp_sjobcreate @name='jname=testing',@option='server=TSybase,jcmd=print "Hello World",sname=hello'
2> go
Msg 19094, Level 16, State 1:
Server 'TSybase', Procedure 'sp_sjobcreate', Line 302:
Procedure sp_sjobcreate, the name or id of a scheduled job is needed when options for scheduledjobs are supplied.
(return status = -19094)

1> sp_sjobhelp testing
2> go
sjob_id: 2 name: 'testing'
owner : sa
created : Aug 8 2017 9:10AM
state : enabled
job name : 2 - 'job_2'
schedule name : 3 - 'hello'
server : TSybase
-- job --------:
description
Character or binary data returned from Adaptive Server has been truncated. The client application does not support more than 255 bytes of data as a result column or output parameter.

(return status = 0)

1> sp_sjobhelp 'sname=hello'
2> go
sched_id: 3 name: 'hello'
description:
owner : sa
created : Aug 7 2017 1:44PM
repeating : every day
starttime : 08:00
startdate : 07 Aug 2017
enddate : 31 Aug 2017

1> sp_sjobcontrol @name='testing',@option='run_now'
2> go
(return status = 0)

i cant see any output above.

attaching the jsagent errorlog

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers