RE: SQL server and JOB

Firstly Arslan, it should probably be pointed out that this is an Oracle list, not SQLServer. But, seeing as I deal with both database types, I'll have a stab at this..

You can create jobs under the "SQLServer Agent". If you open up SQLServer's Enterprise Manager, and navigate to your "Server", there is a directory tree there called "Management", and under that will be "SQL Server Agent", which manages three things - "Alerts", "Operators" and "Jobs".. If you highlight Jobs, then right mouse button click on the (probably) empty window on the right, you'll get a menu option to insert a "New Job...".

HTH Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----
A.Bahar_at_billing-components.com
Sent: 16 January 2004 12:59
To: Multiple recipients of list ORACLE-L

Hi ,
 How can i create a job in sql server ?

Rgds.
Arslan.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <A.Bahar_at_billing-components.com
  INET: A.Bahar_at_billing-components.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).