Job Failed [SQLSTATE 01000]

Question

Post reply

Job Failed [SQLSTATE 01000]

nalessa

Right there with Babe

Points: 767
More actions
November 23, 2008 at 11:51 pm

#128841

I get below message from my SQL scheduled job when i run
Job Name :Manage Login Creation Trace
job body:
--------------------------------------------------------------------------------
((EXEC usp_trace_login_creation 'OFF',@tracename='Login Creation on SQL-Server1 '
EXEC usp_trace_login_creation 'ON',@file_name ='F:\Microsoft SQL Server\MSSQL\Audit\',
@TraceName = 'Login Creation on SQL-Server1 ',
@Options = 2,
@TraceType = 8,
@MaxFileSize = 500,
@StopTime = NULL,
@Events = DEFAULT,
@Cols = DEFAULT,
@IncludeTextFilter = NULL,
@IncludeObjIdFilter = 7274611,
@ExcludeObjIdFilter = NULL))
----------------------------------------------------------------------------------------
Fail Message
Executed as user: SIDF\Administrator. Deleted trace queue 2. [SQLSTATE 01000] (Message 0) The trace output file name is: F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081120233001280.trc. [SQLSTATE 01000] (Message 0) No active traces named Login Creation on SQL-Server1 . [SQLSTATE 01000] (Message 0) Filters with the same event column ID must be grouped together. [SQLSTATE 42000] (Error 19055) Trace started. [SQLSTATE 01000] (Error 0) The trace file name is : F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081121233000543.trc [SQLSTATE 01000] (Error 0). The step failed.
------------------------------------------------------------------
In sql server2000 it was run successfully but now with sql2005 file is created fine but i got the above message.
could you please help me to solve this issues i got e-mail STATUS:Failed.
Thanks in advance.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

forsqlserver SSCoach Points: 18902 More actions · Answer 1

"No active traces named Login Creation on SQL-Server1"

Your trace is not recognizing by the sql server.Please check your user permissions inside the sql server for tha trace.

Thanks

nalessa Right there with Babe Points: 767 More actions · Answer 2

The strange thing i have another scheduled job running on same drive F:\Microsoft SQL Server\MSSQL\Audit\ and it's succussed

Job Name:Manage Trace

Job body:

((EXEC USP_TRACE_INFO 'OFF',@tracename='SQL-Server1 SQL Trace'

EXEC USP_TRACE_INFO 'ON',@file_name ='F:\Microsoft SQL Server\MSSQL\Audit\',

@TraceName = 'SQL-Server1 SQL Trace',

@Options = 2,

@TraceType = 5,

@MaxFileSize = 500,

@StopTime = NULL,

@Events = DEFAULT,

@Cols = DEFAULT,

@IncludeTextFilter = NULL,

@IncludeObjIdFilter = NULL,

@ExcludeObjIdFilter = NULL))

=================================================

Message after completion

((Executed as user: SIDF\Administrator. Deleted trace queue 3. [SQLSTATE 01000] (Message 0) The trace output file name is: F:\Microsoft SQL Server\MSSQL\Audit\SQL-Server1 SQL Trace20081122000000550.trc. [SQLSTATE 01000] (Message 0) No active traces named SQL-Server1 SQL Trace. [SQLSTATE 01000] (Message 0) Trace started. [SQLSTATE 01000] (Message 0) The trace file name is : F:\Microsoft SQL Server\MSSQL\Audit\SQL-Server1 SQL Trace20081123000001377.trc [SQLSTATE 01000] (Message 0). The step succeeded.))

=================================================

so , do you think it's permission and if it's permission problem what is the permission i should give to this user.

So , I am confused with that

nalessa Right there with Babe Points: 767 More actions · Answer 3

nalessa

Right there with Babe

Points: 767

November 24, 2008 at 10:53 pm

#902906

Any One help me to solve this issues

pom_iti Newbie Points: 3 More actions · Answer 4

May be there is more than 1 job and they do something at the same time and same thing.

May be they are conflict. I just guess. 😀