Interview Questions - What is MSX / TSX in SQL Agent ?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

What is MSX / TSX in SQL Agent ?

Jul 23 2012 12:00AM by Ankit Shah

Question

What is MSX / TSX in SQL Agent ?

Answer

Master Server (MSX)

The master server (MSX) is the host server where jobs, job steps, and schedules are created. Additionally, job results will flow from the target server(s) to the master server. You can view results from all job on the master server.

Target Server (TSX)

The target server (TSX) consists of one or more servers that are configured to accept jobs from a master server, and to report the results when those jobs are run back to the master server (MSX). The target servers will occasionally connect to the MSX server to download jobs, and updates to jobs.

Read More.. [61 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: While database is recovering, after which phase will the database be available/online?
Next: What are the ways to code efficient transactions?

Ankit Shah

291 · 0% · 147

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"What is MSX / TSX in SQL Agent ?" rated 5 out of 5 by 8 readers

What is MSX / TSX in SQL Agent ?

Question

Answer

Your Comment