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

MS Sql Server LazyDBA home page