Thank you!

;WITH cte AS

(

SELECT ABS(CHECKSUM(NEWID())) random_number

UNION ALL

SELECT ABS(CHECKSUM(NEWID())) random_number

)

SELECT

random_number

,RANK() OVER(ORDER BY random_number) as rnk

FROM

cte

Ok, Ok. I just sorted it out.

The problem was here:

SET @querysendmaildynamic = N'SELECT @sendmailss = flag FROM [' + @jobname + ']'

My code was:

SET @querysendmaildynamic = N'SELECT flag FROM...

This won't help neither. This doesn't work. 🙁

Btw, please note that the datatype is not VARCHAR(11) but TINYINT.

Anyways, my point is not to print the value but to pass the value to the parameter.

According to BOL this...

Changed the sp to the following but I face a new problem. When the job fails to start I don't receive the failure message. In addition I tried to call...

nope 🙁

http://connect.microsoft.com/SQLServer/feedback/details/362112/sp-start-job-error-handling

I think try..catch statements don't work with sp_start_job.

Could you please help me with the try-catch statement?

My sp looks like this:

ALTER PROCEDURE [dbo].[usp_consolidation_user_initiate]

@jobname VARCHAR(255),

@confirmation TINYINT

AS

IF @confirmation = 0

BEGIN

SELECT 'The job did not initiate because confirmation has to be...

Ok, I created a report for this but I need to know how I can handle the sp_start_job result?

For instance when I receive the message

"Job <jobname> started successfully."

or

"Msg 22022,...

Hmmmmm I like the SSRS idea!

No worries! Thanks anyway!

Anybody else having something in mind?

Any ready solutions so that I avoid coding?

I could use CMD commands for example. But are you aware of any other solutions? Even an app (not webpage) would be fine!

Hey Bradley,

Thanks for the reply! My issue is not to create a stored procedure. My issue is if anybody knows a way to allow a normal user from the finance...

Hi there,

1. all files are copies of the same initial file (for testing purposes)

2. do you mean tables? if so yes, to the same table. But the error is before...

Just said to the user that creates the file to save it as .csv through excel. There is no mess with file names and sheet names.

It really made my life...