The SQL Server Job Page defines the basic settings for the SQL Server Job Task.
Server Name
Enter the name or IP address of the computer where SQL Server is running. If you need to connect to a named instance of SQL Server, include the instance name as follows:
servername\instancename
Job Name
Enter the name of the job to execute.
Monitor the job
Check this option to have adTempus wait for the SQL Server job to complete. The status of the step will then be set based on whether the SQL Server job succeeds, and Responses can be executed based on specific outcomes.
If this option is not checked, adTempus simply submits the SQL Server job and does not wait for it to execute.
Credentials
Specify the identity that adTempus should use to connect to SQL Server.
Use the job's credentials: adTempus will use integrated (Windows) security to connect to SQL Server. The Windows account that the job is executing under must have permission to log on to SQL Server and submit the job.
Use the following SQL Server login: adTempus will log in to SQL Server using the SQL Server user ID and password you specify. This option requires that SQL Server be configured to accept SQL Server security logins. The credentials you specify with this option are defined in SQL Server, and are not Windows credentials.
See Also