June 8, 2012 at 10:40 am
SQL Agent - Jobs Failed: The SQL Agent Job "SQLjobname" has failed with the message "The job failed. The Job was invoked by Schedule 85 (Every15Minutes). The last step to run was step 1 (Check ACRREPORD). - Executed as user: domain\abcd. Servername Alert: 1 stuck processes found (ACRREPORD). [SQLSTATE 01000] (Message 0) No global profile is configured. Specify a profile name in the @profile_name parameter. [SQLSTATE 42000] (Error 14636). The step failed."
Please let me know how to add global variable. thanks
June 8, 2012 at 12:02 pm
This looks like you don't have a default profile in your Database Mail.
Right click Database Mail, in SSMS.
Click Next.
Select the Manage profile security option.
Click Next.
On the Public Profiles tab, select a public profile name, and change the Default Profile to Yes.
Click Next.
Click Finish.
June 8, 2012 at 12:14 pm
or this;
select profile_id, name from [msdb].[dbo].[sysmail_profile]
/*
update [msdb].[dbo].[sysmail_principalprofile]
set is_default = 1
where profile_id = --Enter the profile_id number you want to make default
*/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply