Post reply

cmd job

  • February 13, 2013 at 6:48 am

    #270095

    Dear Experts

    I am just trying to test this agent cmd job msg "%username%" "HI"

    but an error said that this user is not existing or disconnected

    Any idea to to solve this problem

    I want to raise message box after an alert occured or job finished

    Thanks lot

  • February 13, 2013 at 7:22 am

    #1587448

    zi (2/13/2013)

    Dear Experts

    I am just trying to test this agent cmd job msg "%username%" "HI"

    but an error said that this user is not existing or disconnected

    Any idea to to solve this problem

    I want to raise message box after an alert occured or job finished

    Thanks lot

    Are you talking about a SQL Server Agent Job? You cannot raise message boxes from Agent Jobs, they are unattended processes. What exactly are you wanting your users to see and when?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 13, 2013 at 11:33 am

    #1587594

    Thanks

    I am just trying to make a message box as an alert instead of operator email in case that the server has no connection to the internet to send email to the operator

    The job agent has a cmd step, which it can be used to show a message box

    any suggestion

    Thanks

  • February 13, 2013 at 11:41 am

    #1587596

    Agent Jobs are not built to generate popups on user's machines unless you consider NET SEND an option. The overall point however is that Jobs run on servers. If there is no connectivity to send an email why would there be connectivity to a user's workstation to invoke a popup?

    I think you're barking up the wrong tree, honestly.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 14, 2013 at 1:42 am

    #1587753

    You could use RAISERROR to write to the eventlog instead

  • February 14, 2013 at 3:41 am

    #1587805

    How to use it please

  • February 14, 2013 at 7:07 am

    #1587901

    DBArrr! (2/14/2013)

    You could use RAISERROR to write to the eventlog instead

    I would not rely on RAISERROR writing to the event log. SQL Server no longer does that in SQL Server 2012. It only writes to the SQL Error Log.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 14, 2013 at 7:09 am

    #1587905

    zi (2/14/2013)

    How to use it please

    It's part of the RAISERROR function, you say WITH LOG and SQL Server will additionally write the error to the SQL Error Log regardless of the flag in sys.messages. The SQL Error Log is what Agent Alerts take their cues from:

    RAISERROR('Hello World', 16, 1) WITH LOG;

    That said, none of this will help you raise a popup from a job.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 8 posts - 1 through 7 (of 7 total)

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