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 |
What command is used to delete a table from the database in the sql server and how?
What is temporary table in sql server? Why we use temp table?
what is database replication? : Sql server database administration
what protocol both networks use? : Sql server database administration
How to provide column names in insert statements in ms sql server?
Explain what is row_number function?
What is b tree index?
What is sql server schema compare? How we can compare two database schemas?
How can I change procedure name in sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Do you know concepts and capabilities of sql server?
What is sql server transaction log file?