Batch Jobs ..

Hi Frndz,

Will anyone plz help me in creating simple jobs in Sql Server. And how to run that Job. Actually i Created a job in the AGENT and schedule it daily at 2.30 pm . But it doesn't run automatically . . .

Thnx in Advance . .

Regards

(M. Nedu . . .)Hi,

The simple way to schedule a package is to right click on the package and you will get an option for scheduling. Once you are through it, you would find your package under "Jobs", check for the option which states "Enabled" and it should be "True". Try to run your Job manually and see whether it's executing fine. If it executes fine, then I am sure that it would execute on scheduled time.

Thanks & Regards
Mudasar

Quote:

Originally Posted by nedu

Hi Frndz,

Will anyone plz help me in creating simple jobs in Sql Server. And how to run that Job. Actually i Created a job in the AGENT and schedule it daily at 2.30 pm . But it doesn't run automatically . . .

Thnx in Advance . .

Regards

(M. Nedu . . .)

Batch Job

Hi,

I want to schedule a daily job using sql server to update the info. in a sql server table. This is very new to me. Could you please forward me some helpful resources.

Thanks,

First, what version of SQL Server? Second, did you install Books Online? If so, look up scheduled jobs.

Jeff

|||It is SQL Server 2000. Can you guys forward me to any website that has the details.|||You can create a job which runs a T-SQL script to do the update, and schedule the job to run.?Use?SQL?Book?Online?if?you?have. Here is a link for this:
Scheduling Jobs

Basic questions (Part 2)

1) How can I schedule a daily full backup of the AS Database ? I know in SQL
server, therese a SQL Agent that i can run a job .. But on my AS Server, all
I have is AS.. Also what the command to use ? Can one send me an example ?
2) I looked at the data folder and I see so many different files of
different file types.. Can one point me to some reference about what each
kind of file is ?
> 1) How can I schedule a daily full backup of the AS Database ? I know in
SQL
> server, therese a SQL Agent that i can run a job .. But on my AS Server,
all
> I have is AS.. Also what the command to use ? Can one send me an example ?
Look in BOL in the section which describes the msmdarch utility. You can use
SQL Agent to spawn a command line instance of msmdarch to create the
archive.

> 2) I looked at the data folder and I see so many different files of
> different file types.. Can one point me to some reference about what each
> kind of file is ?
This is talked about a bit in the Analysis Services Operations Guide at:
http://www.microsoft.com/technet/pro.../anservog.mspx
See appendix K.
Hope this helps.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uP%23rIdiMFHA.2736@.TK2MSFTNGP09.phx.gbl...
> 1) How can I schedule a daily full backup of the AS Database ? I know in
SQL
> server, therese a SQL Agent that i can run a job .. But on my AS Server,
all
> I have is AS.. Also what the command to use ? Can one send me an example ?
> 2) I looked at the data folder and I see so many different files of
> different file types.. Can one point me to some reference about what each
> kind of file is ?
>

Basic questions (Part 2)

1) How can I schedule a daily full backup of the AS Database ? I know in SQL
server, therese a SQL Agent that i can run a job .. But on my AS Server, all
I have is AS.. Also what the command to use ? Can one send me an example ?
2) I looked at the data folder and I see so many different files of
different file types.. Can one point me to some reference about what each
kind of file is ?> 1) How can I schedule a daily full backup of the AS Database ? I know in
SQL
> server, therese a SQL Agent that i can run a job .. But on my AS Server,
all
> I have is AS.. Also what the command to use ? Can one send me an example ?
Look in BOL in the section which describes the msmdarch utility. You can use
SQL Agent to spawn a command line instance of msmdarch to create the
archive.

> 2) I looked at the data folder and I see so many different files of
> different file types.. Can one point me to some reference about what each
> kind of file is ?
This is talked about a bit in the Analysis Services Operations Guide at:
http://www.microsoft.com/technet/pr...n/anservog.mspx
See appendix K.
Hope this helps.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uP%23rIdiMFHA.2736@.TK2MSFTNGP09.phx.gbl...
> 1) How can I schedule a daily full backup of the AS Database ? I know in
SQL
> server, therese a SQL Agent that i can run a job .. But on my AS Server,
all
> I have is AS.. Also what the command to use ? Can one send me an example ?
> 2) I looked at the data folder and I see so many different files of
> different file types.. Can one point me to some reference about what each
> kind of file is ?
>