Problems Configuring Job Scheduler

Discussion:

Problems Configuring Job Scheduler - 12.5.3

(too old to reply)

Dave Storey

2008-04-14 23:30:58 UTC

Hello,

I have tried everything I can possibly think of, and have read the manuals
like crazy, but I cannot get Job Scheduler to work.

I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase Central
Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version 2.1.

My Remote Servers:

exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go

After creating a 'Database Backup' Job using a template, creating a
Schedule, and then Scheduling the job, it runs but I get:

Exit Code:3

I have tried specifying MYDB_DB as the target server, and also MYDB_DB_BS as
the target server, but neither work. I can't determine in the manuals which
I am supposed to specify, there are no examples shown which is very
frustrating to me.

In the Log, I get:

00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00024:2008/04/14 18:50:00.62 kernel extended error information:
hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost its
Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not connect
to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively refused
it.

.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to remote
server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site SYB_JSAGENT. Trying
the next query entry of this server, if any.
00:00000:00028:2008/04/14 18:50:01.76 server Error: 7235, Severity: 17,
State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry found for
the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT. Aborting this site
handler, as no remote server responded. Please make sure the remote server
is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host process
disconnected: ncrwkshortr suid: 1
00:00000:00026:2008/04/14 18:50:01.76 server Error: 1608, Severity: 18,
State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00026:2008/04/14 18:50:01.76 kernel extended error information:
hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task failed
(re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state set
to stop

My SQL.INI:

[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002

[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000

[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003

[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001

[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004

[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005

Any help or suggestions would be greatly appreciated.

Thank you

Jaikishan

2008-04-15 08:45:07 UTC

Permalink

Hi Dave,

Firstly I would suggest upgrading the ASE to 12.5.4/ 15.0.2 as there has
been many fixes for the Job Scheduler after 12.5.3.

Can you try changing the port no for the MYDB_DB_JSAGENT entry in the
sql.ini file? Also did the jsagent process start? What did the jsagent
log contain?

Regards,
~Jaikishan

Post by Dave Storey
Hello,
I have tried everything I can possibly think of, and have read the manuals
like crazy, but I cannot get Job Scheduler to work.
I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase Central
Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version 2.1.
exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go
After creating a 'Database Backup' Job using a template, creating a
Exit Code:3
I have tried specifying MYDB_DB as the target server, and also MYDB_DB_BS as
the target server, but neither work. I can't determine in the manuals which
I am supposed to specify, there are no examples shown which is very
frustrating to me.
00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost its
Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not connect
to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively refused
it.
.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to remote
server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site SYB_JSAGENT. Trying
the next query entry of this server, if any.
00:00000:00028:2008/04/14 18:50:01.76 server Error: 7235, Severity: 17,
State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry found for
the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT. Aborting this site
handler, as no remote server responded. Please make sure the remote server
is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host process
disconnected: ncrwkshortr suid: 1
00:00000:00026:2008/04/14 18:50:01.76 server Error: 1608, Severity: 18,
State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task failed
(re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state set
to stop
[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002
[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000
[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003
[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001
[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004
[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005
Any help or suggestions would be greatly appreciated.
Thank you

Dave Storey

2008-04-15 14:49:20 UTC

Permalink

Thanks, I don't see 12.5.4 as a downloadable EBF. Is this something that my
client needs to get thru his Sybase annual maintenance contract? All of the
12.5.4 EBF's say that you already need to be at 12.5.4 to install them.

My jsagent log seems correct:

00:03904:03412:2008/04/14 18:42:32.30 jamain SYB_JSAGENT connected with Job
Scheduler Task on port 5004
00:03904:03412:2008/04/14 18:42:32.30 jamain SYB_JSAGENT waiting for
connection
00:03904:03412:2008/04/14 18:42:32.53 jamain Initializing SYB_JSAGENT
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating list resources.
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating queue resources.
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating thread resources.
00:03904:03412:2008/04/14 18:42:32.54 jamain Initializing connection pool.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'master'.

00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'sybmgmtdb'.

00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'master'.

00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'sybmgmtdb'.

00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'master'.

00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'sybmgmtdb'.

00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'master'.

00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'sybmgmtdb'.

00:03904:03412:2008/04/14 18:42:32.66 jamain SYB_JSAGENT ready.

Post by Jaikishan
Hi Dave,
Firstly I would suggest upgrading the ASE to 12.5.4/ 15.0.2 as there has
been many fixes for the Job Scheduler after 12.5.3.
Can you try changing the port no for the MYDB_DB_JSAGENT entry in the
sql.ini file? Also did the jsagent process start? What did the jsagent log
contain?
Regards,
~Jaikishan

Post by Dave Storey
Hello,
I have tried everything I can possibly think of, and have read the
manuals like crazy, but I cannot get Job Scheduler to work.
I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase Central
Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version 2.1.
exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go
After creating a 'Database Backup' Job using a template, creating a
Exit Code:3
I have tried specifying MYDB_DB as the target server, and also MYDB_DB_BS
as the target server, but neither work. I can't determine in the manuals
which I am supposed to specify, there are no examples shown which is very
frustrating to me.
00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost its
Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not
connect to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively refused
it.
.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to remote
server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site SYB_JSAGENT. Trying
the next query entry of this server, if any.
00:00000:00028:2008/04/14 18:50:01.76 server Error: 7235, Severity: 17,
State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry found
for the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT. Aborting this
site handler, as no remote server responded. Please make sure the remote
server is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host process
disconnected: ncrwkshortr suid: 1
00:00000:00026:2008/04/14 18:50:01.76 server Error: 1608, Severity: 18,
State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task failed
(re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state
set to stop
[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002
[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000
[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003
[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001
[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004
[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005
Any help or suggestions would be greatly appreciated.
Thank you

Mark K

2008-04-16 05:43:02 UTC

Permalink

The IR/MR versions (like 12.5.4) can be downloaded from the SPDC
(http://sybase.subscribenet.com). The ESDs can be downloaded from the
downloads/EBFs site.

Mark Kusma

Post by Dave Storey
Thanks, I don't see 12.5.4 as a downloadable EBF. Is this something that
my client needs to get thru his Sybase annual maintenance contract? All
of the 12.5.4 EBF's say that you already need to be at 12.5.4 to install
them.
00:03904:03412:2008/04/14 18:42:32.30 jamain SYB_JSAGENT connected with
Job Scheduler Task on port 5004
00:03904:03412:2008/04/14 18:42:32.30 jamain SYB_JSAGENT waiting for
connection
00:03904:03412:2008/04/14 18:42:32.53 jamain Initializing SYB_JSAGENT
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating list resources.
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating queue resources.
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating thread resources.
00:03904:03412:2008/04/14 18:42:32.54 jamain Initializing connection pool.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.66 jamain SYB_JSAGENT ready.

Post by Dave Storey
Hello,
I have tried everything I can possibly think of, and have read the
manuals like crazy, but I cannot get Job Scheduler to work.
I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase
Central Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version
2.1.
exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go
After creating a 'Database Backup' Job using a template, creating a
Exit Code:3
I have tried specifying MYDB_DB as the target server, and also
MYDB_DB_BS as the target server, but neither work. I can't determine in
the manuals which I am supposed to specify, there are no examples shown
which is very frustrating to me.
00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00024:2008/04/14 18:50:00.62 kernel extended error
information: hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost
its Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not
connect to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively
refused it.
.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to
remote server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site
SYB_JSAGENT. Trying the next query entry of this server, if any.
00:00000:00028:2008/04/14 18:50:01.76 server Error: 7235, Severity: 17,
State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry found
for the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT. Aborting this
site handler, as no remote server responded. Please make sure the remote
server is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host process
disconnected: ncrwkshortr suid: 1
00:00000:00026:2008/04/14 18:50:01.76 server Error: 1608, Severity: 18,
State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00026:2008/04/14 18:50:01.76 kernel extended error
information: hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task failed
(re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state
set to stop
[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002
[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000
[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003
[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001
[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004
[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005
Any help or suggestions would be greatly appreciated.
Thank you

Dave Storey

2008-04-16 14:42:59 UTC

Permalink

The 12.5.3 IR is downloadable directly from the EBF's site, but 12.5.4 isn't
for some reason.

I guess I need to get my client to call Sybase to request the 12.5.4 version
so it will be available from the "subscribenet" site?

Post by Mark K
The IR/MR versions (like 12.5.4) can be downloaded from the SPDC
(http://sybase.subscribenet.com). The ESDs can be downloaded from the
downloads/EBFs site.
Mark Kusma

Post by Dave Storey
Hello,
I have tried everything I can possibly think of, and have read the
manuals like crazy, but I cannot get Job Scheduler to work.
I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase
Central Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version
2.1.
exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go
After creating a 'Database Backup' Job using a template, creating a
Exit Code:3
I have tried specifying MYDB_DB as the target server, and also
MYDB_DB_BS as the target server, but neither work. I can't determine
in the manuals which I am supposed to specify, there are no examples
shown which is very frustrating to me.
00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00024:2008/04/14 18:50:00.62 kernel extended error
information: hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost
its Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not
connect to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively
refused it.
.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to
remote server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site
SYB_JSAGENT. Trying the next query entry of this server, if any.
17, State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry
found for the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT.
Aborting this site handler, as no remote server responded. Please make
sure the remote server is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host process
disconnected: ncrwkshortr suid: 1
18, State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00026:2008/04/14 18:50:01.76 kernel extended error
information: hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task failed
(re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state
set to stop
[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002
[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000
[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003
[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001
[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004
[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005
Any help or suggestions would be greatly appreciated.
Thank you

Mark K

2008-04-16 15:06:06 UTC

Permalink

Yeah, that's an oddity. 12.5.3 was not a stand-alone IR, which is why it is
available on the EBF site. 12.5.3 required you to have 12.5.2 already
installed. That would not be a requirement for a normal IR.

Mark Kusma

Post by Dave Storey
The 12.5.3 IR is downloadable directly from the EBF's site, but 12.5.4
isn't for some reason.
I guess I need to get my client to call Sybase to request the 12.5.4
version so it will be available from the "subscribenet" site?

Post by Mark K
The IR/MR versions (like 12.5.4) can be downloaded from the SPDC
(http://sybase.subscribenet.com). The ESDs can be downloaded from the
downloads/EBFs site.
Mark Kusma

Post by Dave Storey
Thanks, I don't see 12.5.4 as a downloadable EBF. Is this something
that my client needs to get thru his Sybase annual maintenance contract?
All of the 12.5.4 EBF's say that you already need to be at 12.5.4 to
install them.
00:03904:03412:2008/04/14 18:42:32.30 jamain SYB_JSAGENT connected with
Job Scheduler Task on port 5004
00:03904:03412:2008/04/14 18:42:32.30 jamain SYB_JSAGENT waiting for
connection
00:03904:03412:2008/04/14 18:42:32.53 jamain Initializing SYB_JSAGENT
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating list resources.
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating queue resources.
00:03904:03412:2008/04/14 18:42:32.53 jamain Allocating thread resources.
00:03904:03412:2008/04/14 18:42:32.54 jamain Initializing connection pool.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.65 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'master'.
00:03904:03412:2008/04/14 18:42:32.66 jamain Server message: Changed
database context to 'sybmgmtdb'.
00:03904:03412:2008/04/14 18:42:32.66 jamain SYB_JSAGENT ready.

Post by Jaikishan
Hi Dave,
Firstly I would suggest upgrading the ASE to 12.5.4/ 15.0.2 as there
has been many fixes for the Job Scheduler after 12.5.3.
Can you try changing the port no for the MYDB_DB_JSAGENT entry in the
sql.ini file? Also did the jsagent process start? What did the jsagent
log contain?
Regards,
~Jaikishan

Post by Dave Storey
Hello,
I have tried everything I can possibly think of, and have read the
manuals like crazy, but I cannot get Job Scheduler to work.
I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase
Central Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version
2.1.
exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go
After creating a 'Database Backup' Job using a template, creating a
Exit Code:3
I have tried specifying MYDB_DB as the target server, and also
MYDB_DB_BS as the target server, but neither work. I can't determine
in the manuals which I am supposed to specify, there are no examples
shown which is very frustrating to me.
00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00024:2008/04/14 18:50:00.62 kernel extended error
information: hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost
its Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not
connect to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively
refused it.
.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to
remote server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site
SYB_JSAGENT. Trying the next query entry of this server, if any.
17, State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry
found for the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT.
Aborting this site handler, as no remote server responded. Please make
sure the remote server is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host
process disconnected: ncrwkshortr suid: 1
18, State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00026:2008/04/14 18:50:01.76 kernel extended error
information: hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task
failed (re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state
set to stop
[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002
[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000
[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003
[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001
[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004
[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005
Any help or suggestions would be greatly appreciated.
Thank you

Dave Storey

2008-04-24 14:45:57 UTC

Permalink

Thank you for the help,

My problem has been resolved simply by installing the very latest EBF for
12.5.3 (which is 13331), I was using the second most recent EBF # 13203.

I think it may be related to a fix that is mentioned regarding single-CPU
machines, since all of my failed attempts were on single-CPU machines, and
the only one I had working correctly was the install I did a few years ago
on their dual-CPU server. It says this was resolved in 13061, but whatever.
;-)

Post by Jaikishan
Hi Dave,
Did you try changing the port no for MYDB_DB_JSAGENT? What is the result
with this?
From the jsagent log

Post by Dave Storey
00:03904:03412:2008/04/14 18:42:32.66 jamain SYB_JSAGENT ready.

Post by Jaikishan

Post by Dave Storey
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task

lost its Agent connection (No error)
if you look at the timestamps, the jsagent was up at 18:42 and ASE log
says the connection failed at 18:50. So could be that the JS agent died or
exited before this.
Regards,
~Jaikishan

Post by Dave Storey
Hello,
I have tried everything I can possibly think of, and have read the
manuals like crazy, but I cannot get Job Scheduler to work.
I'm using ASE 12.5.3 (EBF 13203) on Win XP Pro (SP2), with Sybase
Central Plug-in 4.3 (EBF 12777), and Job Scheduler Templates version
2.1.
exec sp_addserver SYB_JSAGENT, ASEnterprise, MYDB_DB_JSAGENT
go
exec sp_addserver MYDB_DB_JSLOOP, ASEnterprise, MYDB_DB
go
exec sp_addexternlogin MYDB_DB_JSLOOP, sa, sa
go
After creating a 'Database Backup' Job using a template, creating a
Exit Code:3
I have tried specifying MYDB_DB as the target server, and also
MYDB_DB_BS as the target server, but neither work. I can't determine
in the manuals which I am supposed to specify, there are no examples
shown which is very frustrating to me.
00:00000:00024:2008/04/14 18:50:00.62 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00024:2008/04/14 18:50:00.62 kernel extended error
information: hostname: ncrwkshortr login: sa
00:00000:00013:2008/04/14 18:50:01.33 kernel Job Scheduler Task lost
its Agent connection (No error)
00:00000:00028:2008/04/14 18:50:01.75 kernel nl__connect: Could not
connect to site 'MYDB_DB_JSAGENT', socket 17.
00:00000:00028:2008/04/14 18:50:01.76 kernel nl__connect: net_connect
failed to connect to site 'MYDB_DB_JSAGENT'.
: No connection could be made because the target machine actively
refused it.
.
00:00000:00028:2008/04/14 18:50:01.76 server Failed to connect to
remote server MYDB_DB_JSAGENT tcp ether mycomp 5004 for site
SYB_JSAGENT. Trying the next query entry of this server, if any.
17, State: 0
00:00000:00028:2008/04/14 18:50:01.76 server No other query entry
found for the remote server MYDB_DB_JSAGENT - site SYB_JSAGENT.
Aborting this site handler, as no remote server responded. Please make
sure the remote server is accepting connections.
00:00000:00026:2008/04/14 18:50:01.76 kernel Cannot send, host process
disconnected: ncrwkshortr suid: 1
18, State: 4
00:00000:00026:2008/04/14 18:50:01.76 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
00:00000:00026:2008/04/14 18:50:01.76 kernel extended error
information: hostname: mycomp login: sa
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task failed
(re)connecting to its Agent (No error)
00:00000:00013:2008/04/14 18:50:10.10 kernel Job Scheduler Task state
set to stop
[MYDB_DB_MS]
master=TCP,mycomp,5002
query=TCP,mycomp,5002
[MYDB_DB]
master=TCP,mycomp,5000
query=TCP,mycomp,5000
[MYDB_DB_XP]
master=TCP,mycomp,5003
query=TCP,mycomp,5003
[MYDB_DB_BS]
master=TCP,mycomp,5001
query=TCP,mycomp,5001
[MYDB_DB_JSAGENT]
master=TCP,mycomp,5004
query=TCP,mycomp,5004
[MYDB_DB_JSLOOP]
master=TCP,mycomp,5005
query=TCP,mycomp,5005
Any help or suggestions would be greatly appreciated.
Thank you