Skip to Content
avatar image
Former Member

In ASE Cockpit scheduled jobs not possible

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 14, 2017 at 09:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded