Sometimes we need to view which jobs are running in different contexts like administrative proposes or for data update and we need to see what´s is happening.
USE msdb ;
GO
EXEC dbo.sp_help_job;
Go
USE msdb ;
GO
EXEC dbo.sp_help_job
@job_name=N'MaintenancePlanBackup', -- Specify the name of your job
@job_aspect=N 'ALL';
GO
/*
Using Multiserver
*/
USE msdb ;
GO
EXEC dbo.sp_help_job
@job_type=N'MULTI-SERVER',
@owner_login_name=N'sa', @enabled=1 , @execution_status=1;
GO
View this link for more information
http://msdn.microsoft.com/en-us/library/ms186722.aspx
/*
View Activity Jobs
*/
USE msdb
GO
EXEC dbo.sp_help_jobactivity ;
GO
Related Posts:
