Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Job Scheduling

Author  Topic 

jaggyan
Starting Member

5 Posts

Posted - 2009-07-16 : 06:22:17
Hi All,

I am a beginer in Sql Server. I would like to know the equivallent of DBMS_JO/DBMS_SCHEDULE(oracle) in SQL Sever. In other words I would like to schedule a SP in command line and not thru GUI/Enterprise manager.

Can I have this info?

I am using Sql Server 2000.

Also, I appreciate if someone can give some links related to that.

Thanks in advance,
Jaggyam

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-16 : 06:42:53
http://msdn.microsoft.com/en-us/library/ms191439.aspx
http://www.sqlservercentral.com/articles/Administration/sqlserverjobscheduling/2288/

-------------------------
R..
Go to Top of Page

jaggyan
Starting Member

5 Posts

Posted - 2009-07-16 : 07:10:33
Thanks for the links.

Can I have some example codes.

Regards,
Jaggyam
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-07-16 : 13:11:16
http://www.mssqltips.com/tip.asp?tip=1730
Go to Top of Page
   

- Advertisement -