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



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

Answer / 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

More SQL Server Interview Questions

What is the server name in sql server?

0 Answers  


What are some examples of schemas?

0 Answers  


What is SQL Profiler and the use of it?

2 Answers   247Customer,


Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  


Do you know what is difference between index seek vs. Index scan?

0 Answers  






What do you understand by hotfixes and patches in sql server?

0 Answers  


What is the SQL?????????????????????????????

5 Answers   CMS,


Is the primary key column of a table an index in ms sql server?

0 Answers  


Explain about nested stored procedure?

0 Answers  


Explain a differential backup?

0 Answers  


How to provide default values to function parameters?

0 Answers  


How to edit table in sql server 2017?

0 Answers  


Categories