InterviewUp – Job Interview Questions and Answers – What do "jobs" and "alerts" mean in SQL Server ?

October 07, 2008

Home

Sign-In

My Interview Questions

Question & Additional Information

UPs

What do "jobs" and "alerts" mean in SQL Server ?

Comments (0) |

Inappropriate

Asked By: yendi

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

Jobs: Using SQL Server Agent you can create and schedule jobs that automate routine administrative tasks. Database administrators create jobs to perform predictable administrative functions either according to a schedule or in response of events and conditions. Jobs can be simple operations containing only a single job step or can be extremely complex operations containing many job steps. SQL Server Agent is responsible for management and execution of all jobs. Agent must be running for jobs to be executed. SQL server 2k supports jobs containing operating system commands. Alerts: database administrators define alerts to provide event and performance condition notification and to execute jobs in response to SQL server events or performance conditions. E.g. when the log is 90% full an alert can be configured to fire a job that executes a job to back up and truncate the transaction log.

Tags

Edit

SQL Server, Microsoft

Asked At

Edit

microsoft

Job Titles

Edit

Database Engineer

Comments (0) :

Your Name:

Add your comment text

Tags

interview, general, business, network, hr, human resource, SQL, integer, character, management, Flexibility, organization, efficiency, general interview, leadership, manager, human resources, Microsoft, accounting, work attitude, supervision, PUZZLE

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

Give me an example of a technical decision that you had to make on your last job.

Add or view comments about this interview question

Comments (1) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: Minerva |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Be the first one to answer the question Click here to answer

Create Date

Friday, March 21, 2008

Tags

interview, general, hr, human resource, job, management, jobs, general interview, human resources, engineering

Asked At

None

Job Positions

Civil Engineering, Mechanical Engineering

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

MIke

Monday, September 15, 2008 2:02 PM

Tea or Coffee? :P

See all 1 comments

UPs

A web-app having a database as a back-end can interact with it either by executing plain-sql or by calling stored-procs? what's better? using stored procedures or executing dynamic sql-queries?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

It depends what the logic is. If you need to do complex manipulation of data already in the database, it is probably better than trying to run sql queries and fetch the data into the middle tie and perform the manipulation in the middle tie, then send the large amount of data back to the database using sql insert or update. On the other hand, you can do to something simple using sql, but you have to write quite a lot of code in stored procedure, why do that.

For stored procedure vs. dynamic sql queries, assuming you are not talking about case where you can call stored procedure within a sql query or you can use dynamic sql inside a stored procedure, dynamic query has a downside (at least in Oracle db), that it has to be compiled if the exact sql string is not used recently (seconds I think) by any session, which could takes some time, and use some system resource. On the other hand, logic in stored procedure is not necessary automatically better.

I think you have to compare approaches based on how easy it is to write the code to do what you want, how easy it is for others to understand and maintain the code, and what is the performance cost in a target database, etc.

Create Date

Monday, May 05, 2008

Tags

database, SQL, stored Procedure

Asked At

None

Job Positions

developer, Programmer, database Administrator

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

If hired, how long do you plan to stay with the company?

Comments (0) |

Inappropriate

Asked By: walt1282 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

I may work till I die.... :-)

Create Date

Monday, April 21, 2008

Tags

business, job Development, jobs, general interview, leadership, all, career path

Asked At

Detroit Medical Center

Job Positions

Marketing Manager

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

Why do you want to work for this organization?

Comments (1) |

Inappropriate

Asked By: Matt |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Basically it is for financial purposes. However it does not mean that if given the chance to be employed in your company that I will just come in and out doing my daily tasks. I am want to be part of your company's work force family.

Create Date

Friday, March 21, 2008

Tags

interview, research, jobs, human resources, questions

Asked At

Fairmont Hotel

Job Positions

Clerk attendant

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

amrish puri

Saturday, March 22, 2008 11:36 AM