Answer Posted / subramaniam

sql job is scheduling the work into server and it will
automatically run and finish the job
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database

for this job we have to start the Sqlserver agent and
give the date and time for this particular job

How to convert binary strings into integers in ms sql server?

1027

---

What is read committed?

1084

---

Do you know hot add cpu in sql server 2008?

952

---

Explain the architecture of ms sql reporting service?

921

---

Define cross join in sql server joins?

1021

---

How to connect Azure federated root database and apply federation in entity framework?

107

---

What is your recommendation for a query running very slow? : sql server database administration

1046

---

which table keeps the locking information? : Sql server administration

1090

---

How to create a simple user defined function in ms sql server?

1020

---

How to get a list of columns using the "sys.columns" view in ms sql server?

954

---

What is advantage data architect?

923

---

What is sql server 2000 work load governor?

1064

---

How to include text values in sql statements?

1037

---

How to sort query output in descending order in ms sql server?

943

---

What command is used to rename the database?

1011

---