how can I create a sql 2005 job?

Posted on 2007-10-03
Last Modified: 2010-03-19
Hello guys,

I made all the steps that is in SQL help, but I am having problem in command line :(((

Where can I get som examples about this?

Or someone could give me the steps

Question by:hidrau
    LVL 18

    Accepted Solution

    Examples on what ? Can you please be more specific on what is your problem ?

    Creating a job is just as easy as it was in SQL 2000. Using the SSMS, open the Agent folder, right click on 'Jobs' and select 'New ...'. I'm pretty sure that is not what you are looking for ...

    LVL 1

    Author Comment

    my problem is being in SQL 2005

    I imported all my jobs from SQL 2000 and none of them work :((
    LVL 18

    Expert Comment

    What type of jobs ? Jobs that will fire up a DTS will not work (or at least it's a pain) under SQL 2005.
    Other jobs, lets say which only run a SQL statement should work ...

    For the record, on which SP are you ? SP2 changed a lot in the job structure for SQL 2005 ...

    When you script out the jobs for SQL 2000, and run that script on the SQL 2005 machine, does that return any errors ?

    Hope this helps ...
    LVL 18

    Expert Comment

    ... or is it a permission issue ?
    Any extra info on errors you encounter is welcome !

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SQL HELP 2 65
    insert query with value having 's 2 27
    Query - which index being used? 2 25
    How to query LOCK_ESCALATION 4 26
    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now