How to see JOBS in control panel? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to see JOBS in control panel?

Author

Topic

vinoth86
Starting Member

27 Posts

Posted - 2008-04-25 : 03:28:57

Hi,
I am using SQL SeRVER 2005,i wanna know the jobs that are running in that server.

Is there any option to see in control panel?

Thanks,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-25 : 03:42:16

Use SQL server Agent to view jobs running in your server.
http://msdn2.microsoft.com/en-us/library/ms186273.aspx

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-25 : 22:48:39

You mean under sql server agent in ssms?

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-04-26 : 00:01:37

you can use job activity monitor in SSMS.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2008-04-28 : 04:48:53

under event viewer, if you enabled write to application log for successful job execution :)

or as a query...



select cmd    
 ,(select text from sys.dm_exec_sql_text(spid.sql_handle)) as sqlstatement          
 ,[program_name]    
 ,spid    
 ,status    
from master..sysprocesses spid     
where [program_name] like 'sqlagent - tsql jobstep %'

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources