cancel
Showing results for 
Search instead for 
Did you mean: 

Buckup SQL Script doesn't work

Former Member
0 Kudos

Hi  all,

In ECC i want schedule ASE jobs to  dump transaction logs,i do it fellow the note 1588316 step by step .  In  schedule jobs my sql script doesn't work,but it works in sql command line.

sql script :

dump transaction DEV using config= 'DEVLOG'



Anybody can give me some advise to face this issue?  Thanks in advance.

David Lv

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi  all,

My problem sloved, it's JSagent problem.

@Alcino Melo

use sybmgmtdb

go

sp_js_wakeup "start_js",1

go


after start  JSagent  my sql script can run 


Thanks  all



David Lv

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi.

The syntax is

exec saptools..sp_dumptrans <SID>

go

try this Command And let me know the Status

Regards,

Raj

former_member188883
Active Contributor
0 Kudos

Hi ,

Please share the error you get while scheduling from dbacockpit.

Also share SAP_BASIS release and patch on the SAP system.

Regards,

Deepak Kori