[dba-SQLServer] Job Status not visible

Djabarov, Robert Robert.Djabarov at usaa.com
Tue Mar 2 08:46:39 CST 2004

Sounds obvious, but you might have overlooked (ignore if you didn't), -
right-mouse click on the job and select Refresh...

Robert Djabarov
SQL Server & UDB
Sr. SQL Server Administrator
Phone: (210)  913-3148
Pager: (210) 753-3148
9800 Fredericksburg Rd. San Antonio, TX  78288

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Sander
Sent: Tuesday, March 02, 2004 4:58 AM
To: accessd
Subject: [dba-SQLServer] Job Status not visible

Hi group,
we're using SQL Server 2000 SP3.
I've created several jobs but somehow I cannot see the status!? Let's
say Job1 runs SP1, SP2 and SP3.
When I start JOB1 it should say something like Running/ Executing SP1.
However we do not see this info?!
Why is that? I've searched the net extensivly but I didn't find a
Any ideas anybody?
PS: I've tried the following:

In general if those jobs are owned by those developres then they can
execute/maintain their own jobs but not others. Also users need
permission on msdb..sp_enum_sqlagent_subsystems and
msdb..sp_get_sqlagent_properties to run their own jobs including setting
'TargetServersRole' in MSDB for the users.

For information refer to this link
[<http://vyaskn.tripod.com/sql_server_security_best_practices.htm>] for
security and this link
] for Admin.


Try grant them exec permission on msdb..sp_enum_sqlagent_subsystems. 



Do you Yahoo!?
Yahoo! Search - Find what you're looking for faster.
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list