What is a job?
Answers were Sorted based on User's Feedback
Don't post rubbish Answer
Jobs : A job is a specified series of operations performed
sequentially by SQL Server Agent.
A job can perform a wide range of activities, including
running Transact-SQL scripts, command prompt applications,
Microsoft ActiveX scripts, Integration Services packages,
Analysis Services commands and queries, or Replication
tasks. Jobs can run repetitive or schedulable tasks, and
they can automatically notify users of job status by
generating alerts, thereby greatly simplifying SQL Server
administration.
More Information Click This Link
http://msdn.microsoft.com/en-us/library/ms186273.aspx
| Is This Answer Correct ? | 3 Yes | 0 No |
A job is a scheduled work and the repeated things are won't
run manually which has to be run regularly when the agent
is started position It is important the job is run only
when the sqlserver agent is in the start position
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the steps to follow to configure SQL*Net?
What is the use of Port no?
What is query and its types?
what are cursors? : Sql server database administration
Which are new data types introduced in sql server 2008?
What is use of @@ spid in sql server?
How to provide Security for package?
What are the steps need to be take improve the speed of a SQLDATA Server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How do I create a partition table in sql server?
What is the use of sign function?
List out different types of normalizations in sql server and explain each of them?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)