Software Applications Programming Errors and solutions.

You can use following Script or query for FAILED JOBS Details with error Messages in SQL. I hope it will help you. USE Msdb Declare @lastRunDate int =replace(CAST(getdate()as date),'-','') SELECT Sj.name as JobName ,CASE SJH.run_status WHEN 0 THEN 'Failed' WHEN 1 THEN 'Succeded' WHEN 2 THEN 'Retry' WHEN 3 THEN 'Canceled' END AS JobStatus,SJH.message from sysjobhistory SJH inner join sysjobs SJ ON SJH.job_id = SJ.job_id where SJH.step_id = 0 and sjh.run_date =@lastRunDate and SJH.run_status =0

How to change time to be 1:30:00 am/pm Instead of 13:30:00 ? You can try below queries. SELECT substring(convert(varchar(20), GetDate(), 9), 13, 5) + ' ' + substring(convert(varchar(30), GetDate(), 9), 25, 2) declare @time time = '13:30:00' SELECT convert(varchar, @time, 22)

sql aptitude questions and answers sqlauthority sql aggregat functions sql basic sql books sql commands sql cursor sql certification sql developer sql download sql dba sql express 2008 r2 sql examples sql formatter sql functions sql full form sql fiddle sql group by having sql get date sql guide sql helper class sql history sql interview questions and answers sql injection sql join sql keys sql keywords sql kill porcess sql knowledge sql loader sql like sql language sql managment stuido 2008,2012 sql means sql notes sql not in sql netowrk interfaces error 26 sql notes pdf sql online test sql order by sql operators sql plus download sql pdf sql profiler sql queries pdf,examples sql rowcount sql replace sql reporting services sql rank sql server 2008 sql tutorial pdf sql update sql union query sql unique sql version sql views sql vulnerable sites sql vs mysql sql w3schools sql wiki sql where sql workbench sql xml path,query,x

 convert date in 'MM/DD/YYYY HH:MI A.M.' format using MS sql select CONVERT(nvarchar(30), GETDATE(), 101) + ' ' + CONVERT(nvarchar(30), GETDATE(), 114) format sequence 101 = mm/dd/yyyy 108 = hh:mi:ss 114 = hh:mi:ss:mmm(24h)