April 4, 2010 at 8:58 am
Hi,
The requirement is I have a bunch of t-sql statements. These t-sql statements include tables from different servers and different databases. Some of them take 5 min to execute, while some take upto 30 min to execute when executed from SSMS. My question is can I put one execute SQL task in my package for each t-sql statement and schedule it as a job. Kindly reply as it is urgent.
April 4, 2010 at 9:02 am
Yes.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 5, 2010 at 5:23 pm
Yes you could do that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply