What are SQL Jobs, please mention the use of it and how to
create them.

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

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between equi join and inner join?

555


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

632


What are the types of user defined functions in sql server?

593


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1869


Can you explain various data region available in ssrs with their use?

625






What is the difference between coalesce() & isnull()?

630


What were the latest updates to SQL Azure service?

102


What are the pre-defined functions in the sql server?

606


What is SQL Azure Firewall?

124


Explain what are the restrictions while creating batches in sql server?

687


Can primary key be null?

599


what is the difference between a primary key and a unique key? : Sql server database administration

621


What is the recommended total size of your memory optimized tables?

617


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

628


How important do you consider cursors or while loops for a transactional database?

611