Solved

.bat file to automate database task

Posted on 2004-04-23
2
679 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

617 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