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
What is difference between equi join and inner join?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are the types of user defined functions in sql server?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Can you explain various data region available in ssrs with their use?
What is the difference between coalesce() & isnull()?
What were the latest updates to SQL Azure service?
What are the pre-defined functions in the sql server?
What is SQL Azure Firewall?
Explain what are the restrictions while creating batches in sql server?
Can primary key be null?
what is the difference between a primary key and a unique key? : Sql server database administration
What is the recommended total size of your memory optimized tables?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How important do you consider cursors or while loops for a transactional database?