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 |
Explain indexing and what are the advantages of it?
What are tables in sql server?
Mention the 3 ways to get a count of the number of records in a table.
How many types of cursors are there in SQL Server?
5 Answers 247Customer, CarrizalSoft Technologies,
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
Describe and explain about SQL native client?
What is open database communication (odbc)?
What is the difference between mysql and mysqli?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How to use subqueries with the in operators in ms sql server?
What are the difference between data length and length in SQL Server-2008?
Oracle (3259)
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)