Warning in Scheduled job

  • Hi,

    When I am trying to run a scheudled job in SQL SErver 2005, getting the below error and job gets failed.

    8/10/2010 8:00:00 PM

    LogJob History (Datamart Copy)

    Step ID1

    ServerEUDNTKRMPRODSQL

    Job NameDatamart Copy

    Step NameDataMartUpdateProcedure

    Duration02:19:20

    Sql Severity16

    Sql Message ID8115

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: KONENET\clustersql_eudntkrm. ... is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning... The step failed.

    Can anyone tell me what should be the problem with this type of warning error and is there any way to disable the warning.

    Thanks in Advance,

    Regards,

    Naveen

  • is there any sql script or stored proc running under it ? POst it

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • There is a SP running and its very big to paste it here. But can anyone tell me why its coming and how we can overcome with this. It looks like the complete SP has run and because of that wraning the job got failed.

  • ekknaveen (8/11/2010)


    There is a SP running and its very big to paste it here. But can anyone tell me why its coming and how we can overcome with this. It looks like the complete SP has run and because of that wraning the job got failed.

    Convert that Sp in script ( remove "create proc" syntax from above ) and then run it in mgmt.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • when i tried to run the below query gets the warning message

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

    SELECT

    S.StatisticsStartTime,

    S.EquipmentNumber_FK,

    isnull(MAX(S.StatisticsEndTime),0),

    isnull(MAX(E.EquipmentClass_FK),0),

    isnull(MAX(E.RemoteMonitoringType_FK),0),

    isnull(MAX(E.AnalyzerType_FK),0),

    isnull(MAX(S.TotalStarts),0),

    isnull(MAX(S.TotalRunTime),0),

    isnull(MAX(S.DoorOperations),0),

    isnull(MAX(S.Knx3NbrRelevellings),0),

    isnull(MAX(S.CreateDate),0)

    FROM KRM.dbo.ElevatorTotalStatistics S INNER JOIN KRM.dbo.Equipment E ON S.EquipmentNumber_FK = E.EquipmentNumber WHERE

    -- AND NOT EXISTS (SELECT * FROM ElevatorTotalStatistics T2 WHERE T2.EquipmentNumber_FK = E.EquipmentNumber AND S.StatisticsStartTime = T2.StatisticsStartTime)

    -- 10.12.2004 / Tiina Mikonmäki

    NOT EXISTS (SELECT * FROM ElevatorTotalStatistics T2 WHERE T2.EquipmentNumber_FK = E.EquipmentNumber AND S.CreateDate = T2.CreateDate)

    GROUP BY

    S.StatisticsStartTime,

    S.EquipmentNumber_FK

  • please use stored procedure like this to avoid this warning

    create proc nameofSP

    as

    SET ANSI_WARNINGS off

    your code

    SET ANSI_WARNINGS ON

  • amazing.. it worked like a wonder for me..

    thanks a bunch mayank_tyagi 🙂

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

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