The sqlagent.properties file contains values to configure the JDBC connection and filter the fields displayed in the job spool file. You can change these values in the system properties file if most of your SQL Server instances use the same values. If a SQL Server instance has unique values for these properties, add the properties to the target server database properties file created for that instance to override the default values.
The sqlagent.properties file contains the following settings for configuring the JDBC connection:
Specifies the number of times the agent tries to reconnect to the SQL Server instance before reporting a failure. The Retry.interval property controls how long the agent waits between reconnection attempts.
Default: 2
Specifies the interval in seconds between attempts to connect to the SQL Server instance. When "connection refused" occurs during the JDBC call, the agent attempts to reconnect after the specified interval. The max.retry property controls the number of reconnection attempts.
Default: 60 seconds
Specifies how often in seconds the agent polls the SQL Server database for job execution status information.
Default: 60 seconds
Note: As you increase the frequency that the agent accesses the SQL Server database, you decrease the available resources SQL Server has to serve other user requests.
Specifies whether the job history of the current execution is captured and stored in the spool file for the RunJob CLI operation. The following values are available:
Indicates that the job history is always stored in the spool file for the RunJob operation.
Indicates that the job history is stored in the spool file for the RunJob operation only when the job fails or is canceled. To get the job history for the RunJob operation when the job is successful, use the GetJobHistory operation.
Indicates that no job history is stored in the spool file for the RunJob operation. To get the job history for the RunJob operation, use the GetJobHistory operation.
Default: *FAILURE
Specifies the name of the JDBC driver the agent uses to create a JDBC connection.
The sqlagent.properties file contains the following settings for filtering the fields displayed in the spool file for each CLI operation:
Specifies the fields that are displayed in the spool file for the GetJobList operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: job_id|name|description
Note: For the GetJobList operation, the rows displayed in the spool file are sorted based on the order the columns appear in the filter. By default, the rows are sorted by job_id first, followed by name. If GetJobList=name|job_id|description, the rows are sorted by name first, followed by job_id.
Specifies the fields that are displayed in the spool file for the GetJobDefault operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: job_id|originating_server|name|enabled|description|category|owner|date_modified
Specifies the fields that are displayed in the spool file for the GetJobStep operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: step_id|step_name|subsystem|command
Specifies the fields that are displayed in the spool file for the GetJobTargetServer operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: server_id|server_name|enlist_date
Specifies the fields that are displayed in the spool file for the GetJobHistory operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: step_id|step_name|sql_message_id|sql_severity|message|run_status|run_date|run_time|run_duration
Specifies the fields that are displayed in the spool file for the GetStepLog operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: *ALL
Specifies the fields that are displayed in the spool file for the GetJobStatus operation. Separate each field with a vertical bar (|). To display all available fields, specify *ALL.
Default: job_id|originating_server|name|last_run_date|last_run_time|last_run_outcome|current_execution_status|current_execution_step|current_retry_attempt|type
Example: Default System Properties
This example shows the default system properties in the sqlagent.properties file:
#this properties file defines general configuration that's applied to all target #database
#the following property defines the class used to create jdbc connection
db.classname=net.sourceforge.jtds.jdbc.Driver
#the following properties defines the column(s) that will be viewable to end user #for command GetJobList
GetJobList=job_id|name|description
#the following properties defines the column(s) that will be viewable to end user #for command GetJobDetail
GetJobDetail=job_id|originating_server|name|enabled|description|category|owner|date_modified
#the following properties defines the column(s) that will be viewable to end user #for command GetJobStep
GetJobStep=step_id|step_name|subsystem|command
#the following properties defines the column(s) that will be viewable to end user #for command GetJobTargetServer
GetJobTargetServer=server_id|server_name|enlist_date
#the following properties defines the column(s) that will be viewable to end user #for command GetJobHistory
GetJobHistory=step_id|step_name|sql_message_id|sql_severity|message|run_status|run_date|run_time|run_duration
#the following properties defines the column(s) that will be viewable to end user #for command GetStepLog
GetJobStepLog=*ALL
#the following properties defines the column(s) that will be viewable to end user #for command GetJobStatus
GetJobStatus=job_id|originating_server|name|last_run_date|last_run_time|last_run_outcome|current_execution_status|current_execution_step|current_retry_attempt|type
#this property defines the maximum number of reconnect attempt agent would make if #"connection refused" error happens
max.retry=2
#this property defines the number of seconds agent wait between every reconnect #attempt if "connection refused" error happens
Retry.interval=60
#this property defines the number of seconds agent should pool sql server database #for job execution status.
monitor.poll.interval=60
|
Copyright © 2013 CA.
All rights reserved.
|
|