Well, I've had to get up at 1am past 2 days so I could be at work at 3
to monitor sudden poor database performance at our Europe facilities
real time.
Stayed all day both days, database performance was great, found nothing.
Going on vacation next week, may sip a cold one before crashing tonite.
Have a great weekend and a great 4th everyone!
Emil
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x22791101.[Email address protected]
Sent: Friday, June 29, 2007 2:35 PM
To: LazyDBA Discussion
Subject: RE: SQL2005 DTS schedule legacy job
Well, well, well!
It's Norkett Margaret! Hehe. How have you been?
I logged on to the source server (SQL Server 2000 server) and went to
the Jobs, right click, and generate script, and copy to clip board.
Log on to destination server (SQL Server 2005 server) and select the
database name and click on new query. Paste script in query and update
the server name at the top before you execute it.
That's it. I ran one and it executed successfully.
It's Fridayyyyyy! Partyyyyyyyy! Hehe.
Have a great Day and Weekend!
Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Norkett Margaret
[mailto:mssqldba-ezmlmshield-x23358098.[Email address protected]
Sent: Friday, June 29, 2007 1:41 PM
To: LazyDBA Discussion
Subject: SQL2005 DTS schedule legacy job
I've pulled over a DTS job from my old SQL server to my SQL2005 server
and
it's put it into the Legacy folder. When I go to try to create a
scheduled
job to run it, Legacy is not one of my choices.
How do I create a job to schedule my legacy DTS to run or will I have to
re-create the job in SSIS?
If you have any questions or concerns, please let me know them.
Margaret Norkett
Database Administrator
* 864-271-6522 ext 222
* 864-270-2884
The thing always happens that you really believe in; and the belief in a
thing makes it happen.
Frank Lloyd <http://www.quotationspage.com/quotes/Frank_Lloyd_Wright/>
Wright
US architect (1869 - 1959)
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page