Solved

.bat file to automate database task

Posted on 2004-04-23
2
674 Views
Last Modified: 2007-12-19
We run Veritas Netbackup Proffesional and unfortuantley it has started failing its maintainence routine. To fix this Veritas sent me a .sql file that I have to run manually usint their Interactive SQL interface. The problem is that this is a user intensive task and really needs to be run every day, so is really starting to grind.
Is there some way I can script the tast into a batch file that I can then run at scheduled times?? I have tried and got as far as the following, but this doesnt seem to work:

>
dbisqlc.exe" -c uid=dba;pwd=sql;dbf="C:\Program Files\VERITAS NetBackup Professional\Data\Catalog\NBP.db" "C:\Documents and Settings\Administrator\Desktop\GroomError-DiffChainCut_262513\GroomError-DiffChainCut.sql"
>

Can anyone help??
0
Comment
Question by:GrantMitchell
2 Comments
 
LVL 1

Accepted Solution

by:
yoav_aviram earned 130 total points
ID: 10917299
If you can provide a little more information, such as what database you are working
with and on what platform, i might be able to help you more.

I suggest you try:

dbisqlc.exe [Arguments] < [SQL File]

-- The important part here is the "<" charecter.
0
 

Author Comment

by:GrantMitchell
ID: 10917365
Sybase Adaptive Server Anywhere version 8.0.2.4272 running on Windows Server 2003.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visual Studio 2010 with SyBase 3 836
Sybase - How to edit cron schedule for sybase backups 3 848
Need help with SYBASE syntax 5 73
SyBase Query Syntax Date Time conversion 4 27
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now