Skip to Content
0

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

Aug 08, 2017 at 09:53 AM

35

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers