Professional Web Applications Themes

how can i change jobs on a MSX server - Microsoft SQL / MS SQL Server

Hi, Yes, you're right, i restored that server from another different server. So how can i update my originating server to be the current one? thanks again. Yanping *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Re: how can i change jobs on a MSX server


    Hi,
    Yes, you're right, i restored that server from another different
    server. So how can i update my originating server to be the current
    one?

    thanks again.
    Yanping


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    yanping Guest

  2. #2

    Default Re: how can i change jobs on a MSX server

    Are you familar with the UPDATE statement?

    Assuming that servername returns the correct data this should work for you:


    SELECT servername
    -- USE msdb
    -- GO
    -- UPDATE sysjobs SET originating_server = servername
    -- SELECT rowcount

    (uncomment the statement in order to run it)

    --
    Keith

    "yanping wang" <com> wrote in message news:#phx.gbl... 
    Keith Guest

  3. #3

    Default Re: how can i change jobs on a MSX server

    Thank you Keith!
    Yanping 
    should work for you: 
    message news:#phx.gbl... [/ref]
    different [/ref]
    be the current [/ref]
    *** 
    >.
    >[/ref]
    Yanping Guest

Similar Threads

  1. server change
    By harrym in forum Coldfusion Server Administration
    Replies: 3
    Last Post: May 19th, 08:47 PM
  2. Replies: 4
    Last Post: June 11th, 12:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139