|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Agents
Hi,
Can any one tell me, when I create SQL Server agent job and schedule it, What user does this run as? -- Thanks Kiran you can change that in the owner dropdown
Show quoteHide quote "Kiran Kumar Pinjala" <KiranKumarPinj***@discussions.microsoft.com> wrote in message news:BC29EB5B-0C86-4B17-857A-A8A176E34249@microsoft.com... > Hi, > Can any one tell me, when I create SQL Server agent job and schedule it, > What user does this run as? > -- > Thanks > Kiran Thanks.
Show quoteHide quote "Denis" wrote: > you can change that in the owner dropdown > > "Kiran Kumar Pinjala" <KiranKumarPinj***@discussions.microsoft.com> wrote in > message news:BC29EB5B-0C86-4B17-857A-A8A176E34249@microsoft.com... > > Hi, > > Can any one tell me, when I create SQL Server agent job and schedule it, > > What user does this run as? > > -- > > Thanks > > Kiran > > > If the job owner is a sysadmin, it runs under the security
context of the SQL Agent service account. If the job is owned by a non-sysadmin, it runs under the security context of the SQL Server Agent proxy account on SQL 2000 or SQLAgentCmdExec on SQL 7. -Sue On Mon, 21 Mar 2005 11:21:04 -0800, "Kiran Kumar Pinjala" <KiranKumarPinj***@discussions.microsoft.com> wrote: Show quoteHide quote >Hi, > Can any one tell me, when I create SQL Server agent job and schedule it, >What user does this run as?  
Other interesting topics
What's the equivalent to access' database compress/repair-function
Equivalent of ROWNUM in MS-SQL BUILTIN\Administrators Account Reducing log (ldf) file size can i using linked Server in mssql server 64 bit version? SP3a concurrency errors Q: default vaule for a field How full backup work ?? Delete records without logging SQLH2 |
|||||||||||||||||||||||
