SQL SERVER – JOB Status


SELECT  job.NAME NAME
                     ,job.job_ID job_ID
                     --,job.Originating_Server Originating_Server
                     ,run_requested_date run_requested_date
                     ,stop_execution_date stop_execution_date
                FROM msdb.dbo.sysjobs_view job
                INNER JOIN msdb.dbo.sysjobactivity activity ON (job.job_id = activity.job_id)
                WHERE run_Requested_date IS NOT NULL
                     AND job.NAME IN (N'xyz')
                ORDER BY run_requested_date DESC


author

Kiran Reddy A

Kiran has been a part of the IT industry for more than six years and Involved in many MSBI projects and product development with extensive usage of ETL and Reporting tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS) and T-SQL

Get Free Email Updates to your Inbox!

www.CodeNirvana.in

Powered by Blogger.

Translate

Total Pageviews

Copyright © Journey to MSBI World With Kiran Reddy | Blogger Templates | Designed By Code Nirvana