1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is a job?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is a job?..

Answer / sudhir kumar pal

Don't post rubbish Answer

Jobs : A job is a specified series of operations performed
sequentially by SQL Server Agent.
A job can perform a wide range of activities, including
running Transact-SQL scripts, command prompt applications,
Microsoft ActiveX scripts, Integration Services packages,
Analysis Services commands and queries, or Replication
tasks. Jobs can run repetitive or schedulable tasks, and
they can automatically notify users of job status by
generating alerts, thereby greatly simplifying SQL Server
administration.


More Information Click This Link


http://msdn.microsoft.com/en-us/library/ms186273.aspx

Is This Answer Correct ?    3 Yes 0 No

What is a job?..

Answer / srisenthil

A job is a scheduled work and the repeated things are won't
run manually which has to be run regularly when the agent
is started position It is important the job is run only
when the sqlserver agent is in the start position

Is This Answer Correct ?    2 Yes 0 No

What is a job?..

Answer / skybeaver

Someplace they have to pay you to be.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is the main purpose of having conversation group?

0 Answers  

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

What are the two modes of authentication in sql server?

0 Answers  

Explain the difference between clustered and non-clustered index?

0 Answers  




Explain steps of normalization?

0 Answers  

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

What is a Lock and let me know Different types of locks?

2 Answers  

Where is trigger in sql server?

0 Answers  

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

What triggers long term care?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories