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 are defaults? : Sql server database administration
What are the different types of lock modes in sql server 2000?
What are the two authentication modes in sql server?
Explain system scalar functions?
What you can do to delete a table without the delete trigger firing?
Detail about query optimizer?
How to defragment table indexes?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is sql server schema compare? How we can compare two database schemas?
Difference between group by clause and having clause in SQL?
How do I open a .db file?
How are the unique and primary key constraints different?
What is the concept of optimization?
Can we insert data if clustered index is disabled?
How to invoke a trigger on demand?