Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

scripts Expand / Collapse
Author
Message
Posted Friday, March 15, 2013 6:30 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 11:35 PM
Points: 486, Visits: 1,193
Hi,

i need a script for script out all jobs in sqlserver2000.

Thanks
Post #1431501
Posted Friday, March 15, 2013 8:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 11:35 PM
Points: 486, Visits: 1,193
This Script will create SQL syntax for re-creating existing SQL Server jobs.
The OUTPUT of this script will be a TSQL statement, which can used to recreate the jobs.
I want tose this script to create jobs from one SQL instance to another instance.
Post #1431564
Posted Friday, March 15, 2013 8:31 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 11:35 PM
Points: 486, Visits: 1,193
I need this kind of sqlserver2000 scripts for below .
1.Jobs
2.Logins
3.Users
4.Linked servers


Can some one provide these scripts.
Post #1431565
Posted Friday, March 15, 2013 9:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:38 AM
Points: 14,412, Visits: 37,723
take a look at the script contributions on the site:
the second link from this results explicitly says jobs for SQL 2000/05/08,
http://www.sqlservercentral.com/search/?q=script+jobs&t=s

I think another search for the other items you mentioned will certainly yield something you could use.


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1431582
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse