vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
| |