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.
| Author |
Topic |
|
zion99
Posting Yak Master
141 Posts |
 Posted - 2009-03-19 : 04:45:25
|
| Hi,I need to execute a huge script as the last step of an SQL job. The issue is SQL 2005 puts a limitation on the no. of lines that can be included in a step.One option is to deploy sql script on the server and then run the foll: OSQL -E -S<machine name> -n -i\\<machine name>\FOLDER\script1.sql This suggestion was rejected by the DBAs mentioning that sql scripts must not be deployed on production.Can anybody suggest me a solution? |
|
|
matty
Posting Yak Master
161 Posts |
Posted - 2009-03-19 : 05:02:09
|
| What about creating a stored procedure and use EXEC sp as a step in job? |
 |
|
|
|
|
|
query regarding sql web agent jobs