Results 1 to 6 of 6

Thread: to SLQ Statement at a specific time

  1. #1
    Join Date
    Sep 2005
    Posts
    8

    to SLQ Statement at a specific time

    Hi There,

    I want to able to run a batch of sql statments (execute procedures) in SQl Server at a specific time. Just wondering if there is a method for that.

  2. #2
    Join Date
    Dec 2004
    Posts
    502
    SQL Server has a scheduler. Go to Management > SQL Server Agent > Jobs in Enterprise Manager.

  3. #3
    Join Date
    Sep 2005
    Posts
    8
    Thanks nosepicker

  4. #4
    Join Date
    Sep 2005
    Posts
    13

    Exclamation there is another method for batch executions as well

    Lookup xp_cmdshell in the help files. You can use this process to execute individual batch files from within SQL.

    The scheduler is the best way, but if you are looking for troubleshooting and error logic programatic processing within your batch, xp_cmdshell could be an answer for you.

    Frank

  5. #5
    Join Date
    Dec 2004
    Posts
    502
    I don't think he wants to execute batch files or command line stuff. I think he just wants to execute a bunch of SQL commands.

  6. #6
    Join Date
    Sep 2005
    Posts
    8
    Thanks for the info guys. I've used the scheduler and its all working fine for me. Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •