[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2409
  • Last Modified:

Sybase, Can't start Js agent

Hi,
I'm trying to start my job scheduler agent, but its always returned me error, how do I triubleshoot and get to know which user I assigned for start up this agent ?


1> use sybmgmtdb
2> go
1> sp_js_wakeup 'start_js',1
2> go
(return status = 1)
1>


Here is the error found in server.log

00:00000:00020:2009/07/14 21:59:07.29 kernel  Installed Job Scheduler sequencer code version 0.27 - 27 tokens
00:00000:00020:2009/07/14 21:59:08.43 kernel  Job Scheduler Task state set to running, startcount 2.
00:00000:00020:2009/07/14 21:59:09.42 kernel  Job Scheduler Task connected with Agent on port 5012
00:00000:00020:2009/07/14 21:59:09.42 server  Error: 571, Severity: 16, State: 1
00:00000:00020:2009/07/14 21:59:09.42 server  Invalid user specified, password left unchanged.
00:00000:00020:2009/07/14 21:59:09.59 kernel  Job Scheduler Task lost its Agent connection (No error)
00:00000:00020:2009/07/14 21:59:15.54 kernel  Job Scheduler Task failed (re)connecting to its Agent (No error)
00:00000:00020:2009/07/14 21:59:15.56 kernel  Job Scheduler Task state set to stop
0
motioneye
Asked:
motioneye
1 Solution
 
Kamaraj SubramanianApplication Support AnalystCommented:
I found a couple solved cases at sybase.com that are similar to what you're seeing (though they are on ASE 12.5.x and
not ASE 15.0.1).

Each of the cases recommends running dbcc checkcatalog. If checkcatalog reports any problems you can then a) run dbcc
checkcatalog's fix option or b) drop and recreate any (faulty) indexes reported by checkcatalog.

If you don't know which database the error was generated from then you should run dbcc checkcatalog in all databases.

Since you appear to have some corruption you may want to look at running a full set of dbcc's against all of your
databases at some point. (If you go this route I'd suggest setting up and configuring a dbccdb database.)

source : http://www.mydatabasesupport.com/forums/sybase/240620-invalid-column-length-value-must-between-0-5-a.html
0
 
motioneyeAuthor Commented:
Hi,
How do you know my error appears as related to corruption? I really thought this might something to do with user account use to start Js_agent, but my problem is I do not know which account/use used to start this agent...
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now