GlacierCall me old school, but sometimes I'd like to just print out a SQL Server agent job for review.

Is there a built-in feature for this?

Does somebody know of an external script, shareware tool, etc. that can do this?

Thanks!

---Wayne

SQL Server 2005:

Open Management Studio
Open Object Explorer
Expand (server/instance x) registration
Expand SQL Server Agent
Expand Jobs
Right-click (job x) and choose Script Job As > Create To >
Choose New Query Editor Window, FIle, or Clipboard

SQL Server 2000:

Open Enterprise Mangler
Expand (server/instance x) registration
Expand Management
Expand SQL Server Agent
Left-click on Jobs
In the right-hand pane, Right-click (job x) and choose All Tasks > Generate
SQL Script
Enter a file name (with path)
Click OK


GlacierCall me old school, but sometimes I'd like to just print out a SQL
Server agent job for review.

Is there a built-in feature for this?

Does somebody know of an external script, shareware tool, etc. that can do
this?

Thanks!

---Wayne

I did that, but the "substance" of the stored procedures (what the steps execute) is a relatively small percentage of the total script.

I was looking for something more formatted, and thought maybe there was something like that as part of somebody's tool or add-on.  "print" and "job" are so common that I just get a lot of useless pages when I do a [e.g. Google] search.

---Wayne
  SQL Server 2005:

  Open Management Studio
  Open Object Explorer
  Expand (server/instance x) registration
  Expand SQL Server Agent
  Expand Jobs
  Right-click (job x) and choose Script Job As > Create To >
  Choose New Query Editor Window, FIle, or Clipboard

  SQL Server 2000:

  Open Enterprise Mangler
  Expand (server/instance x) registration
  Expand Management
  Expand SQL Server Agent
  Left-click on Jobs
  In the right-hand pane, Right-click (job x) and choose All Tasks > Generate
  SQL Script
  Enter a file name (with path)
  Click OK


  GlacierCall me old school, but sometimes I'd like to just print out a SQL
  Server agent job for review.

  Is there a built-in feature for this?

  Does somebody know of an external script, shareware tool, etc. that can do
  this?

  Thanks!

  ---Wayne

So are you saying that you only care about the SQL code embedded within each
step?  Then you are not trying to print the job, you are trying to print the
SQL code and/or the stored procedures that are called.

Ideally, your jeb steps call stored procedures, then it's just a matter of
EXEC sp_helptext procedure_name and printing the result.

Otherwise, you have to go after the raw SQL code in the sys tables in msdb.

What version of SQL Server are you using?





I did that, but the "substance" of the stored procedures (what the steps
execute) is a relatively small percentage of the total script.

I was looking for something more formatted, and thought maybe there was
something like that as part of somebody's tool or add-on.  "print" and "job"
are so common that I just get a lot of useless pages when I do a [e.g.
Google] search.

---Wayne

Thanks for sticking around.

I'm just looking for something to bring a multiple step job together as a whole (and that I will be able to print for reference).  For example:

Step 1 "name of step"  (database=<database>)

EXEC INITIALIZE_BIG_JOB

Step 2 "name of step" (database=<database>)

EXEC INSERT_SOME_DATA

Step 2 "name of step" (database=<database>)

EXEC UPDATE_SOME_DATA


and so on.

I'm using SSMS as my front end, mostly with SQL Server 2000 data bases.

I guess I could put something together from the sys tables.  I found a real useful tool to sort project files in SSMS, and just thought somebody must have written some tools to help with SQL jobs.

Thanks again.

---Wayne
  So are you saying that you only care about the SQL code embedded within each
  step?  Then you are not trying to print the job, you are trying to print the
  SQL code and/or the stored procedures that are called.

  Ideally, your jeb steps call stored procedures, then it's just a matter of
  EXEC sp_helptext procedure_name and printing the result.

  Otherwise, you have to go after the raw SQL code in the sys tables in msdb.

  What version of SQL Server are you using?





  I did that, but the "substance" of the stored procedures (what the steps
  execute) is a relatively small percentage of the total script.

  I was looking for something more formatted, and thought maybe there was
  something like that as part of somebody's tool or add-on.  "print" and "job"
  are so common that I just get a lot of useless pages when I do a [e.g.
  Google] search.

  ---Wayne

Query to split Firstname Lastname into 2 fields
Profiler: SQL:StmtRecompile - EvenSubClass definitions?
Why I can't change collation w/ Query Analyzer, but can do that w/
Maintenance Plan Changes in SQL Server 2005 SP2
sp_trace_setfilter does not work