How to archive JobScheduler history tables in a seperate database

Creating the dumpfile

1. Stop the JobScheduler
2. Create a dump of history tables

    /opt/mysql-5.0.15/bin/mysqldump 
    scheduler SCHEDULER_HISTORY SCHEDULER_ORDER_HISTORY  SCHEDULER_ORDER_STEP_HISTORY  SCHEDULER_VARIABLES  
    --hosh1. <host> --port<port>  --useh1. <user>  -p 
    --add-drop-table --skip-comments --single-transaction --opt > scheduler_history.dmp
   

1. create an archive database

    prompt:~> /opt/mysql-5.0.15/bin/mysql --host<host> --porh1. <port> --user<user> -p scheduler_archive 
    mysql> create databasde scheduler_archive
    mysql> exit
   

1. import dump to the archive

    prompt:~>/opt/mysql-5.0.15/bin/mysql --hosh1. <host> --port<port> --useh1. <user> -p scheduler_archive < scheduler_history.dmp
   

how to access logs from the archive by id
setup a new job scheduler instance. This instance should have no own jobs. http://localhost:4139/show_log?task1262811 http://localhost:4139/show_log?ordeh1. backup_pg_sql&history_id403816