Re: Copy job from one server to another

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/06/04

  • Next message: cbriscoejr: "Restore runs longer in batch mode" 
    Date: Fri, 6 Aug 2004 08:37:01 +0530

    Hi,

    There are 3 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.

    "Transfer Jobs" Task in DTS, That will transfer the jobs to new server.

    3.

    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

    "cbriscoejr" <cbriscoejr@discussions.microsoft.com> wrote in message
    news:B1336E38-C8C8-4F1B-BB8D-87E92ADD338F@microsoft.com...
    > How do you copy a job from one server to another. Identical databases
    different servers with different names

  • Next message: cbriscoejr: "Restore runs longer in batch mode"

    Relevant Pages

    • CUPS problem printing pictures is very slow
      ... all jobs) and everything is working very well, ... # Server name ... # Browse order (BrowseOrder) ... # Whether or not to use implicit classes. ...
      (Debian-User)
    • CUPS problem printing is slow
      ... all jobs) and everything is working very well, ... # Server name ... # Browse order (BrowseOrder) ... # Whether or not to use implicit classes. ...
      (Debian-User)
    • 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: strange problem with send() and recv()
      ... > I try to write a simple tcp based job queue server. ... > get commands from a client and store them in a queue. ... > The client can query the server about the jobs currently queued. ...
      (comp.lang.c)
    • Re: Deleting all jobs in remote print queue
      ... remote machine is Server 2003 or XP. ... We have situations in which we need to delete all print jobs, ... print queues, via a script. ...
      (microsoft.public.windowsxp.print_fax)