Re: Copying jobs to a new server.

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 08:57:49 +0530

Hi,

There are 2 more options:-

1.

You can generate the script for all jobs ( Enterprise manager -- Right click
on the jobs
node in SQl Agent -- Jobs| All tasks| Generate sql script, Save it as file).
Run this
script in the destination server.

2.

Jobs, operators , Alerts ,...are stored in msdb database.If the destination
server
is a new one and if you do not have any existing stuffs in msdb , you can
even restore a msdb backup from the source server.

-
Thanks
Hari
MCDBA

"Michael Beck" <Mikeb46NoSpam@pacbell.net> wrote in message
news:e9ySexfaEHA.2844@TK2MSFTNGP12.phx.gbl...
> We are moving SQL Server (2000) to a bigger dedicated server.
> Is there a faster way to move all the jobs than creating a script for each
> one and then running that script in query analyzer?
>
> TIA
> Mike
>
>

Relevant Pages

  • Re: SQL state (error) is 37000
    ... Forgive me as SQL ... When I run that script in SQL Query Analyzer it ... >> an Openrowset query against the local server for the results ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 zu 2005 Inkompatibilität?
    ... Mache ich jedenfalls immer wieder so wenn probleme mit Software ... So kannst du einmal den Kompletten Ablauf des Skriptes unter SQL Server ... Jetzt mußt du "nur" noch herausfinden ob der Fehler im Script liegt oder auf ...
    (microsoft.public.de.sqlserver)
  • Re: How to send E-mail without an external SMTP server ?
    ... you're sending email using external server. ... I want to find a way to send email without an external smtp server. ... Actually I was writing a script that can submit jobs automatically on a remote server. ... I should not submit the jobs all at once, because this will take up all resources of the server. ...
    (comp.lang.python)
  • Re: migrate users
    ... You can script the users and associated roles for that user using the SQL ... Open Enterprise manager and connect to the SQL server where your actual ... Expand the datbases and select the database. ...
    (microsoft.public.sqlserver.server)
  • Re: Executing a SQL script on server
    ... > How can I using ADO send a SQL script to the server to be executed there? ... An example VBScript program to execute a stored procedure: ... ' Specify the SQL Server and Instance. ...
    (microsoft.public.vb.database.ado)