Re: schedule sql file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 20:58:13 -0500

Hi,

Create a .BAT file with the .SQL file using OSQL

OSQL -Uuser -Ppassword -Sserver -ic:\act.sql -oc:\act.out

Then schedule the batch using SQL Agent job with type as "Operating system
command".

Thanks
Hari
MCDBA

""Allen Iverson"" <no_spam@bk.com> wrote in message
news:elWG4I0qEHA.3728@TK2MSFTNGP09.phx.gbl...
> How do I make a daily schedule to execute a sql file? Thanks.
>

Relevant Pages

  • Re: Running Periodic Tasks
    ... >>> I be looking at an app? ... >> then have another .sql file reimport the data to DB1? ... I'm sure there's a way to schedule it as well. ... here's a current look at the query I'm messing with... ...
    (alt.2600)
  • Re: Mass loading SQL SERVER stored procedure
    ... osql is a command line tool that can be used for this purpose. ... You just need to specify the server, database, user as well ... > open .sql file and execute the script to create SPs one by one. ...
    (microsoft.public.sqlserver.clients)
  • Re: Problem with user defined funtions
    ... You need to write you own SQL File where you set your custom ALTER TABLE ... commands for disabling constraints. ... >> replication uses sysdepends to figure out the ordering of articles. ... >> a post-snapshot command to enable the constraints. ...
    (microsoft.public.sqlserver.replication)
  • Re: How to import large MySQL data dump using PHP?
    ... command on my local machine: ... My webhost gives me PhpMyAdmin access, but I can never use that successfully ... The sql file I need to import is 15MB. ...
    (comp.lang.php)
  • Re: Command Prompt help needed
    ... Remote scripting, and the WMI can do a lot of that kind of thing. ... > We are trying to use the SQLEXE command in command prompt to read an .sql> file on a machine and produce the results of a database in text format. ... Is there a tail> command that we put in this so that we can run the sqlexe from a machine in> our office, but the sql file and database are in an office somewhere else? ...
    (microsoft.public.windowsxp.help_and_support)