Skip to Content
0

In ASE Cockpit scheduled jobs not possible

Mar 03, 2017 at 01:58 PM

152

avatar image

In ASE Cockpit the created scheduled jobs for dumps will not start at the scheduled time, I get the following error messages in the ASE errorlog:

"Please add externlogin for job user and target server for callout id xxxxx and scheduled job id xx"

Version: SAP ASE 16.0

Where do I have to configure the externlogin and target server?

Any answers are appreciated.

Michael

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ankitha Malalur Gopal
Apr 14, 2017 at 09:19 AM
0

Hi Michael,

You may follow the below steps and let us know if it helps:

Renew external logins (Component Integration Service)

After changing the user passwords in the SSFS, you have to renew all external logins whose passwords were changed. This includes at least the external login for the Server SYB_JSTASK, which uses the 'sapsa' login. You can get a list of all external remote logins like this:

  1. Log in as user 'syb<sid>' on your database host:

    HOST> su - syb<sid>
  2. Log in to your Sybase ASE database via isql with user 'sapsa':

    HOST ASE-15_0/install> isql -X -Usapsa -S<SID> -w1024
    use master
    go
    sp_helpexternlogin
    go
  3. Note down the existing external logins. Drop the external logins and create new ones. This is necessary, because no stored procedure for modifying external logins exists.

    exec sp_dropexternlogin <server>, <login>
    go
  4. Create the external logins:

    exec sp_addexternlogin <server>, <login>, <externlogin>, '<new sapsa password>'
    go

    Repeat the drop/create process for every changed user/password.

Best Regards,

Ankitha

SAP Product Support

Share
10 |10000 characters needed characters left characters exceeded