Tag: Insert EXEC statement cannot be nested

  • Dynamically getting the execution status of a SQL Server Agent Job

    This problem seems trivial but there is no straight forward way to get this information. If you have tried the INSERT into EXEC command to insert the results of the sp_help_job procedure into a temporary table like below then you are familiar with the below error. insert into #jobstatus execute msdb..sp_help_job Msg 8164, Level 16, […]