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
How do you implement session management in SQL Server mode?
What is a select query statement in ms sql server?
Explain the microsoft sql server delete command?
Is natural join and equi join same?
What do you mean by stored techniques? How would we use it?
What are “unrepeatable reads”?
What are the two modes of authentication in sql server?
What is tabulation?
Can multiple columns be used in sql group by clause in ms sql server?
What is the difference between primary key and unique constraints?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What are the disadvantages of using the stored procedures?
Can select statements be used on views in ms sql server?
What is the maximum size of a dimension? : sql server analysis services, ssas
What are out-of-range errors with date and time literals?