Here were have create one new cronjob for the database backup
===============================================
crontab -e
#Daily Backup-system tables and master,sysprocs
00,15,30,45 * * * * /opt/sybase/test.sql
==============================================
$ cat test.sql
cd
. ./.profile
cd /opt/sybase/impbackup
echo "Backup Started"
isql -Ucronjob -Pcronjob123 -S << eof
dump database model to "/opt/sybase/impbackup/model.dmp"
go
eof
echo "Backup Completed"
--------------------------------------------------------
1> sp_addlogin cronjob,cronjob123,master
2> go
Password correctly set.
Account unlocked.
New login created.
(return status = 0)
1> use master
2> go
1> sp_adduser cronjob,cronjob
2> go
New user added.
(return status = 0)
1> grant role sso_role to cronjob
2> go
1> grant role oper_role to cronjob
2> go
===============================================
crontab -e
#Daily Backup-system tables and master,sysprocs
00,15,30,45 * * * * /opt/sybase/test.sql
==============================================
$ cat test.sql
cd
. ./.profile
cd /opt/sybase/impbackup
echo "Backup Started"
isql -Ucronjob -Pcronjob123 -S
dump database model to "/opt/sybase/impbackup/model.dmp"
go
eof
echo "Backup Completed"
--------------------------------------------------------
1> sp_addlogin cronjob,cronjob123,master
2> go
Password correctly set.
Account unlocked.
New login created.
(return status = 0)
1> use master
2> go
1> sp_adduser cronjob,cronjob
2> go
New user added.
(return status = 0)
1> grant role sso_role to cronjob
2> go
1> grant role oper_role to cronjob
2> go
Comments
Post a Comment