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.
没有评论:
发表评论