June 17th, 2013, 07:35 PM
automating sql commands
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?
June 18th, 2013, 02:05 AM
you have one option i.,e SQL Batch job this will automate your request.
refer below article on batch job
June 18th, 2013, 11:52 AM
June 20th, 2013, 09:19 AM
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
if you found this post is useful click Give Rep button (bottom side on this reply ) and agree
November 4th, 2013, 11:51 PM
Thanks for sharing good work.