#1
  1. No Profile Picture
    Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Aug 2005
    Posts
    559
    Rep Power
    16

    automating sql commands


    hi,

    I would like to run scripts automatically in SQL Server 2008. I have script that creates databases, builds tables and updates them. I've run these manually, but it takes a long time to do this and I have roughly 12 databases to update. What is the best way I can automate these scripts so they can run by themselves? I read something about using a 'scripter' class, but is that the best option I have?

    Thanks!

    Mag
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Aug 2008
    Location
    USA
    Posts
    1,606
    Rep Power
    347
    Hi

    you have one option i.,e SQL Batch job this will automate your request.
    refer below article on batch job
    Implement Jobs
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree

    Jquery Shake Effect ,
    Andriod KitKat


    Thank You,
    KiranK
  4. #3
  5. No Profile Picture
    Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Aug 2005
    Posts
    559
    Rep Power
    16
    thanks very much-
  6. #4
  7. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,665
    Rep Power
    283
    If you have access to sql server agent you can create stored procedure with your script and scedule execute that stored procedure in sql server agent it is easy and very reliable
    GK
    __________________________________________________ _____
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree
  8. #5
  9. No Profile Picture
    Banned
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2013
    Posts
    1
    Rep Power
    0
    Thanks for sharing good work.

Similar Threads

  1. Automating EVERYTHING
    By mystic7 in forum ASP Development
    Replies: 2
    Last Post: June 3rd, 2008, 01:55 PM
  2. Automating a Query
    By gwwbjw in forum Microsoft Access Help
    Replies: 2
    Last Post: October 27th, 2007, 10:24 PM
  3. Automating Keypress
    By andy1210 in forum ASP Development
    Replies: 1
    Last Post: April 16th, 2007, 08:18 AM
  4. Access commands vs SQL commands
    By ontheway in forum Microsoft Access Help
    Replies: 2
    Last Post: September 23rd, 2004, 01:18 PM
  5. Automating Reports
    By jpulford in forum Microsoft Access Help
    Replies: 2
    Last Post: December 8th, 2003, 11:28 AM

IMN logo majestic logo threadwatch logo seochat tools logo