Batch Jobs

Is there a forum, documentation, link, or anything that talks about batch jobs, what they are, how to create them, run them, etc? Basically, everything I need to know about batch jobs?

thx,

Kat

What do you mean by batch jobs ? Do you mean Jobs that are executed by SQL Server Agent ? If so, I would recommend to get a book about SQL Server administration which dives deeper into the sense and the functionality of SQL Server Agent.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

I've been working with version 2000. Running a batch job to me is different for instance than running a proc (I think)... typically a batch job runs overnight because it takes a long time. I'm not sure what the definition of a batch job is. I believe it is a script that is run that takes a long time. Any ideas?

Kat

|||

Hi there - Whenever most DBAs talk about "batch" they usually just mean a set of SQL statements. If you save these in a file, they are also called a "script". If you run these scripts automatically, either using the SQL Server Agent (in what is called a "job") it's called a "batch job". To be even more confusing, some DBAs refer to a transaction (which is one statement alone or separated with a GO) to mean "batch".

Tell me what you're having issues with and I'll try to help.

Buck Woody

http://www.buckwoody.com

|||

Hi Buck,

This was just a question of definition and you explained it perfectly, thanks much!

Kat

|||If you don't need anything else on this thread, feel free to mark the answer as complete.

Batch Jobs

Is there a forum, documentation, link, or anything that talks about batch jobs, what they are, how to create them, run them, etc? Basically, everything I need to know about batch jobs?

thx,

Kat

What do you mean by batch jobs ? Do you mean Jobs that are executed by SQL Server Agent ? If so, I would recommend to get a book about SQL Server administration which dives deeper into the sense and the functionality of SQL Server Agent.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

I've been working with version 2000. Running a batch job to me is different for instance than running a proc (I think)... typically a batch job runs overnight because it takes a long time. I'm not sure what the definition of a batch job is. I believe it is a script that is run that takes a long time. Any ideas?

Kat

|||

Hi there - Whenever most DBAs talk about "batch" they usually just mean a set of SQL statements. If you save these in a file, they are also called a "script". If you run these scripts automatically, either using the SQL Server Agent (in what is called a "job") it's called a "batch job". To be even more confusing, some DBAs refer to a transaction (which is one statement alone or separated with a GO) to mean "batch".

Tell me what you're having issues with and I'll try to help.

Buck Woody

http://www.buckwoody.com

|||

Hi Buck,

This was just a question of definition and you explained it perfectly, thanks much!

Kat

|||If you don't need anything else on this thread, feel free to mark the answer as complete.

Basics Question for Non tecnical people

Hi, Anybody can give me a link where I can find basic information about
SQLserver2000.
I mean information like how many records a DB can hold, those questions that
have no answer in the product overview or What are the advantages comparing
it to Oracle etc.
I need to talk to Non technical people, and those are pretty much the
questions they ask.
ThanksHi
There are plenty of case studies and information on the SQL server web site
www.microsoft.com/sql. It would make more sense to compare SQL 2005 if you
are looking at a new purchase.
As far as number of records, the capacity is really dependent on hardware
and design rather than the DBMS for both.
John
"Kenny M." wrote:

> Hi, Anybody can give me a link where I can find basic information about
> SQLserver2000.
> I mean information like how many records a DB can hold, those questions th
at
> have no answer in the product overview or What are the advantages comparin
g
> it to Oracle etc.
> I need to talk to Non technical people, and those are pretty much the
> questions they ask.
> Thanks|||John Bell a écrit :
> Hi
> There are plenty of case studies and information on the SQL server web sit
e
> www.microsoft.com/sql. It would make more sense to compare SQL 2005 if you
> are looking at a new purchase.
> As far as number of records, the capacity is really dependent on hardware
> and design rather than the DBMS for both.
> John
> "Kenny M." wrote:
>
About how many rows wich must be query as how much data cans I have in
SQL Server, according to Wintercorp, there is a firm that use SQL Server
for _ 20 To database...
A +
Frédéric BROUARD, MVP SQL Server, expert bases de données et langage SQL
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
********************* http://www.datasapiens.com ***********************