how to setup access for sql jobs

Hello,
I have some users that I want to be able to view/add sql job under sql
agent. How can I give them access to this without making them sys admins?
Jake
The users will need to own the jobs to view them if you
don't want them to be members of sysadmin role.
The public role has permissions to execute sp_add_job.
-Sue
On Mon, 18 Oct 2004 16:10:43 -0700, "Jake"
<rondican@.hotmail.com> wrote:

>Hello,
> I have some users that I want to be able to view/add sql job under sql
>agent. How can I give them access to this without making them sys admins?
>Jake
>

how to setup access for sql jobs

Hello,
I have some users that I want to be able to view/add sql job under sql
agent. How can I give them access to this without making them sys admins?
JakeThe users will need to own the jobs to view them if you
don't want them to be members of sysadmin role.
The public role has permissions to execute sp_add_job.
-Sue
On Mon, 18 Oct 2004 16:10:43 -0700, "Jake"
<rondican@.hotmail.com> wrote:

>Hello,
> I have some users that I want to be able to view/add sql job under sql
>agent. How can I give them access to this without making them sys admins?
>Jake
>

how to setup access for sql jobs

Hello,
I have some users that I want to be able to view/add sql job under sql
agent. How can I give them access to this without making them sys admins?
JakeThe users will need to own the jobs to view them if you
don't want them to be members of sysadmin role.
The public role has permissions to execute sp_add_job.
-Sue
On Mon, 18 Oct 2004 16:10:43 -0700, "Jake"
<rondican@.hotmail.com> wrote:
>Hello,
> I have some users that I want to be able to view/add sql job under sql
>agent. How can I give them access to this without making them sys admins?
>Jake
>sql

How to set SQL Server 2000 send an alert message if any of jobs fails or completes success

Hi!
I have several jobs scheduled to run every evening. Is there a way to
set SQL Server 2000 send an alert message if any of jobs fails or
completes successfully?"Zaur Bahramov" <zaur.bahramov@.mondialgroup.it> wrote in message
news:eGKQs4sqIHA.552@.TK2MSFTNGP06.phx.gbl...
> Hi!
> I have several jobs scheduled to run every evening. Is there a way to set
> SQL Server 2000 send an alert message if any of jobs fails or completes
> successfully?
>
For each job, you can send a notification. It must be configured in the
job.
The notification can be sent for On Success, On Failure or On Completion.
You would have to set this up for each job individually.
If you are looking for a more centralized management scenario, you would
probably have to code it.
Without thinking about it too much, I would probably create a new job that
is scheduled to run AFTER the other jobs should have completed.
I would use TSQL code to read the msdb database's jobs tables (sysjobhistory
IIRC) to determine the status of the jobs in question, put together the
email
and then send the email out.
Rick Sawtell|||Zaur
Create a job with three steps. First one is doing what you have defined
and goes to the second step if it failed. (Second step sends you email that
Job failed)
, if it succeded gooes to the third step (Second step sends you email that
Job succeded)
"Zaur Bahramov" <zaur.bahramov@.mondialgroup.it> wrote in message
news:eGKQs4sqIHA.552@.TK2MSFTNGP06.phx.gbl...
> Hi!
> I have several jobs scheduled to run every evening. Is there a way to set
> SQL Server 2000 send an alert message if any of jobs fails or completes
> successfully?
>