brtools commands via DB13

[former_member196171]

Hi Experts

I want to schedule to run a single table stat ( as below)  and backup jobs everyday with DB13 , is it possible run/schedule a command line brconnct or brbackup via DB13 ?

brconnect -u / -c -f stats -o SAPSR3 -t RFBLG -e null -m E -s P10 -f allsel,collect,method,sample,keep

or

brbackup -d util_file -t online_cons -m all -c -u /

Thanks

Al Mamun

[Sriram2009]

Hi

Kindly refer the SAP Note   403704 - BRCONNECT - Enhanced function for Oracle DBA

Regards

SS

[Reagan]

Hello

Check Tx DB20

Another option would would be to schedule a crontab job (Unix/Linux) to be executed whenever you want.

Regards

RB

[former_member196171]

Hi Reagan

Thanks for your reply

corn tab is not an option, I donot know how do I schedule to run everyday a single table stat with DB20 ?

[Former Member]

 I donot know how do I schedule to run everyday a single table stat with DB20 ?

Go to DB20, enter the table name and look at the menu options to select collect/update statistics.

corn tab is not an option

SAP standard functionality gives you the option "update statistics" for all the tables in DB13.

If you want to customize something which is specific for you, then you have to opt other available options (in this case, crontab is one of the option).

Regards,

Nick Loy

[Sriram2009]

Hi

DB20 is SAP Transaction code. you can refer the details in SAP link

https://help.sap.com/saphelp_nw04/helpdata/en/df/455e97747111d6b25100508b6b8a93/content.htm

Corn tab is OS level, better you can use the transaction code DB20 as recommend by Reagan

Regards

Sriram

[Former Member]

You can schedule them via SM36 instead of cron.