Solved

.bat file to automate database task

Posted on 2004-04-23
2
672 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
Comment Utility
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
Comment Utility
Sybase Adaptive Server Anywhere version 8.0.2.4272 running on Windows Server 2003.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

8 Experts available now in Live!

Get 1:1 Help Now