Professional Web Applications Themes

SQL Job from asp.net.. - ASP.NET General

What you might want to do is to wrap call to this sp into your sp. At the same place put loop to check for status. Your sp will not return until it's done. I think you have design issue. Why do you have a job? Can't you just use sp? "yyt" <msnews.microsoft.com> wrote in message news:%phx.gbl...  to ...

  1. #1

    Default Re: SQL Job from asp.net..

    What you might want to do is to wrap call to this sp into your sp. At the
    same place put loop to check for status.
    Your sp will not return until it's done.

    I think you have design issue. Why do you have a job? Can't you just use sp?


    "yyt" <msnews.microsoft.com> wrote in message
    news:%phx.gbl... 
    to 


    Ivan Guest

  2. #2

    Default Re: SQL Job from asp.net..

    The sql job is for a DTS package that is schedued on the db server.
    I can try your idea of embedding the sql call in a separate stored
    procedure.

    out of curiosity, can asp.net pasue function br used to halt the application
    for a certain time? (the job takes sbt 30 secs to complete)


    "Ivan Demkovitch" <id> wrote in message
    news:#phx.gbl... 
    sp? [/ref]
    page [/ref]
    job [/ref]
    not 
    >
    >[/ref]


    yyt Guest

  3. #3

    Default Re: SQL Job from asp.net..

    Well.. If all the job do is run DTS then you can do it as well(from sp).

    I think in DTS you have a way to specify behavior (in or out of process)

    Sure, you can halt application for 30 seconds but NEVER go this rote.
    This is VERY BAD design.


    "yyt" <msnews.microsoft.com> wrote in message
    news:%phx.gbl... 
    application [/ref]
    the 
    > sp? [/ref]
    > page [/ref]
    > job [/ref][/ref]
    user [/ref]
    > not 
    > >
    > >[/ref]
    >
    >[/ref]


    Ivan Guest

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