SEO

Hi,

I scheduled a job on Sybase ASE Job Scheduler.
The job fails and the following message is seen in the log.

00:00006:00001:2006/02/14 13:05:00.61 worker No password found for
user <my_login> on server <SERVER>
00:00006:00001:2006/02/14 13:05:00.61 worker jsj__TargetInfo() failed
00:00006:00001:2006/02/14 13:05:00.66 worker No job output connection
pool provided
00:00006:00001:2006/02/14 13:40:00.82 worker No password found for
user <my_login> on server <SERVER>
00:00006:00001:2006/02/14 13:40:00.82 worker jsj__TargetInfo() failed
00:00006:00001:2006/02/14 13:40:00.88 worker No job output connection
pool provided

Any help is appreciated.

Regards,
Dellit.

I haven't worked with JS so FWIW ...

From sybase.com, Solved Cases (case # 10987270):

=============================

Steps to double check to make sure you have set job scheduler up correctly:

1.sp_addserver loopback, null, <local_server_name>

2. Need directory services entry for jsagent, add it using dsedit

- <servername>_jsagent, <port_number>

3. sp_addserver SYB_JSAGENT, NULL, <servername>

4. sp_adduser <test_user> to sybmgmtdb

5. grant js_admin_role and js_user_role to <test_user>

6. sp_addexternlogin loopback, <test_user>, <test_user>,
<test_user_remote_password>

=============================

Other than that ... has this job every worked and if so, what has changed
recently?




dellit wrote:
> Hi,
>
> I scheduled a job on Sybase ASE Job Scheduler.
> The job fails and the following message is seen in the log.
>
> 00:00006:00001:2006/02/14 13:05:00.61 worker No password found for
> user <my_login> on server <SERVER>
> 00:00006:00001:2006/02/14 13:05:00.61 worker jsj__TargetInfo() failed
> 00:00006:00001:2006/02/14 13:05:00.66 worker No job output connection
> pool provided
> 00:00006:00001:2006/02/14 13:40:00.82 worker No password found for
> user <my_login> on server <SERVER>
> 00:00006:00001:2006/02/14 13:40:00.82 worker jsj__TargetInfo() failed
> 00:00006:00001:2006/02/14 13:40:00.88 worker No job output connection
> pool provided
>
> Any help is appreciated.
>
> Regards,
> Dellit.
>

Mark,

Thanks for the reply. I missed the last step of adding an extern login.

But once I added it the JS Task/Agent terminated.

00:00001:25131:2006/02/21 06:19:32.32 jamain -> JS: Task/Agent
connection terminated.
00:00001:25131:2006/02/21 06:19:32.33 jamain -> JS: Failed to receive
communication buffer.
00:00001:25131:2006/02/21 06:19:32.39 jamain SYB_JSAGENT waiting for
connection

Could you please advice.

>>Other than that ... has this job every worked and if so, what has changed
recently?

this is the first time we have installed the job scheduler on SYBASE
and we want to test its functionalities.

Regards,
Dellit.

Again, I don't have any working experience with JS so FWIW ...

1 - verify SYB_JSAGENT was added (sp_addserver) properly; check results of
'sp_helpserver SYB_JSAGENT'

2 - verify SYB_JSAGENT's entry in the interfaces file; make sure it has
been configured on its own port #; make sure the ASE and SYB_JSAGENT are
accessing the same interfaces file (if using different interfaces files
make sure they are the same in terms of the definitions for the ASE and
SYB_JSAGENT)

3 - contact Sybase TS

dellit wrote:

> Mark,
>
> Thanks for the reply. I missed the last step of adding an extern login.
>
> But once I added it the JS Task/Agent terminated.
>
> 00:00001:25131:2006/02/21 06:19:32.32 jamain -> JS: Task/Agent
> connection terminated.
> 00:00001:25131:2006/02/21 06:19:32.33 jamain -> JS: Failed to receive
> communication buffer.
> 00:00001:25131:2006/02/21 06:19:32.39 jamain SYB_JSAGENT waiting for
> connection
>
> Could you please advice.
>
>
>>>Other than that ... has this job every worked and if so, what has changed
>
> recently?
>
> this is the first time we have installed the job scheduler on SYBASE
> and we want to test its functionalities.
>
> Regards,
> Dellit.
>