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 @[EMAIL PROTECTED]
'sname=Sched_sp_who',@[EMAIL PROTECTED]
'starttime=May 9 2008
15:48 PM,repeats=1day'
go
-- create a job
sp_sjobcreate @[EMAIL PROTECTED]
'jname=Job_sp_who', @[EMAIL PROTECTED]
'jcmd=''exec
sybsystemprocs..sp_who'',jdesc=sp who job'
go
-- create a schedule job
sp_sjobcreate @[EMAIL PROTECTED]
'sjname=SchedJob_sp_who',
@[EMAIL PROTECTED]
'sname=Sched_sp_who,jname=Job_sp_who,server=MYSEVER'
go
--
Message posted using
http://www.talkaboutdatabases.com/group/comp.databases.sybase/
More information at http://www.talkaboutdatabases.com/faq.html
|
