email notifications scheduled jobs

In the notifications tab of the job I have e-mail operator selected. Click on the box with the elipses to enter the email addresses. It will let me enter 2 email addresses in the e-mail name field. It looks like the field has a limited length...is there a way to manually enter several addresses?http://www.sqlmag.com/Article/ArticleID/21450/sql_server_21450.html
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=31

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.
You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>
|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you nee
d
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> Edition Server. We setup some maintenance jobs under Database
>> Maintenance
>> and would like to setup e-mail notification. When we setup
>> notifications,
>> we got the following error message: "Error 22022: SQLServerAgent Error:
>> The SQLServer Agent mail session is not running; check the mail profile
>> and/or the SQLServerAgent service startup account in the SQLServerAgent
>> Properties dialog." What do we need to do? Please let us know if you
>> need
>> additional information. Thank you.
>>

Email Notification

Hi
I run a query against sysjobs table to turn off the email notification, but
still i am getting notification from jobs. Do I need to update any other
table while updating the sysjobs. I had the same issue when i was running a
query against sysjobschedules to reset the active start time . Any
suggestions are appreciable
Regards
SwamiDont know what you did to SysJobs for this, but you probably need to go to
each job and delete the entry from the notifications tab.
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:FB94A9AA-62EE-402C-9A2F-9399A30724F9@.microsoft.com...
> Hi
> I run a query against sysjobs table to turn off the email notification,
> but
> still i am getting notification from jobs. Do I need to update any other
> table while updating the sysjobs. I had the same issue when i was
> running a
> query against sysjobschedules to reset the active start time . Any
> suggestions are appreciable
> Regards
> Swami

Email Notification

Hi
I run a query against sysjobs table to turn off the email notification, but
still i am getting notification from jobs. Do I need to update any other
table while updating the sysjobs. I had the same issue when i was running a
query against sysjobschedules to reset the active start time . Any
suggestions are appreciable
Regards
Swami
Dont know what you did to SysJobs for this, but you probably need to go to
each job and delete the entry from the notifications tab.
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:FB94A9AA-62EE-402C-9A2F-9399A30724F9@.microsoft.com...
> Hi
> I run a query against sysjobs table to turn off the email notification,
> but
> still i am getting notification from jobs. Do I need to update any other
> table while updating the sysjobs. I had the same issue when i was
> running a
> query against sysjobschedules to reset the active start time . Any
> suggestions are appreciable
> Regards
> Swami

Email Notification

Hi
I run a query against sysjobs table to turn off the email notification, but
still i am getting notification from jobs. Do I need to update any other
table while updating the sysjobs. I had the same issue when i was running
a
query against sysjobschedules to reset the active start time . Any
suggestions are appreciable
Regards
SwamiDont know what you did to SysJobs for this, but you probably need to go to
each job and delete the entry from the notifications tab.
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:FB94A9AA-62EE-402C-9A2F-9399A30724F9@.microsoft.com...
> Hi
> I run a query against sysjobs table to turn off the email notification,
> but
> still i am getting notification from jobs. Do I need to update any other
> table while updating the sysjobs. I had the same issue when i was
> running a
> query against sysjobschedules to reset the active start time . Any
> suggestions are appreciable
> Regards
> Swami

EM: Jobs: Runnable column

Hi,
I havent been able to figure out when a job is marked as not runnable.
I have several jobs, some enabled, some disabled, but they are all marked
as runnable.
Someone who can tell?A job without any jobsteps isn't runnable.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns96FE6969F3064gurbaohotmailcom@.129.250.171.66...
> Hi,
> I havent been able to figure out when a job is marked as not runnable.
> I have several jobs, some enabled, some disabled, but they are all marked
> as runnable.
> Someone who can tell?

Editing SQL Jobs

I have scheduled a T-SQL job that runs every morning using Enterprise Manager. Now I want to change the SELECT and UPDATE statements that this job runs, but I can't find anywhere to edit a job that has already been scheduled. Any help would be appreciated.

ThanksIn Enterprise Manager, under your SQL Server
-- expand the Management node
-- expand the SQL Server Agent node
-- click on Jobs
-- right-click on your job and choose Properties
-- click on the Steps tab
-- click on the desired Step and choose Edit...

Terri