How to adjust a return code

• Ariadne

  SSCrazy

  Points: 2044

  More actions

  October 24, 2007 at 9:18 pm

  #63107

  I've got a query/stored procedure that has to run under SQL Agent every night. The problem is, I'm getting the following warning:

  Warning: Null value is eliminated by an aggregate or other SET operation.

  This warning automatically kicks off the failure option on the job. I need to fake out SQL Agent so it doesn't think this is a failure. Any ideas on what I can do either inside the stored procedure or otherwise that'll keep SQL Agent from failing the job?

  Thanks,

  Ariadne

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  October 24, 2007 at 10:32 pm

  #745202

  My SQL Agent doesn't think it's an error.

  Many job steps generate this or other messages, they are accessible via Job History, but it does not make the steps (and jobs) to fail.

  You should find out what makes your job to fail.

  You can switch this message off with

  SET ANSI_WARNINGS OFF

  But it does not eliminate all messages.

  So, if you fix it this way one day this problem may reappear again.

  _____________
  Code for TallyGenerator

• VaiydeyanathanVS

  Hall of Fame

  Points: 3053

  More actions

  October 24, 2007 at 11:23 pm

  #745213

  I think Sergiy is right. Try to follow the steps and implement the agent.