-
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.
-
SQL Server has a scheduler. Go to Management > SQL Server Agent > Jobs in Enterprise Manager.
-
-
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
-
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.
-
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
-
Forum Rules
|
|