Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Creating A Database by scheduling a Job

Author  Topic 

gautham.gn
Starting Member

19 Posts

Posted - 2014-06-20 : 06:22:32
Hi.,

I need a help. I have certain number of scripts placed in one folder. Everyday those scripts will be changed. So., I have to test those scripts by creating a Database everyday with the scripts present in folder.

Is it possible to schedule a job in such a way that., it should automatically create a database and execute the scripts placed in the mentioned folder in the database created.?

If Yes., Can u please explain?

Thanks in Advance.,

Gautham

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-06-20 : 06:26:03
are those DDL scripts?

Javeed Ahmed
Go to Top of Page

gautham.gn
Starting Member

19 Posts

Posted - 2014-06-20 : 06:32:46
It contains both DDL and DML
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-06-20 : 06:59:29
you may want to use sqlcmd to achieve that,have a look at this
http://msdn.microsoft.com/en-IN/library/ms170572.aspx

Javeed Ahmed
Go to Top of Page
   

- Advertisement -