min rights required to schedule a sql server job

Hello,

I need to create a user that can schedule jobs. I cannot use the 'sa' account.

What rights should I assign this user?

Michael

Michael,

You need a user that is a memeber of SQLAgentUserRole database role in msdb database.

You can read more about that in BOL topics:

"How to: Configure a User to Create and Manage SQL Server Agent Jobs"

"Security for SQL Server Agent Administration"

Regards,

|||

Here is the link to the Books Online topic for SQL Server Agent security: http://msdn2.microsoft.com/en-us/library/ms190978.aspx

Cheers,
Dan

min rights required to schedule a sql server job

Hello,

I need to create a user that can schedule jobs. I cannot use the 'sa' account.

What rights should I assign this user?

Michael

Michael,

You need a user that is a memeber of SQLAgentUserRole database role in msdb database.

You can read more about that in BOL topics:

"How to: Configure a User to Create and Manage SQL Server Agent Jobs"

"Security for SQL Server Agent Administration"

Regards,

|||

Here is the link to the Books Online topic for SQL Server Agent security: http://msdn2.microsoft.com/en-us/library/ms190978.aspx

Cheers,
Dan

Migration replication jobs

Hi all,
I will be migrating a production database to a new box. I will be using
detach and attach db method to migrate, but I forsee that my replication job
will break. Can anyone advise me on how to migrate the replication jobs over
to the new db? Here is the sencario:
DB-1 in Box A detach and move over to Box B to be reattached,
DB-1 in Box A has some publications and subscriptions, and the distribution
is in Box C.
Let say Box B will resume the ip of Box A but different hostname.
You will be unable to detach replicated databases. You have to script out
the publications, edit them for the new server, remove all job names, and
then drop the publications, unpublish the databases and detach them. Attach
them on the new server, run the publication script and do a non sync.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"YK" <YK@.discussions.microsoft.com> wrote in message
news:25A6D0F1-6C2C-4B95-84F5-C96B963335D0@.microsoft.com...
> Hi all,
> I will be migrating a production database to a new box. I will be using
> detach and attach db method to migrate, but I forsee that my replication
job
> will break. Can anyone advise me on how to migrate the replication jobs
over
> to the new db? Here is the sencario:
> DB-1 in Box A detach and move over to Box B to be reattached,
> DB-1 in Box A has some publications and subscriptions, and the
distribution
> is in Box C.
> Let say Box B will resume the ip of Box A but different hostname.
>

Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005
?
2. How do I copy all my Jobs from 2000 to 2005?1) http://blogs.msdn.com/lcris/archive.../03/567680.aspx
2) Re-create them
"" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>|||Hi
To add to Uri's answer
"??" wrote:

> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?[/vbc
ol]
Also check out http://support.microsoft.com/kb/246133/
[vbcol=seagreen]
> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John

Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005?
2. How do I copy all my Jobs from 2000 to 2005?
1) http://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx
2) Re-create them
"" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>
|||Hi
To add to Uri's answer
"??" wrote:

> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?
Also check out http://support.microsoft.com/kb/246133/

> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John

Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005?
2. How do I copy all my Jobs from 2000 to 2005?1) http://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx
2) Re-create them
"âì" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>|||Hi
To add to Uri's answer
"×?×?" wrote:
> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?
Also check out http://support.microsoft.com/kb/246133/
> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John

Migrating to a new database server

I need to migrate the DTS, the jobs, users and everything from a
database on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to
another (Windows Server 2003, SQL 2000). The databases that do not
already exist on the new server I can restore those from a backup just fine.
The ones that exist (master, model, msdb) I can't copy over from a
restore. It tells me that exclusive access could not be obtained
because the database is in use.
Is there an easy/straightforward way to get everything - especially DTS
and the batch jobs - from my old server to the new one?
Any advice appreciated.
BCSee this post from yesterday: "Moving a DB from 1 Server 2 another".
HTH
Jerry
"Blasting Cap" <goober@.christian.net> wrote in message
news:Ogobt0qeGHA.2456@.TK2MSFTNGP04.phx.gbl...

>I need to migrate the DTS, the jobs, users and everything from a database
>on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to another
>(Windows Server 2003, SQL 2000). The databases that do not already exist
>on the new server I can restore those from a backup just fine.
> The ones that exist (master, model, msdb) I can't copy over from a
> restore. It tells me that exclusive access could not be obtained because
> the database is in use.
> Is there an easy/straightforward way to get everything - especially DTS
> and the batch jobs - from my old server to the new one?
> Any advice appreciated.
> BC
>

Migrating to a new database server

I need to migrate the DTS, the jobs, users and everything from a
database on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to
another (Windows Server 2003, SQL 2000). The databases that do not
already exist on the new server I can restore those from a backup just fine.
The ones that exist (master, model, msdb) I can't copy over from a
restore. It tells me that exclusive access could not be obtained
because the database is in use.
Is there an easy/straightforward way to get everything - especially DTS
and the batch jobs - from my old server to the new one?
Any advice appreciated.
BCSee this post from yesterday: "Moving a DB from 1 Server 2 another".
HTH
Jerry
"Blasting Cap" <goober@.christian.net> wrote in message
news:Ogobt0qeGHA.2456@.TK2MSFTNGP04.phx.gbl...
>I need to migrate the DTS, the jobs, users and everything from a database
>on a Windows 2000 server (SQL 2000, upgraded from SQL 7), to another
>(Windows Server 2003, SQL 2000). The databases that do not already exist
>on the new server I can restore those from a backup just fine.
> The ones that exist (master, model, msdb) I can't copy over from a
> restore. It tells me that exclusive access could not be obtained because
> the database is in use.
> Is there an easy/straightforward way to get everything - especially DTS
> and the batch jobs - from my old server to the new one?
> Any advice appreciated.
> BC
>