-
ASP.NET MVC Redirect to Action from a Class
-
How to check SQL Job is in running state?
Method 1: System Stored procedure: sp_help_job, returns information on the job, its steps, and more. EXEC msdb.dbo.sp_help_job @Job_name = ‘Your Job Name’ Method 2: IF EXISTS(SELECT 1 FROM msdb.dbo.sysjobs J JOIN msdb.dbo.sysjobactivity A ON A.job_id=J.job_id WHERE J.name=N’Your Job Name’ AND A.run_requested_date IS NOT NULL AND A.stop_execution_date IS NULL ) PRINT ‘The job is running!’ ELSE […]