SQL Server 2000 - job steps 1

[cmmrfrds]

I was looking in sql help for sql server 7 and it referenced some stored procedures(SP's) to set up jobs. These SP's don't seem to be in 2000. Can anybody point me to help for 2000? Is there another way to set up jobs in SQL Server 2000 besides the SP's like sp_add_job and sp_add_jobstep?

 

[tlbroadbent]

The same stored procedures exist in SQL 2000.

sp_add_job
sp_add_jobschedule
sp_add_jobstep
sp_delete_job
sp_help_job
sp_help_jobstep
sp_update_job

You can add jobs in SQL 7 or SQL 2000 with Enterprise Manager.

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[cmmrfrds]

I looked in the master database but for some reason these stored procedures don't show up on my sql server 2000. I will check into enterprise manager to create jobs. What I was trying to do was set up a script so that I could go to another server and add the same jobs.

 

[tlbroadbent]

Look in the msdb database for these procedures. Jobs are created and stored in msdb. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[cmmrfrds]

Thank you, looking in the right database made the difference.