<div>
unsure. but i get the jobs to write everything to file: and attach the file with the email
</div>


unsure. but i get the jobs to write everything to file: and attach the file with the email

<div>
<a href="http://www.mssqltips.com/tip.asp?tip=1054" rel="ugc">http://www.mssqltips.com/tip.asp?tip=1054</a> may help as well
</div>


http://www.mssqltips.com/tip.asp?tip=1054 [http://www.mssqltips.com/tip.asp?tip=1054] may help as well

<div>
Can you not just create an operator and notify on fail using the Advanced properties of the job step?
</div>


Can you not just create an operator and notify on fail using the Advanced properties of the job step?

<div>
ive had a look at the link which is very useful and although i can see i way of tracking individual steps on whether they are executing i cant see one for the overall job. I guess i could assmue that if any of the steps are executing then the job is but it would be nice of this was summerised somewhere else?
</div>


ive had a look at the link which is very useful and although i can see i way of tracking individual steps on whether they are executing i cant see one for the overall job. I guess i could assmue that if any of the steps are executing then the job is but it would be nice of this was summerised somewhere else?

<div>
<div class="content wysiwyg-content">
Im using stored procedure sp_help_jobhistory to identify failed jobs and email them to me. i would like to include the step that failed and the message from the job history but im not sure where this info is stored ?
</div>
</div>


Im using stored procedure sp_help_jobhistory to identify failed jobs and email them to me. i would like to include the step that failed and the message from the job history but im not sure where this info is stored ?

tsql scheduled job info

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.