Agents - Microsoft SQL Server - How To
Topics | How To | Related Topics
Browse the Latest Data
View Job History Details
Auto Discover New SQL Instances
Deconfigure a Client, MediaAgent, Agent, or Enabler
Change SQL Account
Delete the Agent
View the Software Version
The following procedure can be used to browse data from the client, agent, instance, or backup set level,
replication set level, depending on the functionality
of a given agent.
Required Capability: See
Capabilities and Permitted Actions
To browse the
latest data:
- From the CommCell Browser, right-click the level whose data you want to
browse, click All Tasks, and then click the Browse/Browse Backup
Data option from that level.
- From the Browse Options
dialog box,
click OK to execute the browse using the Browse the Latest Data option.
Required Capability: See
Capabilities and Permitted Actions
To
view the details of a job history:
- From the CommCell Browser, right-click the entity (e.g., subclient, client
computer, etc.) whose job history you want to view,
click View, and then
click job history.
- From the Job
History Filter dialog box, select the filter options that you want to apply and click OK.
- From the
Data Management Job
History window, right-click the job whose job details you want to view, and then click View
Job Details.
- The Job Details dialog box appears, displaying detailed job history in
General,
Details,
Phase
Details and
Attempts
tabs for the selected job.
- Click OK.
 |
If viewing the details of a job with a pending or failed status, the
Reason for Job Delay field will contain an Error Code, which, if clicked,
will launch the customer support website displaying troubleshooting article(s)
related to the specific issue. |
Required Capability: See
Capabilities and Permitted Actions
Before You Begin
To browse the
latest data:
- From the CommCell Browser, right-click the icon of the SQL
iDataAgent, and then click Properties
from the short-cut menu.
- In the General tab,
click Auto Discover New Instances to automatically discover instances
every 24 hours or whenever the Communications Service (GxCVD) service is
restarted.
Required Capabilities:
Capabilities and Permitted Actions
|
|
Administrative Management capability cannot be used to perform the deconfigure operation from the MediaAgent level.
|
Before you Begin:
-
For MediaAgent Deconfiguration, ensure that all the storage policies or copies
associated with the configured libraries (or drive pools) in the MediaAgent are
deleted or re-associated to another MediaAgent.
To deconfigure a
client, MediaAgent, agent, or enabler:
- In the CommCell Browser, right-click the name of the client, MediaAgent,
agent, or enabler you want to deconfigure, click All Tasks (if
displayed), and select Deconfigure.
- A popup warning message appears.
Click OK to continue.
- Another popup message then appears.
Click Yes to continue with the deconfiguration or No to abort.
- If the deconfigure is unsuccessful, a number of popup messages
appears. In some cases, the message requests that you take some
corrective action. For example, the message might advise you to ensure that there are no jobs running on the
agent. In such a case, click OK and take the appropriate action.
Then repeat the deconfigure process.
If the deconfigure is successful, the tree element is dimmed and available for deletion.
Before You Begin
You can perform agent operations as long as the agent is installed and
appears enabled in the CommCell Browser. However, if you have no need to
run jobs on the agent data of a client computer, you may want
to delete the agent that resides on that computer. Once you have uninstalled or DeConfigured
the agent, the corresponding icon in the CommCell Browser is grayed out. While
this icon exists, you can recover data from the agent to another client. If you
delete this icon, all of the agent's data is irretrievably lost.
NOTES
Deleting the agent is a two-phase process.
- You need to uninstall or DeConfigure the agent software
from the client computer. Doing so frees an agent license, thereby allowing
you to install it on some other computer whose data you do want to secure.
- After you delete the client software, you can either leave the corresponding
data
intact for appropriate action, or you can remove the data immediately. If you choose
to remove the data immediately, you must delete the agent from the CommCell
Browser.
Required Capability: See
Capabilities and Permitted Actions
To delete
an agent:
- From the CommCell Browser, right-click the icon of the agent that you want to delete, and then click Delete.
(The agent software must first have been uninstalled/DeConfigured or the delete option on the shortcut menu
will not appear.)
- A warning message prompts you with the following:
This operation will permanently delete the data backed up from this level
and it cannot be restored. Click Ok to continue with the
deletion operation. (Clicking No will abort the operation.)
- From the Confirmation Text dialog box, enter the confirmation
text string, erase and reuse media. Click
Ok. The agent icon and the data that corresponds to the selected agent
will be deleted. Consequently, you will not be able to browse or recover
this data.
Required Capability:
Capabilities and Permitted Actions
To
change the account for this SQL iDataAgent:
- From the CommCell Browser, right-click the icon of the appropriate agent, and then click Properties from the short-cut menu.
- From the Authentication tab of the
Agent dialog box, click Override higher
levels settings.
- Click either Use Local System Account or Impersonate User.
- If Impersonating a user, enter User Name and Password.
- Click OK.
To
view the Software Version:
- From the CommCell Browser, click the CommServe, Client,
Agent, MediaAgent, or Enabler for which you wish to view the version, and then click
Properties.
- Click the Version tab.
The component version and post release service pack, additional updates
and missing updates are displayed.