What are SQL Jobs, please mention the use of it and how to
create them.
- 1 Answers
- 4225 Views
- 247Customer, I also Faced
- E-Mail Answers
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
How can you find out how many rows returned in a cursor?
What authentication modes does sql server support?
Call by value and call by reference in procedure and function, with NOCOPY.
How to convert binary strings into integers in ms sql server?
What is a collation?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
explain what is raid and what are different types of raid configurations? : Sql server database administration
what is normalization? : Sql server database administration
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Explain how does the report manager work in ssrs?
When you use @@error and try-catch?
How to use the inserted and deleted pseudo tables?
List out the different types of locks available in sql server?
How to list all login names on the ms sql server?
