viewing job status as a member of targetserverrole in msdb
From: Jules Bui (jbui_at_cfsloans.com)
Date: 06/26/03
- Next message: Shamim: "Accessing SQL 2K from SQL 7"
- Previous message: cengiz: "Re: script object-level permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 05:41:17 -0700
By adding a user in the targetserverrole in the msdb
database, it allows this user to see scheduled jobs and
view the history etc. What I have found is on jobs that
are still executing, if the user looks at the 'status'
column, it will not say that the job is executing. The
only way I have found for any user to see a job status is
to make him an 'sa'. There has to be a stored procedure
which can grant a user to see the status of current jobs
still executing w/o making him an sa. Would you happen
to know what it is and where it would be?
- Next message: Shamim: "Accessing SQL 2K from SQL 7"
- Previous message: cengiz: "Re: script object-level permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
