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 www.usaa.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Sander Derix 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 solution. Any ideas anybody? Regards, Sander 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 [<http://vyaskn.tripod.com/sql_server_administration_best_practices.htm> ] 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 http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com