Post reply

Any way of verification

  • December 8, 2011 at 6:23 am

    #247993

    Hi

    I need to deploy multiple SPs on mutiple DB on daily basic. I want to audit/confirm that whenever i execute sp on specific DB ; it gimme prompt/intimation/alert that SP successfully executed.

    This is the only way i can ensure my deployments.

    2nd: What is the pre-reqs to execute SPs on Red-gate Multiscript?

    Thanks in advance.

  • December 8, 2011 at 8:45 am

    #1418725

    well, it really on if (and how) you've set up your proc to return success or failure;

    you know a proc can return results in any and all of three different ways;

    1. A return value, return 0 when successfull, and some other number upon failure.

    2. An output parameter that was passed to the proc;

    3. a recordset on completion.

    typically, you'd probably want to use the return value, and use something like sp_send_dbmail to notify oyu off the results of the execution.

    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!

  • December 8, 2011 at 9:18 am

    #1418756

    Is it possible that DB Prompts me when the new SP executed successfully and Its timestamp get changed.

  • December 8, 2011 at 9:25 am

    #1418760

    nope no way to prompt or alert, not without you creating an application to do that for you.

    SSMS executes code, and presents the results...that's the typical applicaiton you might use.

    based on the results, you cna have additional code do something.

    but SSMS does nto have the ability to popup or prompt for data, the reason being the code is assumed to execute and return (maybe) an interger success or failure reuslt...it's not designed to be interactive the way, say the SQLPlus for Oracle might;...that's the same thing, SQLPlus is an applicaiton, but that app has a built in ability to prompt for values, base dont eh occurrence of the & in a string.

    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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply