Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
|
sql agent - Agent XP
|
enables the server agent extended SPs on this server. Management studio object explorer does not display the contents of the SQL server Agent node unless these extended stored procedures are enabled regardless of the service state
|
|
|
Agent XP setting
|
0 - extended SPs not available (default)
1 - extended SPs available |
|
|
setting via TSQL
|
sp_configure 'show advanced options', 1;
GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO |
|
|
Options - limit size of job history log
|
sets the limit for the amount of job history info that teh sql server agent retains in the log
|
|
|
Options - Maximum job history log size in rows
|
sets the max number of rows that the Agent retains. When the max is reached the agent removes the oldest rows in the log as new rows are entered
|
|
|
Options - maximum job hsitory rows per job
|
sets the max number of rows that the Agent retains per job. When the history for a particular job grows to contain this number of rows, the Agent removes the oldest rows in the log as new rows are entered
|
|
|
Options - Remove agent history
|
specifies that the Agent will remove entries that have been in the log longer than a specified length of time. this is a one time execution to remove the history. If a recurring job is needed, create an schedule a maintenance plan w/ a cleanup job.
|
|
|
Options - Older than
|
sets the amount of time that the Agent will retain entries.
|
|
|
Proxy
|
defines the security context for a job step. Provides the Agent w/access to the security credentials for a MS windows user. Can be associated w/ 1 or more subsystems. Before the Agent runs a job step that uses a proxy, the Agent impersonates the credentials defined in the proxy, and then runs the job step by using that security context.
|
|
|
Sql Server Alias for the sql server agent service - limitations
|
the Agent will not work correctly unless you select an alias that refers to the local instance of sql server
Object explorer only displays the Agent node if you have permissions to use it. |
|
|
Sql Server Alias for the sql server agent service - permissions
|
the Agent must be configured to use the credentials of an account that is a member of hte sysadmin fixed server role and the following windows permissions.
-logon as service -replace a process-level token -bypass traverse checking -adjust memory quotas for a process |
