ETL sql job failure

  • One of the ETL sql job is failing is failing with below error.

    Job name : RealTimeETL_8_IdentifyReportingDBSyncIssues

    Please advise.

    Error:

    Executed as user: LDRTEST\sqlservice301. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:00:20 AM Error: 2012-08-28 11:07:57.57 Code: 0xC002F304 Source: Send Mail Task Send Mail Task Description: An error occurred with the following error message: "Insufficient system storage. The server response was: 4.3.1 Insufficient system storage". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:00:20 AM Finished: 11:07:57 AM Elapsed: 456.718 seconds. The package execution failed. NOTE: The step was retried the requested number of times (50) without succeeding. The step failed.

  • Looks like you are out of disk space...

    Jared
    CE - Microsoft

  • Considering that's an error from a Send Mail task, my guess is you're actually out of mailbox space for that account. Time for someone to go in and archive/cleanup SQLAgent's mailbox.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Is this something I can do in SSMS-databasemail ?

    thanks

  • laddu4700 (6/12/2012)


    Is this something I can do in SSMS-databasemail ?

    thanks

    No, you'll need to login as the SQLAgent and literally go manipulate their Inbox via Outlook or whatnot.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

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

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