Tag: sp_help_job

Finding out the status of SQL Jobs is a simple task which can be accomplished via the GUI or in code using EXEC msdb.dbo.sp_help_job. However one issue that is encountered is that the results from this procedure can not easily be used. If an attempt is made to insert the results into another table an…