Customized success or failure log of the SQL job in the Windows Event Viewer.

This #JustLearned was published in Beyondrelational.com and for other #JustLearned by me check the link provided at the end of this article.

 

You can check the status of a  SQL job and log the customized success or failure message of the job for the day in the Windows Event Viewer.

IF NOT EXISTS (SELECT TOP 1 RUN_DATE FROM MSDB.DBO.SYSJOBHISTORY WHERE JOB_ID=
(SELECT JOB_ID FROM MSDB.DBO.SYSJOBS WHERE NAME=’S_000W’) AND
STEP_ID = 3 AND RUN_STATUS=1 AND
RUN_DATE=CONVERT(VARCHAR , GETDATE(), 112) ORDER BY RUN_DATE DESC)
BEGIN
EXEC XP_LOGEVENT 60000, ‘S_000W: DAILY JOB NOT COMPLETE’, ERROR
END
ELSE
BEGIN EXEC XP_LOGEVENT 60000, ‘S_000W: DAILY JOB COMPLETED’, INFORMATIONAL
END

Usage

–xp_logevent { error_number , ‘message’ } [ , 'severity' ]

For more information

–http://msdn.microsoft.com/en-us/library/ms186244.aspx

Also check the uses RAISERROR

For other #JustLearned check the below links

SQL Server Tips – Identify running jobs on remote server

Checking the Job Schedule status of a SQL job

Windows Service Installation with a Service User Account

Dotnet – Its possible to generate the assembly of specific platform

Platform specific code in dotnet

Disabling/Enabling SQL Jobs or Job schedule from remote computer

Windows Service with Windows Timer control doesn’t tick

Interview Questions & Answers (.NET & SQLServer)

I have written couple of questions and answer in my blog at BeyondRelational. Here I plan to put all of them together and also in future when ever I will add any questions answers to that blog, I will add a link here. Go through the questions and answers , but don’t think these are complete, you have to read a lot using the reference material and other books. You have to practice a lot and then you will get the answers fundamentally and practically correct for your understanding. So happy reading and please provide feedback for this series. If you find anything wrong, please guide me and tell me the correct answer so that I can verify the same and will update the most appropriate answer.

1.  What exception will be thrown when an unsafe code without permission (SkipVerification flag) gets compiled by the JIT Compiler?
2. While compiling IL to native code CLR performs a process called verification, What is that?
3. What is the class from which every class inherits?
4. Write a C# statement where both heap and stack memory allocation is required.
5. How do you prevent a class from being inherited?
6. Can structs have constructors?
7. What’s the difference between const and readonly?
8. C# – What are Named and Optional arguments?
9. C# – How can you change the type of a enum?
10. What is the differnce between int.Parse and Convert.ToInt32?
11. What is Lazy instantiation in C#?
12. What must be the return type for operator overloading and for which operator it differs?
13. What is a Jagged Array?
14. Is it possible to declare a local varaible as Volatile?
15. What is “short-circuit” evaluation in C#?
16. When the control doesn’t reach the “Finally” block?
17. Which database object can ‘also’ be used to maintain Referential Integrity?
18. Which command is used to re-seed the identity value?
19. What is a logon trigger?
20. How can I define a DEFAULT value in a timestamp and IDENTITY column?
21. Why can’t a sparse column be eligible for Primary key?
22. In what way an identity field differentiates the delete and truncate command?
23. How to change the length of a column defined with a Primary key constraint?
24. Which Key Constraints enforces Enitity Integrity ,Referential Integrity and Domain Integrity?

Till next time Keep smiling