Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Frisco, TX
    Posts
    21

    Unhappy Unanswered: Alert gets executed, but not its job. Am I doing something wrong?

    I have an Alert that I verify gets activated (looked at its history under the General Tab) but it never executes the Execute Job under the Response tab.

    Here is what I did:

    1) Checked the Execute Job box
    2) Created a job
    a) Gave it a name
    b) Gave it an owner
    c) Left the category as Uncategorized
    d) Under the Steps tab added a new step
    i) Gave the step a name
    ii) Selected Operating System Command (CmdExec) as the type
    iii) In the Command box typed the following

    cd C:\Blat
    blat StandardMessage.txt -to Test.Test@MyURL.com -s "TEST"
    cd C:\



    When I copy and paste that EXACT message (cd....blat...cd...) on the command line it works perfectly so it looks like the job isn't getting executed at all.

    I also tried to set up an output file (under the Advanted Tab...Operating System Command. That file never gets created either! That makes me REALLY sure the job isn't getting executed.

    So, if my Alert gets executed as verified by the history, why isn't my job being kicked off?

    THANKS!

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    what account the service is running under? probably system account. you need to have a domain account with minimal rights.

  3. #3
    Join Date
    Oct 2003
    Location
    Frisco, TX
    Posts
    21
    Originally posted by ms_sql_dba
    what account the service is running under? probably system account. you need to have a domain account with minimal rights.
    You have lost me here.

    My Alert executes just fine. I don't see any way to specify any "account" for the job that gets kicked off to run under.

    Where should I look to specify the "account the service is running under"?

    Thanks.

  4. #4
    Join Date
    Oct 2003
    Location
    Frisco, TX
    Posts
    21
    Originally posted by darrinps
    You have lost me here.

    My Alert executes just fine. I don't see any way to specify any "account" for the job that gets kicked off to run under.

    Where should I look to specify the "account the service is running under"?

    Thanks.
    I THINK what is happening is that the command I want to execute is local to my PC and the exec is attempting ro tun against the local server box.

    What I need to do is either install the software there, or better yet (for testing) somehow redirect it to my box.

  5. #5
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    try copying all the command line steps in a .bat file and then run that bat file from your scheduler.

Posting Permissions

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