SEO

Hello, I have created scheduler, job and scheduled jobs successfully.
However, when I try to execute a simple proc like, sp_who, i get below
error in jsagent.log and sp_sjobhistory (with list_output) shows error
(but not what the error is).

00:00006:00001:2008/05/09 15:57:39.62 worker Job SQL failed.
00:00006:00001:2008/05/09 15:57:39.62 worker callback to fetch results
failed
00:00006:00001:2008/05/09 15:57:39.62 worker jsd_GetResults() failed
00:00006:00001:2008/05/09 15:57:39.62 worker jsj__RunSQLJob() failed


Commands are given below. Any help is much appreciated.

-- create a schedule
sp_sjobcreate @name='sname=Sched_sp_who',@option='starttime=May 9 2008
15:48 PM,repeats=1day'
go
-- create a job
sp_sjobcreate @name='jname=Job_sp_who', @option='jcmd=''exec
sybsystemprocs..sp_who'',jdesc=sp who job'
go
-- create a schedule job
sp_sjobcreate @name='sjname=SchedJob_sp_who',
@option='sname=Sched_sp_who,jname=Job_sp_who,serve r=MYSEVER'
go


--
Message posted using http://www.talkaboutdatabases.com/gr...abases.sybase/
More information at http://www.talkaboutdatabases.com/faq.html