Checking A Sql Job Status In C# Using Sp_help_job

This similar question gave the solution that in order to check the status of a job in C# you must run sp_help_job. The problem is when I try the query out in SQL, I'm getting an er

Solution 1:

If you are writing C# code, the easiest solution would probably be to use the SMO API to get the information you need. You can use the Job class to get the current status and last result of a job.

Solution 2:

Change it to:

exec msdb.dbo.sp_help_job

Solution 3:

I had the same issue with running the EXEC command. However, changing the line to "exec msdb.dbo.sp_help_job" worked.