- 论坛徽章:
- 0
|
回复 #5 lutabo 的帖子
呵呵,那是删了两个job,一个fl,一个fu,貌似不能同时删,脚本如下:
此外,我发现做到一半有问题的job,无法删除,会报错,搞得每次都要换个job名字
Delete Job job_test failed!
Cannot delete active job job_test
Invalid Map Name!
Delete Map job_test failed!
Cannot delete job_test, it is currently in use
Delete Format job_test failed!
Cannot delete job_test, it is currently in use
Invalid Device Array Name!
=====================
#!/bin/ksh
job_name=job_test6
db_name=eaihtest
table_name=wastebook2
check_db_status()
{
ret=`onstat -|grep "On-Line"|wc -l`
if [ $ret != 1 ];
then
echo " 数据库状态非online,请检查!"
exit 1
fi
echo " 数据库状态online "
}
clean_job()
{
onpladm delete job $job_name -fl
onpladm delete job $job_name -fu
onpladm delete map $job_name -fl
onpladm delete map $job_name -fu
onpladm delete format $job_name
onpladm delete device $job_name
}
clean_file()
{
rm -rf "$table_name".unl
rm -rf "$table_name".sql
}
recreate_tb()
{
dbschema -t $table_name -d $db_name "$table_name".sql
dbaccess $db_name <<!
drop table $table_name;
!
dbaccess $db_name "$table_name".sql
}
main()
{
check_db_status
clean_job
clean_file
# 建任务,任务导出
onpladm create job $job_name -d "$table_name".unl -D $db_name -t $table_name -flu
onpladm run job $job_name -fu
# 导出表结构,drop,重建
recreate_tb
# 任务导入
onpladm run job $job_name -fl
clean_job
} |
|