How are you guys handling when the server trigger kicks off when a user is in the dbcreator role but doesn't have access to insert into the table that houses...

I ran into the same issue. Options below to resolve your issue.

1) Make your sql server agant user account an sa

2) Give your sql server agent at least db_reader in...

I'll let you know how it goes.

Also, it would be great to instead of just monitoring one job but monitoring all jobs or all jobs within a certain Job Category....

Yes. I was manually starting this job so there was no schedule.

I created a schedule that runs every 1 minute. This job has one step that has WAITFOR DELAY '00:05:00'...

I re-copied the logic and then pasted it into ssms (query window) and removed some hidden characters and I'm getting below error now.

EXEC [master].dbo.xp_sqlagent_enum_jobs 1, 'DomainName\lawrence', 'B508F33F-8C69-42B9-9635-4CA66C05548D'

Msg 241, Level 16,...

I'm using sql 2008 sp1.

I do not get an error if the job is not running (EXEC [master].dbo.xp_sqlagent_enum_jobs 1, 'domainname\lawrence', 'B508F33F-8C69-42B9-9635-4CA66C05548D').

If the job is running I get the above error.

If...

Which versions have you tested this logic on? I'm getting below error.

Msg 8114, Level 16, State 1, Procedure xp_sqlagent_enum_jobs, Line 1

Error converting data type nvarchar to int.

Hi Paul,

Can you copy the code for exec Proc from dummy report. I'll have to the same thing you did.

Thanks,

L

Let's say there is a table called Employee. Employee table has columns as FirstName, LastName, Department, StartDate. I have a simple query for example select * from Employee . The...

You can create a *.bat file on the server it needs to run on and then on the remote server you want to execute it from run psexec.exe to execute...

Great!

Hi,

An option to authenticate across non-trusted domains is below.

1) The user account running ssas 2005 on domain AAA, create a local user account (it doesn't have to be a local...

You can copy the backup to another non-trusted domain without a trust. Just make sure the sql server agent account that is running on source is a local user on...

Hi Mattyk6,

I just finished setting up an automated process pretty close to what your asking I believe.

1) I have a nightly backup that overwrites the same db name on our production...

Hi,

You could setup Copy/Restore. After one of your nightly backups is done>sql job copies the DB to another server's shared drive>the other server restores the DB to that server.

See ya,

LL