Results 1 to 3 of 3

Thread: run a batch of sql statement

  1. 09-26-2005, 10:15 PM #1
    gupta_prash
    gupta_prash is offline Registered User
    Join Date
    Sep 2005
    Posts
    8

    run a batch of sql statement

    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.
    Reply With Quote Reply With Quote
  2. 09-27-2005, 09:06 AM #2
    mulhall
    mulhall is offline Registered User
    Join Date
    Jul 2005
    Posts
    18
    SQL Agent jobs. see BOL.
    Reply With Quote Reply With Quote
  3. 09-27-2005, 10:56 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If you can't submit a job in SQL Server because of security issues, you can always use Windows scheduler from a machine that has SQL client installed. You can use osql to run stored procedures.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules