How do I schedule JOB in sql 2005

Can anyone please help me for scheduling JOB in sql 2005.

Thanks in advance.

Raviraj

[103 byte] By [RavirajDanasekaran] at [2007-12-22]

«« Unit of time-statistics in "client statistics"
»» How to debug a dll during deployment

# 1

You can't, there is no Agent.

You will have to find a third party program.

Expressman at 2007-8-30 >

top of Msdn Tech,SQL Server,SQL Server Express...

# 2

OK.

Could you please guide me to proceed further?

Thanks.

RavirajDanasekaran at 2007-8-30 >

# 3

Hi,

SQL Express doesnt have agent. I'll suggest you to upgrade to higher versions either workgroups or std.

Thanks

RubalJain at 2007-8-30 >

# 4

you could emulate the agent by writing a batch script that calls some sql commands using sqlcmd , then use windows "scheduled tasks" to give it a daily job... though scheduled tasks isnt super reliable IMO it can pretty much get the job done

nattylife at 2007-8-30 >

# 5

Nice idea!

Expressman at 2007-8-30 >

# 6

Yes indeed.

RubalJain at 2007-8-30 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'How do I schedule JOB in sql 2005...'

How do I schedule JOB in sql 2005

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified