Stored Procedure in Schedular - SQL Server Forums

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

SQL Server 2000 Forums

Transact-SQL (2000)

Stored Procedure in Schedular

Author

Topic

jabedin
Starting Member

28 Posts

Posted - 2004-04-13 : 23:47:24

Hi There,

I have a stored procedure running fine when under SQL Analyzer. I have created the procedure and when running using EXEC fn working OK. To have a regular run I have put that under SQL server agent--> job.
Have given a name and under step/Command, I have used EXEC Stored procedure name. Subsequently filled up all other info. But the job is seating idle.

I have sepent sometime in few different way but still no luck. Any help will be highly appreciate.

Regards

Jay
Bella Vista
NSW-2153

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-04-14 : 01:06:18

Is your SQL Server Agent service running ?

Is the job enabled ?

Does it have a "Next run time" (or whatever it's called)

Damian

jabedin
Starting Member

28 Posts

Posted - 2004-04-14 : 22:58:01

Thanks Damian.

The job was not enabled (ie not ticked). It's working fine now.

But I am having difficulties to send an email notification. Currently having a look into it. Any help would be highly appreciated.

Regards

Jay
Bella Vista
NSW-2153

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-04-14 : 23:08:23

Do you have SQLMail configured ? Have a look in Books Online for a step by step

Damian

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-04-14 : 23:09:08

Go into Enterprise Manager..Management...SQL Server Agent.
Right-click on the Agent, go to Properties, and click on the Test button.

Does it send an email from there?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

jabedin
Starting Member

28 Posts

Posted - 2004-04-15 : 00:12:43

Looks like my SQL Server agent mail service is not working. Now the stupid question is how do I configure the mail service.

Regards

Jay
Bella Vista
NSW-2153

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-04-15 : 00:14:34

Do you have Outlook installed on the SQL Server?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

jabedin
Starting Member

28 Posts

Posted - 2004-04-15 : 00:17:29

We are using MS Exchange for email.

Jay
Bella Vista
NSW-2153

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-04-15 : 00:22:55

Ok. You need to install Outlook on your SQL Server though. You need to have a MAPI client (Outlook) installed on the machine.

After you install it, you need to log into the machine with the account that SQL Server uses.

You then need to open Outlook and set it as your default mail client, giving it an email address, which you need to set up for the SQL Server account on Exchange.

After this is complete, you open Enterprise Manager....Properties...Server Settings and select the Exchange account in the email drop-down box.

You then need to do the same thing for SQL Agent. You can then set up operators, send mail, etc. If you need help at that point, let us know.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources